Question

7.3.3 Exercises for Section 7.3 Exercise 7.3.1: Show how to alter your relation schemas for the movie exam- ple: Movie(title, year, length, genre, studioName, producerC#) Stars In(movieTitle, movieYear, starName) MovieStar (name, address, gender, birthdate) MovieExec(name, address, cert#, net Worth) Studio(name, address, presC#) in the following ways. a) Make title and year the key for Movie.

Exercise 7.3.1: Show how to alter your relation schemas for the movie example: M o v ie (title , y ear, le n g th , genre, studioName, producerC#) S ta rsln (m o v ieT itle , movieYear, starName) MovieStar(name, ad d ress, gender, b irth d a te ) MovieExec(name, ad d ress, c e rt# , netWorth) Studio(nam e, ad d ress, presC#) in the following ways. a) Make t i t l e and year the key for Movie

Answer 1

The query to make title and year the key for Movie:

ALTER TABLE Movie

ADD CONSTRAINT MovieKey

PRIMARY KEY (title, year);