MIS 320 Assignment 4Normalization Examples (Source: www.DBNo

MIS 320 Assignment 4Normalization 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 dependenciesWhat 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, WarrantyQ7: 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 -> OQ9: 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 -> NInvoice relationIs 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 Total14 12/63 42 Lee A38 Nut 0.32 10 3.20 0.10 1.22 13.4214 12/63 42 Lee A40 Saw 4.50 2 9.00 0.10 1.22 13.4215 1/64 44 Pat A38 Nut 0.32 20 6.40 0.10 064 7.04Hint: Start with identifying the primary key attribute(s) of the relation. Also, make necessary assumptions concerning other functional dependencies.