Consider a database with these tables, INGREDIENT and DISTRIBUTOR: DIST_ID DIST NAME Sundown Ranch 1 2...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider a database with these tables, INGREDIENT and DISTRIBUTOR: DIST_ID DIST NAME Sundown Ranch 1 2 Wright Bakery 3 Harry's Produce ING_ID 2 3 4 5 ING NAME Beef Cheese Roll Onion Lettuce DIST_ID 1 1 2 3 3 DIST STATE PA NJ NY a. Explain in plain English what the relational algebra ODIST_ID=3(INGREDIENT) does, and state how many rows would be in the result of that expression. c. Write the relational algebra to select all distributors that are in either PA or NJ. Note: Your answer should make two separate selections and combine them with a binary operator; an answer that uses a single selection will not receive full marks. d. Draw a table showing the result of INGREDIENT D DISTRIBUTOR. Note: Assume all joins are natural joins. e. Suppose you want to see a relation showing which state each ingredient comes from, with all extraneous information removed; you only want to see the name of the ingredient and the state. What relational algebra expression would give you this? f. What three fundamental operators in relational algebra can you combine to achieve a natural join? Consider a database with these tables, INGREDIENT and DISTRIBUTOR: DIST_ID DIST NAME Sundown Ranch 1 2 Wright Bakery 3 Harry's Produce ING_ID 2 3 4 5 ING NAME Beef Cheese Roll Onion Lettuce DIST_ID 1 1 2 3 3 DIST STATE PA NJ NY a. Explain in plain English what the relational algebra ODIST_ID=3(INGREDIENT) does, and state how many rows would be in the result of that expression. c. Write the relational algebra to select all distributors that are in either PA or NJ. Note: Your answer should make two separate selections and combine them with a binary operator; an answer that uses a single selection will not receive full marks. d. Draw a table showing the result of INGREDIENT D DISTRIBUTOR. Note: Assume all joins are natural joins. e. Suppose you want to see a relation showing which state each ingredient comes from, with all extraneous information removed; you only want to see the name of the ingredient and the state. What relational algebra expression would give you this? f. What three fundamental operators in relational algebra can you combine to achieve a natural join?
Expert Answer:
Answer rating: 100% (QA)
a The relational algebra expression ODISTID3INGREDIENT selects all rows from the INGREDIENT table wh... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
Consider a U.S. Corporate bond that pays semi-annual coupons with settlement of May 12, 2018. The bond matures on March 1, 2046. The bond's coupon rate is 3% and has a yield of 3%. What is the bond's...
-
In the TAL Distributors database shown in Figure 2-1, the Rep table contains four rows and the Customer table contains 12 rows. How many rows would be contained in the Cartesian product of these two...
-
Here are data on two firms: Equity ($ million) Debt ($ million) ROC (%) Cost of Capital (%) Acme 140 100 18 8 Apex 450 150 16 9 a-1. Calculate the economic value added? (Do not round intermediate...
-
With respect to strategies used by land conservation groups to preserve land, conservation easements seem to be expanding more rapidly than buying land for preservation. In what respect might...
-
A long, straight metal rod has a radius of 5.00 cm and a charge per unit length of 30.0 nC/m Find the electric field (a) 3.00 cm, (b) 10.0 cm, and (c) 100 cm from the axis of the rod, where distances...
-
According to Figure 30.2, higher energies correspond with times that are closer to the origin of the universe, so particle accelerators at higher energies probe conditions that existed shortly after...
-
With reference to Exercise 10.3, what can we say with \(95 \%\) confidence about the maximum error if we use the sample proportion to estimate the corresponding true proportion? Data From Exercise...
-
A firm believes the sales volume (S) of its product depends on its unit selling price (P) and can be determined from the equation P = $100 - S. The cost (C) of producing the product is $1000 + lOS....
-
The decision by Attorney General Jeff Sessions to revive some of the toughest practices of the "war on drugs" can have both positive and negative impacts on the correctional system and sustainable...
-
Sapporo K.K. was sued by a competitor in late 2020, and company management concluded that there was a 55 percent probability that the company would lose the lawsuit. The best estimate of the loss on...
-
4. View Animation 4.9 Polymerase Chain Reaction. a. The primers used for PCR are typically how many nucleotides long? b. In PCR, the machine cycles between three different temperatures. What are the...
-
If f(x) = x + 3 and g(x) = x + 8x + 15. Determine an equation for y = f(x) * g(x)
-
Jurvin Enterprises is a manufacturing company that had no beginning inventories. A subset of the transactions that it recorded during a recent month is shown below. a. $75,600 in raw materials were...
-
The money paid by private business to the suppliers of loans used to purchase capital or money that households receive on savings accounts is called Blank______. Multiple choice question. interest...
-
Clara goes ice-skating. In Figure 1 her track is represented by an empty space surrounded by trees on the outside and with a set of trees inside. Figure 1. She trains to become an olympian and...
-
Margie Frump is employed as a teacher. She occasionally purchases items that she uses in the course of her employment that are subject to depreciation. Assets held by Margie at 30 June 2021: Margie...
-
If 3 men or 4 women can construct a wall in 43 days, then the number of days that 7 men and 5 women take to construct it is : a. 12 b. 18 c. 24 d. 30
-
r = 0.18 Find the coefficients of determination and non-determination and explain the meaning of each.
-
Quince Interests is a partnership with a tax year that ends September 30, 2012. During that year, Potter, a partner, received $3,000 per month as a guaranteed payment, and his share of partnership...
-
John Fuji (age 37) moved from California to Washington in December 2011. He lives at 468 Cameo Street, Yakima, WA 98901. John's Social Security number is 571-78-5974 and he is single. His earnings...
-
If Charles, a 16-year-old child model, earns $50,000 a year and is completely self supporting even though he lives with his parents, can his parents claim him as a dependent? Why or why not?...
-
Describe what sexual harassment is and what forms it can take.
-
Explain public policies that protect employees from unlawful discharge.
-
Discuss under what conditions unemployment compensation can be denied to a claimant.
Study smarter with the SolutionInn App