IT computre database normalization

crele2

help.docx

Home >Computer Science homework help >IT computre database normalization

Logical Table Form

Created By

Cathy Lambert

Created On Date

06/19/2014

Table Name	Pickup Manifest	Normal Form
Column Name	Attribute (Type, Size) (ie. Varchar, 30)	Key (PK, FK)	Constraints: date format, fixed data	Mandatory? (Y, N)
Customer Information
Pickup Details
Consignee information
Payment methods

Using the template put these tables Pickup Manifest, Delivery Truck Details, and delivery manifest in 1 normal form,2 nd normal form and third normal form. Each table must me in all three forms and explain changes in each table (why you made changes) from one form to the next. Show relationship as in 1 to 1, 1 to many, many to many .

Pickup Manifest

Customer information

Pickup details

Consignee information

Payment methods

Delivery Truck Details

Route number

Driver's name

Employee ID

Time logged out

List of delivery manifests

Delivery Manifest

Consignee information

Delivery details

Payment methods

Condition of goods delivered

Date of delivery

Consignee signature

Problems with delivery

Your supervisor wants to know if you understand how to normalize database models. Your supervisor requested that you create a first normal form logical database model from the ER diagram from the Unit 1 Individual Project. You must also include an explanation for why you made the changes from the original database using the first normal form rules.

You are then to create a second normal form logical database model and explain why you made the changes from the first normal form database using the second normal form rules.

Then, create a third normal form logical database model. Explain why you made the changes from the second normal form database using the third normal form rules.

Assignment Guidelines

Create 3 different databases from the Unit 1 Individual Project ER diagram: one in 1NF, the second in 2NF, and the third in 3NF.

Provide explanations for how you got from the ER diagram to the first database and then from each database to the next.

Compile the 3 databases along with the explanations into a single Word document.

Your submitted assignment (125 points) must include the following:

A Word document that contains your 1NF, 2NF, and 3NF database tables derived from the ER diagram of the Unit 1 Individual Project.

Include explanations for each database summarizing the steps you took to convert the database into the appropriate normal form.