Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PIUUICHE tre company keeps data regarding actors and the shows in which they act. Each actor can be on many shows and each show features
PIUUICHE tre company keeps data regarding actors and the shows in which they act. Each actor can be on many shows and each show features many actors. ACTOR ACT ID 1 2 3 Anne 5 6 ACT LNAME ACT FNAME ACT INITIAL ACT DOB ACT HIRE DATE Kolmycz George D 6/15/92 3/15/85 Lewis Rhonda 3/19/85 4/25/86 Vandam Rhett 11/14/88 12/20/90 Jones 10/16/74 8/28/94 Lange John 11/8/71 10/20/94 Williams Robert 3/14/75 11/8/94 Duzak Jeanine 2/12/88 1/5/89 Diante 8/21/74 72/94 Wiesenbach Paul 2/14/86 11/18/92 Travis Elizabeth 6/18/91) 4/14/89 Genkazi Leighla 5/19/80 12/1/90 7 2003 Jorge 9 10 11 w SHOW SHOWID Si 52 $3 SHOW TITLE SHOW START DATE SHOW. THEATER PHANTOM 11/8/2015 OPERA HOUSE FIDDLER 3/23/2015 OPERA HOUSE HAMILTON 12/12/2015 MODERN THEATER 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 (including all attributes, keys, etc.). 19 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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