Design and draw out an Enhanced entity-relationship model Specifications: A movie has a name, release date, rating, dura

[answerhappygod]

Design And Draw Out An Enhanced Entity Relationship Model Specifications A Movie Has A Name Release Date Rating Dura 1 (80.35 KiB) Viewed 39 times

Design and draw out an Enhanced entity-relationship model Specifications: A movie has a name, release date, rating, duration, and actor(s). A movie is either a foreign or domestic movie. A foreign movie uses a foreign language and may include subtitles. A domestic movie can further be categorized into different genres being comedy, drama, action and horror movies. Some movies can have multiple genres. A comedy movie will have a level of "funniness” that can range from 1 to 5. A drama movie will have a small descriptions such as "tragedy", "romance", "love-story", etc. Each individual movie is supplied by only a single distributor. One distributor can provide multiple movies. Every distributor has a name, address, and phone number. The address of a distributor can be accessed as street address, city, state, and zip code individually and the entire address of a distributor can also be retrieved as a single unit. A movie may be nominated to multiple awards and could win multiple awards. One award has multiple movies nominated for the award but only one movie is selected for each award. There are also movies that are not nominated for any awards. Each award has a name and year associated with it. For any movie, the number of award nominations and the number of award wins can be computed from the known information.