Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2017 Skopje Macedonia September 18 22 2017 Proceedings Part 3 Lnai 10536

Authors: Yasemin Altun ,Kamalika Das ,Taneli Mielikainen ,Donato Malerba ,Jerzy Stefanowski ,Jesse Read ,Marinka Zitnik ,Michelangelo Ceci ,Saso Dzeroski

1st Edition

3319712721, 978-3319712727

More Books

Students also viewed these Databases questions

Question

=+2 How does the preparation and support for each type of IE vary?

Answered: 1 week ago

Question

=+What is the extent of the use of each type of IE?

Answered: 1 week ago