Convert the following Enhanced Entity-Relationship diagram into a well-structured relational database design. Use a solid underline for primary key fields. Use a dashed underline for foreign key fields. Use both a dashed underline and a solid underline, or two solid underlines for a field that is both a primary key field and a foreign key field in its table. Do not draw lines or arrows from one table to another.

the following  format is required:-

 
 

Transcribed Image Text:

CITY THEATER PK City PK Theater Num 太 PK State Address Mayor Phone Number of Showings Total Revenue DIRECTOR MOVIE PK Dir Name Dir Address + Dir Cell PK Title PRODUCER 太 PK Prod Name Prod Addr Prod Cell Year Length Туре 主 STAR NEWSPAPER Star (Yes REVIEW KPK Review Num Теxt Date PK News Name 主 City or No) State АСTOR PK Actor Name REVIEWER PK Rev Name Years Work Date Birth Place Birth (Previous Job) SHOOTING Start Date End Date LOCATION PK City PK Country Local Contact Opening Date Rating DRAMA COMEDY ADVENTURE CITY THEATER PK City PK Theater Num 太 PK State Address Mayor Phone Number of Showings Total Revenue DIRECTOR MOVIE PK Dir Name Dir Address + Dir Cell PK Title PRODUCER 太 PK Prod Name Prod Addr Prod Cell Year Length Туре 主 STAR NEWSPAPER Star (Yes REVIEW KPK Review Num Теxt Date PK News Name 主 City or No) State АСTOR PK Actor Name REVIEWER PK Rev Name Years Work Date Birth Place Birth (Previous Job) SHOOTING Start Date End Date LOCATION PK City PK Country Local Contact Opening Date Rating DRAMA COMEDY ADVENTURE

Answer rating: 100% (QA)

CITY City State Mayor THEATERMOVIE The... View the full answer