ActorsalD integer Name string IName string gender string Mov

Actors(alD integer, /Name string, IName string, gender string) Movies(mlD integer, name string, mYear year, rating string) Directors (dID integer, /Name string, IName string) Casts (alD integer, mID integer, role string) MovieDirectors (dlD integer, mID integer) Genres (mID integer, genre string) he primary key fields are underlined, and the domain of each field is listed after the field name. Thus alD is the key for Actors, mID is the key for Movies, dID is the key for Directors, (alD, mID, role) forms the key for Casts, (dID, mID) forms the key for MovieDirectors, and (mID genre)forms the key for Genres Write CREATE INDEX statements that would help speeding up the following queries 1) SELECT name, mYear FROM Movies WHERE rating9; Build an index on attribute rating on the Movies table. Provide the SQL statement. + 2) SELECT fName, IName FROM Actors WHERE gender = \'F\'; Build an index on attribute gender on the Actors table. Provide the SQL statement 13) SELECT name FROM Movies WHERE rating >8 AND mYear > 2010; the S Build an index on attributes rating and mYear statement. on the Movies table. Provide Mo vics

Solution

1. Create Index ratingIndex on Movies(rating)

2. Create Index genderIndex on Actors(gender)

3. Create Index ratingYearIndex on Movies(rating, mYear)

4. Create Index joinIndex on Movies(mYear,rating)