IST

Table Actor Attribute Name Data Type Data Length Key Type Id Long Integer Primary Key firstName Short Text 100 lastName Short Text 100 Gender Short Text 1

Table Director Attribute Name Data Type Data Length Key Type Id Long Integer Primary Key firstName Short Text 100 lastName Short Text 100

Table Genre Attribute Name Data Type Data Length Key Type genre Short Text 20 Primary Key

Table DirectorGenre Attribute Name Data Type Data Length Key Type directorId Long Integer Foreign Key genre Short Text 20 Foreign Key probability Number 12,10

FOREIGN KEY (directorId) REFERENCES Director(id), FOREIGN KEY (genre) REFERENCES Genre(genre), CHECK ((probability >= 0.0) AND (probability <= 1.0))

Table Movie Attribute Name Data Type Data Length Key Type Id Long Integer Primary Key Name Short Text 100 Year Number Rank Number 10,2 sequelId Number Foreign Key

FOREIGN KEY (sequelId) REFERENCES Movie(id), CHECK (rank >= 0)

Table MovieDirector Attribute Name Data Type Data Length Key Type directorId Long Integer Foreign Key movieId Long Integer Foreign Key

FOREIGN KEY (directorId) REFERENCES Director(id), FOREIGN KEY (movieId) REFERENCES Movie(id)

Table MovieGenre Attribute Name Data Type Data Length Key Type movieId Long Integer Foreign Key Genre Short Text 20 Foreign Key

FOREIGN KEY (movieId) REFERENCES Movie(id), FOREIGN KEY (genre) REFERENCES Genre(genre)

Table Role Attribute Name Data Type Data Length Key Type actorId Long Integer PK, FK movieId Long Integer PK, FK Role Short Text 100 PK

PRIMARY KEY (actorId, movieId, role), FOREIGN KEY (actorId) REFERENCES Actor(id), FOREIGN KEY (movieId) REFERENCES Movie(id) Please create tables using provided definitions and create following reports

1. What are movies directed by Ethan Coen? 2. What are comedy movies? 3. What are movies having actor Kevin Bacon?

All reports must include movie name, release year, and rank.