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.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code "Newclient" for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post mis 320 assignment 4 appeared first on My Nursing Experts.