关于relational database algebra expression 关系代数(数据库) 大专历年考题 求解答...

The relational schemas below capture the data requirements for a group of studio cinemas, and the movies currently showing.

Movie(title, year, length, inColor, studioName, producerCertNo);
StarsIn (movieTitle, movieYear, starName);
MovieStar (name, address, gender, birthdate);
MovieExec (name, address, CertNo, netWorth);
Studio (name, address, studioCertNo);

Note:
1. example studio name are MGM, HBO, STARMOVIE, etc
2. There might be same movie title in different movie year.

(a) Write the relational algebra expression to find all the stars’ names who either are male or live in Malibu as part of the address.[6 marks]

(b) Write the relational algebra expression to find all Movie Star names in pair that have same address and the first result star name precedes the second one alphabetically. Assuming the address only record up to the region where the Movie Star lives in. e.g. New York, USA
[8 marks]



(c) Write the relational algebra expression to find the producers of Harrison Ford’s movies, Note that Harrison is a Movie Star.[12 marks]

(d) Write relational algebra expression to find the total length of film produced for producers who made at least one film prior to 1930 with a net worth of more than $10,000,000.[4 marks]