Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions