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
Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

Explain the θ-join and equijoin Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but sh

Differentiate between a Global and a Local temporary table? - A local temporary table exists only for the duration of a connection or if defined inside a compound statement, fo

PART MARKING:  We will only mark TWO of the four questions below but you must submit answers to all four. We will choose the questions we mark randomly and we will supply you with

What function divides one numeric expression by another and returns the remainder? MOD function divides one numeric expression by another and returns the remainder.

Question: (a) With the help of a diagram, explain the TOGAF framework for enterprise architectures. (b) Where would you position enterprise architectures in an enterpri

Mention various steps required to draw an E-R Diagram. Draw an E-R Diagram for Student Information System. Mention all suitable assumptions to justify your answer.

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Using a labelled diagram explain the operation of the Data Warehouse, define the basic architectural components and outline the main functionalities. Briefly explain the role an op