PART I- Consider the following relational database schema: Movie (title, year, length, inColor, studioName, producerC) S

[answerhappygod]

Part I Consider The Following Relational Database Schema Movie Title Year Length Incolor Studioname Producerc S 1 (97.8 KiB) Viewed 45 times

PART I- Consider the following relational database schema: Movie (title, year, length, inColor, studioName, producerC) StarsIn(movieTitle, movie Year, starName) MovieStar(name, address, gender, birthdate) MovieExec(name, address, cert#, net Worth) Studio(name, address, cert#, netWorth) Write the following queries in SQL. 1- (5 points) Movies made by MGM studios that either were made after 1970 or were less than 90 minutes long. 2- (5 points) List the movies listed by length, shortest first, and among movies of equal length, alphabetically. 3- (5 points) List two stars that share an address. 4- (5 points) Query the names and addresses of all female movie stars who are also movie executives with a net worth over $10,000,000 5- (5 points) Query all the titles and years of movies that appeared in either the Movies or Stars In relations. 6- (5 points) Query the producer of Star Wars. 7- (5 points) Query all the producers of movies in which LEONARDO DICAPRIO stars. 8- (5 points) Query the titles that have been used for two or more movies. 9- (10 points) Find sum of the movies length each studio is produced. 10- (10 points) Create a list of each producer name and the total length of film produced. 11- (10 points) Query the total film length for only those producers who made at least one film prior to 1930.