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:-

 
 

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