NORRMALIZATION, Database Management System

Assignment Help:
Home based assignment
Consider an ORDER table with the following attributes:
• Order Number (ONo),Customer Number (CNo),Customer Name (CNa),Item Number (INo),Unit Price (UP), Quantity ordered (QO),Branch Number (BNo),Branch location (BLoc)

ONo CNo CNa INo UP QO BNo Bloc

1 241 Patel A10 5 10 15 Luton
1 241 Patel C13 3 20 12 York
1 241 Patel P15 7 18 30 London
2 250 Hall A10 5 15 15 Luton
2 250 Hall B16 12 2 25 London
2 250 Hall B20 8 1 25 London
2 250 Hall C13 3 5 12 York
3 241 Patel B16 12 11 15 Luton
3 241 Patel B21 2 15 30 London

ONo, CNo, INo, BNo are unique identifiers. The following assumptions have been made:
• Unit price does not depend on quantity
• An item only appears once on each order
• Customer do not get special discounts
• Customer can get items from any branch

Draw the determinacy diagram for the above data and apply normalization concepts upto 3NF. State any assumption that you make

Related Discussions:- NORRMALIZATION

3NF Normalization, Need 2 projects completed in 3NF format.

Need 2 projects completed in 3NF format.

Decomposition properteis, what is lossless & dependency preserving decompo...

what is lossless & dependency preserving decomposition ?

Explain the structured decomposition, Differentiate between the object orie...

Differentiate between the object oriented decomposition and the structured decomposition? Process-oriented (structural) decomposition divides a complex process, function or tas

A distributed transaction, A Distributed Transaction Let us demonstrate...

A Distributed Transaction Let us demonstrate the concept of a distributed transaction by considering a banking system having of three branches located in 3 different cities. Ev

Give an example of operations from the functions of a bank, Give an example...

Give an example of Operations from the functions of a bank. For creation of a saving account, you can write: bank::: create -savings-account (customer)->account. For oper

Explain the term- event, Event Occurrence of a process is called event...

Event Occurrence of a process is called event. In other words, the object can receive many input instructions. The changes which occur due to these instructions are known as e

Client dbms, i need to submit in this topic.

i need to submit in this topic.

Data model in DBMS, how many types of data model in DBMS? explain data abst...

how many types of data model in DBMS? explain data abstraction with its different level

Explain query execution plan, Explain query execution plan? - Optimizer...

Explain query execution plan? - Optimizer available in SQL Server optimizes code to be effectively executed. - A query execution plan demonstrates how this optimizer would r

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd