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

MIS 320 Assignment 4

Normalization Examples (Source: www.DBNormalization.com)

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.