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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
