Write expressions of relational algebra to answer the following queries. 1. Find title and length of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 StarsIn relation. 10. Find name and address of all male movie stars who are also movie executives with a net worth under $10,000,000. Lab 1: An Algebraic Query Language I. We have the database schema consists of five relations: Movies (title, year, length, genre, studioName, producer#) Starsīn (movieTitle, movieYear, starName) Moviestar (name, address, gender, birthdate) MovieExec (producert, 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 StarsIn relation. 10. Find name and address of all male movie stars who are also movie executives with a net worth under $10,000,000. Lab 1: An Algebraic Query Language I. We have the database schema consists of five relations: Movies (title, year, length, genre, studioName, producer#) Starsīn (movieTitle, movieYear, starName) Moviestar (name, address, gender, birthdate) MovieExec (producert, name, address, netWorth) Studio (name, address, presC#)
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Write the relational algebra formula to apply an INTERSECT relational operator to the tables shown in Figure Q3.13. Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT...
-
Write the relational algebra formula to apply a UNION relational operator to the tables shown in Figure Q3.13. Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT...
-
Given the following code, what will print to the console window? int exp= 200; int coin = 50; if (exp > 200) { if (coin >= 75) { } else { } else { if (exp * 2 > 399 || coin < 1000) { printf ("Secret...
-
1. Insurance Act, RSBC 1996 c226 Read Parts 1 and 2 of this statute and describe any changes to the standard commonlaw rules for contracts that you notice. 2. KP Pacific Holdings Ltd. and Churchland...
-
Is it fair that workers do not have the right to sue their employers for negligence?
-
Find the sample variance and standard deviation for the following sample: 15 9 5 12 9 21 4 24 18
-
Distinguish between environmental impact, environmental quality and environmental effect. How are these related to life-cycle assessment?
-
A design engineer at Sperling Manufacturing, a supplier of high-quality ball bearings, claims a new machining process can result in a higher daily output rate. Accordingly, the production group is...
-
The date is January 1, 2023 and Pasta Pros ("PP") is currently facing a major decision. For years, PP has always produced pasta and they have become well known in their local market. PP is small and...
-
Company A is a global company based in the United States that operates in the financial industry. Company A serves its customers with financial products, such as checking accounts, bank cards, and...
-
Example 6: Determine the resultant of the force system shown. Hint: use components method 6kips 15 7 8 10kips 6.8kips
-
Consider an initial system of three charges shown in (Figure). An object with charge 94 +4.0 108 C will be moved to position C from infinity (not shown in the figure). 91 92 93 = +10.0 10-8 C. Figure...
-
You will soon find yourself fulfilling roles in organizations where the ability to think strategically about issues will make you much more valuable to employers. For example, your boss may ask you...
-
22. An unconventional artist creates paintings by sloshing buckets of paint onto large canvases. Suppose the canvas and easel on which it is placed have a combined mass of 4.5 kg and are initially at...
-
3. The following information was extracted from the books of Hero & Co on 1 July 2013. Office Equipment (cost) Accumulated depreciation RM 269000 RM 98320 RM 170680 On 1 September 2013, some office...
-
Immunizing a bond portfolio: a. An insurance company must make a payment of $19,487 in seven years. The market interest rate is 10%. You are the portfolio manager for the insurance company and you...
-
How does Performance Management align with talent development and succession planning initiatives within an organization?
-
6. (Potential Energy and Conservation of Energy) What should be the spring constant k of a spring designed to bring a 1200-kg car to rest from a speed of 95 km/h so that the occupants undergo a...
-
1. The result of writing a rational expression as the sum of two or more simpler rational expressions is called the ________ ________ ________. 2. If the degree of the numerator of a rational...
-
Write the logarithmic equation in exponential form. For example, the exponential form of log5 25 = 2 is 52 = 25. 1. log4 16 = 2 2. log9 1/81 = 2 3. log12 12 = 1 4. log32 4 = 2/5
-
The rate of change of the function f (x) = sec x + cos x is given by the expression sec x tan x sin x. Show that this expression can also be written as sin x tan2 x.
-
With your instructor's consent, identify a company and perform a background review of it to identify high-risk areas for an upcoming audit. Utilize all the electronic sources that have information...
-
According to the AICPA's ethical standards, an auditor would be considered in- dependent in which of the following instances? a. The auditor has an automobile loan from a client bank. b. The auditor...
-
Explain how "privileged communication" differs from confidential information.
Study smarter with the SolutionInn App