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
What is a function group? A function group is a collection of logically related modules that share global data with every other.  All the modules in the group are contained in

Can a filed occur in several field groups. Yes.  But it leads to redundant data redundancy.

various techniques of hashing?

Consider the subsequent relation   Professor (Pfcode, dept, head, time)   It is assumed that      (i) A professor can work in much more than one

each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one identified by isbn.each book writn by one

List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization

What is an ER diagram? Why is it used in Database management system (DBMS)?

#question benefits and limitations of data models..

Deadlock And Its Prevention: As seen earlier, though two phase locking protocol handles the trouble of serialisability, but it causes some troubles also. For instance, consider th

Define Database layer? The database layer defines the data formats used in the database.