We have the database schema consists of five relations: Movies (title, year, length, genre, studioName, producer#)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
We have the database schema consists of five relations: Movies (title, year, length, genre, studioName, producer#) Stars In (movieTitle, movieYear, starName) MovieStar (name, address, gender, birthdate) MovieExec (producer#, name, address, netWorth) Studio (name, address, presC#) Write expressions of relational algebra to answer the following queries. 1. Find title and length of movies produced by Disney in 1990. 2. Find date of birth of Aishwarya Rai who is a movie star. 3. Find the address of studio Film City. 4. List name of the female stars in the film "Monsoon Wedding". 5. List name and gender of stars that appeared in movies produced by Sony in 2005. 6. Find name of the producer of Star Wars. 7. Find name of executives that are worth more than Subhash Ghai. 8. Find title of movies that are no longer than "Bride and Prejudice". 9. List all the titles and years of movies that appeared in either the Movies or Stars In relation. 10. Find name and address of all male movie stars who are also movie executives with a net worth under $10,000,000. We have the database schema consists of five relations: Movies (title, year, length, genre, studioName, producer#) Stars In (movieTitle, movieYear, starName) MovieStar (name, address, gender, birthdate) MovieExec (producer#, name, address, netWorth) Studio (name, address, presC#) Write expressions of relational algebra to answer the following queries. 1. Find title and length of movies produced by Disney in 1990. 2. Find date of birth of Aishwarya Rai who is a movie star. 3. Find the address of studio Film City. 4. List name of the female stars in the film "Monsoon Wedding". 5. List name and gender of stars that appeared in movies produced by Sony in 2005. 6. Find name of the producer of Star Wars. 7. Find name of executives that are worth more than Subhash Ghai. 8. Find title of movies that are no longer than "Bride and Prejudice". 9. List all the titles and years of movies that appeared in either the Movies or Stars In relation. 10. Find name and address of all male movie stars who are also movie executives with a net worth under $10,000,000.
Expert Answer:
Related Book For
Niebels Methods, Standards and Work Design
ISBN: 978-0073376318
13th edition
Authors: Andris Freivalds, Benjamin Niebel
Posted Date:
Students also viewed these accounting questions
-
Write expressions of relational algebra to answer the following queries. 1. Find title and length of movies produced by Disney in 1990. 2. Find date of birth of Aishwarya Rai who is a movie star. 3....
-
A video movie rental store is using a relational database to store information on movie rentals to answer customer questions. Each entry in the database contains the following items: Movie Number...
-
Is a star schema a relational data model? Why or why not?
-
Evaluate the integral (4e* + 2 In (2))dx.
-
Describe each scale of measurement.
-
Using a method of your choice, verify each of the equivalences inFigure. (a AB) = (BA a) commutativity of A (a v B) = (B V a) commutativity of v ((a ^ 3) A7) = (a^ (BA)) associativity of A ((a V B) v...
-
Prepare a statement of cash flows for the New Zealand Dairy Company for the year ended January 31, 2018. Interpret your results. New Zealand Dairy Company Balance Sheet for 01/31/2017 and 01/31/2018...
-
Hindustan Motors has been producing its Ambassador car in India since 1948. As the companys Web site explains, the Ambassadors dependability, spaciousness and comfort factor have made it the most...
-
The definition, " ' Chiropractor ' means a person who is a medical quack with no legitimate scientific background," is an example of: Theoretical definition Definition by subclass Persuasive...
-
Amherst Networking Systems adjusts and closes its books and then prepares financial statements monthly. Amherst uses the perpetual inventory system and all sales on credit have terms of n/30. The...
-
Calculate this by using this formula: Break-Even Point = Fixed Costs / (Sale Price per Unit - Variable Costs per Unit): Existing Process Metrics: Workforce: 5 employees Output Rate: 60 fittings per...
-
The annual demand for sand used during the winter months for the city of Boulder is 750000 pounds. The holding cost is $0.1 per lb per year and the ordering costs at $65 per order. Currently all the...
-
A crate rests on a horizontal surface and a woman pulls on it with a 10-N force. No matter what the orientation of the force, the crate does not move. Rank the situations below according to the...
-
Ralph Henderson owns a cafe near MIT. His cafe is always crowded with students who need caffeine to start their day. Ralph Henderson wants to serve the freshest coffee to his customers. He would like...
-
The single particle energy eigenstates of a hypothetical system are nondegenerate and have energies given by a = o: where & = 6.25 x 10-21 eV. The index a runs over the positive integers. The system...
-
-3 A thermally conductive rod of cross sectional area 7.52 x 10 m2, length 0.78 m, and conductivity 345 W/mK, connects two containers. In the left container is a very large quantity of a substance at...
-
A plane flies 1.6 hours at 130 mph on a bearing of 20\deg . It then turns and flies 4.4 hours at the same speed on a bearing of 110\deg . How far is the plane from its starting point? 2 answers
-
Modify the counter from Exercise 5.44 such that the counter will either increment by 4 or load a new 32-bit value, D, on each clock edge, depending on a control signal Load. When Load = 1, the...
-
What is the relationship between return on capital investment and the risk associated with the anticipated sales of the product for which a new method will be used?
-
A job evaluation plan in the Dorben Company provides for five labor grades, of which grade 5 has the highest base rates and grade 1 the lowest. The linear plan involves a range of 50 to 250 points...
-
How does multiple causation affect accident prevention?
-
What is a joint cost?
-
Flori-Dante Srl grows, processes, packages and sells three joint apple products: (a) sliced apples that are used in frozen pies, (b) apple sauce, and (c) apple juice. The apple peel, processed as...
-
Flori-Dante classifies animal feed as a by-product. The by-product is inventoried at its selling price when produced; the net realisable value of the product is used to reduce the joint production...
Study smarter with the SolutionInn App