Question: please do it fasttttt 1. Suppose in a movie database, a movie is identified by id, name, year and ratings where a movie might have

please do it fasttttt 1. Suppose in a movie database, a movieplease do it fasttttt

1. Suppose in a movie database, a movie is identified by id, name, year and ratings where a movie might have a sequel. (Example: Mission: Impossible 2 is a 2000 American action spy film. This movie is sequel to 1996 film Mission: Impossible). Movies are casted by actors where an actor has specific role (Example: MI 2 is starred (i.e., main character) by Tom Cruise) and an actor is identified by id, firstname, lastname and gender. A movie might have multiple genres (Example: MI 2 is characterized by three genres: Action | Adventure | Thriller). A director who directs a movie is identified by id, firstname and lastname. We assume a movie can have at-most one director. (Example: John Woo is the director of MI 2 and he also directed well-known movies like better tomorrow', 'Red Cliff', 'Hard Boilded', 'Face/Off'] i) Draw ER diagram with proper notation. (7)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!