NORRMALIZATION, Database Management System

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
Posted Date: 11/25/2013 1:24:41 AM | Location : Mauritius

Related Discussions:- NORRMALIZATION, Assignment Help, Ask Question on NORRMALIZATION, Get Answer, Expert's Help, NORRMALIZATION Discussions

Write discussion on NORRMALIZATION
Your posts are moderated
Related Questions
OPENCART - Want Massive amount of products Imported through CSV We have a massive list of products that would take completely too long to do data entry. We require a slick progr

What is average response time? The average response time is that the average time for a transaction to be done after it has been submitted.

System R was developed and designed over a period of 1974-79 at IBM San Jose Research Company. Its purpose was to illustrate that it is possible to create a Relational System tha

Problem 1. Write an assembly program to find the smallest among two numbers Writing an assembly program to find the smallest among two numbers 2. Explain the intern

What is Outer join?  They can be employed while we want to keep all the tuples in R, or all those in S or all those in both relations in the result of the JOIN in spite of of w

By which techniquesTransaction processing is associated? Transaction processing is associated by producing detail, summary, or exception reports and recording a business activi

Explain the disadvantages of using DBMS There could be a few disadvantages of using DBMS. As DBMS requires computers, we have to invest a good amount in acquiring the hardwa

One-to-one relationship: For every 1:1 relationship type R in the ER diagram including two entities E1 and E2 we take one of entities (say E1) preferably with total participatio

What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.

What are the problems if one were not to normalize?  When do these problems surface?           Ans:  Database normalization, sometimes considered to as  canonical synthesis, is