Question 1: Based on the dependency diagram:
a) Make a database, whose tables are in at least 2NF, showing the dependency diagram for each table. Label the kinds of dependencies (partial or transitive).
b) Create the logical database schema. Recognize all primary keys.
Question 2: Use the Invoice table structure shown below to answer the given questions:
a) Draw the dependency diagram and recognize the primary key and all dependencies, comprising all partial and transitive dependencies. You can suppose that the table doesn’t contain repeating groups and that any invoice number might reference more than one product.
b) Remove all the partial dependencies, re-draw the new dependency diagrams and recognize the normal form for the table structure you created.
c) Remove all the transitive dependencies and draw the new dependency diagrams. Also recognize the normal form for the table structure you created.
d) Comprise the relational schema for the final database table structure. Recognize all primary keys.