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

Replicating data, Replicating Data One approach that may support effici...

Replicating Data One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicate

Differentiate between logical database design and physical, Differentiate b...

Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas

What is the concept of knowledge discovery in database, Data Warehousing & ...

Data Warehousing & Mining 1. What is the concept of knowledge discovery in database? 2. Describe the following types of Multidimensional Data Models. • Stars, Snowflakes and

Erd, Table_Name( attribute_1, attribute_2, attribute_3, ….. ,attribute_x) ...

Table_Name( attribute_1, attribute_2, attribute_3, ….. ,attribute_x) Primary Key ( attribute_1, attribute_2) Foreign Key attribute_4 References Table_Name_2 (repeat for each fore

What is called a query evaluation plan, What is called a query evaluation p...

What is called a query evaluation plan? A sequence of primitive operations that can be used to assess a query is a query evaluation plan or a query implementation plan.

Employee elation with information, Consider a database application that dea...

Consider a database application that deals with an Employee relation with information such as SIN, name, data of birth (DOB), and DID (the ID of the department at which the employe

Write the syntax of creating an index, Write the syntax of creating an INDE...

Write the syntax of creating an INDEX ? Syntax of Creating an Index: CREATE [BITMAP] [UNIQUE] INDEX ON ( [, ] . . .);

What is called an evaluation primitive, What is called an evaluation primit...

What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.

Define single valued and multivalued attributes, Define single valued and m...

Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

Write short notes on extension and intension, Write short notes on extensio...

Write short notes on extension and intension? In any data model, it is significant to distinguish among the description of the database and the database itself the description

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