We consider the following relation:

* Let us assume that the quoted price is fixed for each part.

(1) Is the above table in the first normal form? What are the primary key fields?

(2) Explain potential problems with insertion, update, and deletion anomalies. Show partial functional dependencies, if any, among attributes.

(3) Create relations in the second normal form.

(4) Show transitive functional dependencies, if any.

(5) Create relations in the third normal form.

Orders \begin{tabular}{lllllc|} Order Number & Order Date & Part Number & Part Description & Number Ordered & Quoted Price \\ \hline 12489 & 9/02/2001 & AX12 & Iron & 11 & $14.95 \\ \hline 12491 & 9/02/2001 & BT04 & Gas Grill & 1 & $149.99 \\ \hline 12491 & 9/02/2001 & BZ66 & Washer & 1 & $399.99 \\ 12494 & 9/04/2001 & CB03 & Bike & 4 & $279.99 \\ 12495 & 9/04/2001 & CX11 & Blender & 2 & $22.95 \\ 12498 & 9/05/2001 & AZ52 & Dartboard & 2 & $12.95 \\ 12498 & 9/05/2001 & BA74 & Basketball & 4 & $24.95 \\ \hline 12500 & 9/05/2001 & BT04 & Gas Grill & 1 & $149.99 \\ \hline 12504 & 9/05/2001 & CZ81 & Treadmill & 2 & $325.99 \\ \hline \end{tabular}