Reference no: EM13509216
Consider the following schema:
Suppliers(sid: integer, sname: string, address: string) Parts(pid: integer, pname: string, color: string) Catalog(sid: integer, pid: integer, cost: real)
The key fields are underlined, and the domain of each ?eld is listed after the ?eld name. Therefore sid is the key for Suppliers, pid is the key for Parts, and sid and pid together form the key for Catalog. The Catalog relation lists the prices charged for parts by Suppliers. Write the following queries in relational algebra, tuple relational calculus, and domain relational calculus:
1. Find the names of suppliers who supply some red part.
2. Find the sids of suppliers who supply some red or green part.
3. Find the sids of suppliers who supply some red part or are at 221 Packer Street.
4. Find the sids of suppliers who supply some red part and some green part.
5. Find the sids of suppliers who supply every part.
6. Find the sids of suppliers who supply every red part.
7. Find the sids of suppliers who supply every red or green part.
8. Find the sids of suppliers who supply every red part or supply every green part.
9. Find pairs of sids such that the supplier with the ?rst sid charges more for some part than the supplier with the second sid.
10. Find the pids of parts supplied by at least two di?erent suppliers.
11. Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham.
12. Find the pids of parts supplied by every supplier at less than $200. (If any supplier either does not supply the part or charges more than $200 for it, the part is not selected.)
|
What is the internal rate of return on the investment
: Constance is contemplating an average-risk investment costing $15 million that promises an annual after-tax cash flow of $2 million in perpetuity.
|
|
What the company assets totaled
: During its first year of operations, Maria Rose set up Roseland Inc. and invested $25,000 in the corporation. The company earned $68,000 of revenues and incurred $32,000 of expenses.
|
|
What is the average angular velocity of his arms and legs
: If a person of mass M simply moved forward with speed V , his kinetic energy would be (1/2 MV^2) . However, in addition to possessing a forward motion, What is the average angular velocity of his arms and legs
|
|
Classify each of the costs as a capital expenditure
: Classify each of the costs as a capital expenditure or a revenue expenditure. For those costs identified as capital expenditures, classify each as an additional or replacement component.
|
|
Find pairs of sids such that the supplier with the ?rst sid
: Find pairs of sids such that the supplier with the ?rst sid charges more for some part than the supplier with the second sid.
|
|
At what angle is the sun elevated above the horizon
: A 600-m tall tower casts a 600-m long shadow over a level ground. At what angle is the sun elevated above the horizon
|
|
Determine the division of the net income
: Plan (e), except that Driscoe is also to be allowed a bonus equal to 20% of the amount by which net income exceeds the salary allowances.
|
|
How much gravitational potential energy has it lost
: An object of mass M = 3.5 kg slides from rest a distance d = 6 m down a frictionless inclined plane where it encounters a spring. When the block just touches the spring, how much gravitational potential energy has it lost
|
|
What are the specific journal entries
: private company where the group contributing the money has only 3 x $2 shares. ie: what are the specific journal entries, particularly if that amount is not shown in the "bank" account
|