a. Provide a diagram showing a database that: i. New or revised tables that need to be created, normalize to at least third normal form ( 5pts) ii. Existing tables that have a relationship with the new tables ( 5pts ) iii. show data types for each new data field(5 pts) iv. label the relationships and cardinality between the new tables and existing tables ( 5 pts). You may use Crow notation, Chen notation or just write it out (e.g. optional zero to many, mandatory one to many, etc) v. Show the degree - binary, unary or ternary of the relationships ( 5 pts) This diagram can be done in Visio, Word, Lucidchart, other software tool of preference, or you can scan in a hand drawn document