Design a third-normal-form database storing the same information as these two tables. Draw an entity-relationship diagram and write a database design outline. You may add "ID" fields wherever necessary.
This is a relatively challenging problem, so please read the above interpretation of the data carefully and be sure you understand it before proceeding with your normalization.
Attachment:- chapter9normalization.rar