Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started