(Solved): Normalization - Using the data table shown above, perform the following tasks in order to bring th ...
Normalization - Using the data table shown above, perform the following tasks in order to bring the data to the Third Normal Form:
a. Identify the primary key.
b. Draw the dependency diagram for the table making sure to identify all dependencies (full functional, partial, and transitive).
c. Write out the dependency list for all identified dependencies in part b above.
d. Using the dependency lists from part c remove all partial dependencies so that the database will be in second normal form i.e. draw dependency diagrams for each new entity, write out the new relational schemas, and identify the new normal forms for each entity structure you created.
e. Look at the table structures developed in part d. If any of your entities contain a transitive dependency you must remove it/them so that your table(s) will be in third normal form i.e. you must again draw the new dependency diagrams, write out the relational schemas, and identify the normal forms for each new/updated structure you developed.
f. Using the results of part e draw the ERD for your database design.
Expert Answer
Answer) a) We can name the given table as master table. Following is the primary key identified in the given table which is a composite key between us