Update: The purpose of this assignment is to make an attempt to use Normalizatio

Question

Update:The purpose of this assignment is to make an attempt to use Normalization to construct a set of well-behaved tables for a specific database application.

Important Note: The format for the following assignment:

Customer(CustomerID, Name, Address, City, Phone)
Salesperson(EmployeeID, Name, Commission, Datehired)
SaleOrder(OrderID, OrderDate, CustomerID, EmployeeID)
OrderItem(OrderID, ItemID, Quantity, SalePrice)
Item(ItemID, Description, ListPrice)

Primary Keys are bold and underlined

Foreign Keys are italicized (This is my recommendation . . . you will not see this in the text)

Use this discussion area to share ideas and thoughts on the Normalization practice problem. Remember, your participation in this discussion is mandatory and part of your overall grade. I will provide some direction but I need to see participation from each and every one.

Explanation / Answer

Customer(CustomerID, Name, Address, City, Phone)
Salesperson(EmployeeID, Name, Commission, Datehired)
SaleOrder(OrderID, OrderDate, CustomerID, EmployeeID)
OrderItem(OrderID, ItemID, Quantity, SalePrice)
Item(ItemID, Description, ListPrice)

In database Normalization is nothing but a database schema design process, by modifiying existing schema to minimize anomolies and dependency of data.Generally Normalization devides large tables into smaller schemas and establishes relationships among them to increases effectiveness.

First Normal Form (1NF):
As per first normal form,each and every attribute in a table must be unique. That means there should no duplication.

So that as per given information the schema is already in 1NF.

Second Normal Form (2NF):

As per second normal form,schema should be in 1NF and attributes within that table should depend individually on primary key.
There are no partial dependencies in given relational schema. So that it is in 2NF.

Third Normal Form (3NF):

As per 3NF, schema should be in 2NF and there should no trivial dependencies.
There are no trivial dependencies also. So the schema is in 3nf too.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.