To demonstrate your understanding of using ERDs and solving the multi-column problem
Assignment: This is a continuation of the previous Assignment 3 as an example of a horrible database design. Create an Entity Relationship Diagram (ERD) of the normalized version of this table using Visio’s crows-foot notation. The ERD should show the PK and FK columns, plus all of the appropriate column attributes (column name, data type/size, null/not null) plus the relationships (with minimum and maximum cardinality) between tables.