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

Discuss how the bi-directional implementations are made, Discuss how the bi...

Discuss how the bi-directional Implementations are made. In bi-directional implementation of the association, a pair of references must implement every link. The declarations a

State the two-way associations, Two-way Associations Mostly, associati...

Two-way Associations Mostly, associations are travel in both directions, although not usually with same frequency. There are three approaches for the implementation. In

Need web-based database, Our company hires independent contractors to insta...

Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

Describe the responsibilities of the dba and the database, Describe the res...

Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs

Create table to evaluating websites-reasoning, Have a look around the site,...

Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category

Describe drop table command or cascade of sql, Describe DROP TABLE command ...

Describe DROP TABLE command of SQL along with both the options - CASCADE and RESTRICT. DROP TABLE command - This command drops the specified table. Dropping a table also dro

Relational algebraic operators, Problem Explain at least five relationa...

Problem Explain at least five relational algebraic operators with a suitable example. Note: All the above descriptions should be done by taking at least two examples from ou

Which model is record based logical model, Which model is record based logi...

Which model is record based logical model? Network Modelis basically known as record based logical model.

Select statement-data manipulation language, SELECT Statement This stat...

SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

Database, real life situations where database management system are most su...

real life situations where database management system are most suitable

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