Question
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:
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 carted 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 I 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 'A 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started