Answer Happy

Paragraph Styles Member Number Name Date Out Date In 1012 Isobel Ringer Cost (RM) 2.50 2.00 Telephone DVD Number Code Title 293847 003 American Pie 011 My Grandpa in My Pocket 142536 002 Finding Nemo 015 Shrek 1 Jan 2014 2 Jan 2014 3 Jan 2014 18 Feb 2014 1034 2 Jan 2014 17 Feb 2014 John Silver 3.50 4.00 28 Feb 2014 1 March 2014 1056 Fred Flinstone 817263 003 American Pie 2.50 3 March 2014 4 March 2014 2.00 13 March 2014 011 My Grandpa in My Pocket 008 Frozen 14 March 2014 1097 Annette Kirton 384756 4.00 2 April 2014 3 April 2014 014 Prime Suspect 3 April 2014 4 April 2014 2.00 Normalizing tables INF (member member. Name, Telephone number, DVD code, Titre, Cost (em), Datu Out, Dakin) ONE NE membex mem.number, Name, Telephone number) DVD ( DVD Code, Title) Rent (Cost (em), Date Out , Datein) Member ( member number , Name, Telephone number) OUD ( DVDcode, Title) Rent (Cose (RM). Daugn, Datout , member-numbex ovocode) Please complete the ERD diagram using crow's foot model that refers to the normalizing table and determine appropriate relationship cardinalities between tables.