Problem #3 (15 points) (ziniog El A theatre company keeps data regarding actors and the shows in which they act. Each actor can be on many shows each show features many actors. ACTOR ACT ID ACT LNAME ACT FNAME ACT INMAL ACT DOS ACT HIRE DATE 1 Kolmycze George D 6/15/92 3/15/85 2 Lewis Rhonda 3/19/85 4/25/86 3 Vandam Rhett 11/14/88 12/20/90 Jones Anne 10/16/74 8/28/94 Lange John 11/8/71 10/20/94 Williams Robert 3/14/75 11/8/94 7 Duzak Jeanine 2/12/88 1/5/89 8 Diante Jorge 8/21/74 72/94 9 Wiesenbach Paul 2/14/86 11/18/92 10 Travis Elizabeth 6/18/91 4/14/89 11 Genkazi Leighia w 5/19/80 12/1/90 SHOW ID SHOW TITLE SHOW START DATE SHOW THEATER S1 PHANTOM 11/8/2015 OPERA HOUSE S2 FIDDLER 3/23/2015 OPERA HOUSE S3 HAMILTON 12/12/2015 MODERN THEATER SHOW a. Draw the simplified (no attributes) conceptual ERD for this model using Chen notation. (6 points) Convert it into an E-R model that displays only 1:1 or 1:M relationships and draw the Crow's Foot ERD (includin all attributes, keys, etc.). (9 points)