Q1: Functional dependence Consider the following relation and example data PC Part PartNumber 10010 10010 10220 10220 10224 10440 SupplierAddress Cupertino, CA Armonk, NY San Mateo, CA Armonk, NY San Mateo, CA Armonk, NY Description Supplier 20 TB Disk 20 TB Disk 256 GB RAM card 256 GB RAM card 256 GB RAM card 42" LCD Monitor Seagate BM Kensington IBM Hewlett Packard BM Price $100 $90 $220 $290 $310 $310 Answer the following questions a) For PC Part, list it's functional dependences (FD1...FDn) b) Select a PK for PC Part c) List all the candidate keys for this relation d) Of the functional dependencies listing in a), which are full vs. partial2 dependencies Q1: Your answer goes here.... a) b) c) d) Q2: Normalization Consider the following relation, data and dependencies: Order_Items (Order ID, LineItemNumber, ProductID, Quantity, Price) 0101 0101 0101 0102 0102 P999 P553 P443 P222 P553 $100 $12 $75 $700 $12 Key: Order ID, LineltemNumber Normalize Order ltems up through 3NF showing for each normal form a) functional dependencies b) the schemas for the tables with PKs and any FKs b) the rationale for the normalized step taking into account the functional dependencies Q2: Your answer goes here.... 1NF 2NF 3NF