Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

mis 320 assignment 4

/in /by

MIS 320 Assignment 4

Normalization Examples (Source: www.DBNormalization.com)

Q1. For the following Grades:
relation:
GRADES (Student_ID, Course#, Semester#, Grade)

Choose a key and write the dependencies

Explain your rationale for your choice of key.

What is the normal form of the relation? Why?

Q2. For the LINE_ITEMS relation:
LINE_ITEMS (PO_Number, ItemNum, PartNum, Description, Price, Qty)

Choose a key and write the dependencies

What normal form is the above LINE_ITEMS relation in?

Explain.

Q4: What normal form is the following relation in?
STORE_ITEM (SKU, PromotionID, Vendor, Style, Price). Functional dependencies are listed below.

SKU, PromotionID -> Vendor, Style, Price


SKU -> Vendor, Style

Q5: Normalize the above (Q4) relation into the next higher normal form.

Q6: Choose a key and write the dependencies for the following SOFTWARE relation (assume all of the vendor’s products have the same warranty).
SOFTWARE (SoftwareVendor, Product, Release, SystemReq, Price, Warranty). Functional dependencies are listed below.

SoftwareVendor, Product,

Release -> SystemReq, Price, Warranty

Q7: Normalize the above Software relation into 4NF.

Q8: What normal form is the following relation in?
only H, I can act as the key.
STUFF (H, I, J, K, L, M, N, O)
 Functional dependencies are listed below.

H, I -> J, K, L


J -> M


K -> N


L -> O

Q9: What normal form the following relation in?
STUFF2 (D, O, N, T, C, R, Y)
 Functional dependencies are listed below.

D, O -> N, T, C, R, Y


C, R -> D


D -> N

Invoice relation

Is this relation in 1NF? 2NF? 3NF?
Convert the relation to 3NF.

Inv# date custID Cust Name Part# Part Desc Unit Price #Used Ext Price Tax rate Tax Total

14 12/63 42 Lee A38 Nut 0.32 10 3.20 0.10 1.22 13.42

14 12/63 42 Lee A40 Saw 4.50 2 9.00 0.10 1.22 13.42

15 1/64 44 Pat A38 Nut 0.32 20 6.40 0.10 064 7.04

Hint: Start with identifying the primary key attribute(s) of the relation. Also, make necessary assumptions concerning other functional dependencies.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"