Using DB, please convert below RA into SQL statements. Copy and paste sql statement and the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using DB, please convert below RA into SQL statements. Copy and paste sql statement and the result tables. (a) o maxRent > 400 (Client) (b) π branchNo, postCode (Branch) (c) o Client.clientNo= Viewing.clientNo (π clientNo,lastName (Client) > T clientNo,propertyNo (Viewing)) (d) π city (Branch) - t city (PropertyForRent) (e) π city (Branch) U π city (PropertyForRent) (f) π propertyNo, city (PropertyForRent) xViewing (g) Staff Staff.branchNo-Branch.branch No(o city='London'(Branch)) (h) Find the number of staff working in each branch and the sum of their salaries. Branch branchNo street B005 BOO B003 B004 B002 Staf staf No fName Name SI 21 SG37 Ann SG14 David SA9 SG5 SL41 A14 L94 DG4 PG36 PG21 PG16 PropertyForRent propertyNo street 22 Deer Rd 16 Argyi Stperdeen 103 an 5 Gla gow 32 Man e Rú Bristol 56 Clover Dr London CO46 CO87 CO40 CO93 Beech Ford Mary Howe Susan Brand Julie positio.. John White Manager M Assistani F S pervisor M Assistanu F Manager F Lee Assistant F CR₂0 CR76 CR50 CR32 CR50 city London Private Owner ownerNo fName IName Client cllentNo fNa...e IName CR76 John Kay 0207-774-5632 Flat CR56 Aline Stewart 0141-848-1825 Flat Viewing clientN pro..ertyNo city postcode Aberdeen AB/ 5SU 16 Holhead ✔rsyll St London NW2 6 Lawren-e St Glasgow G11 9QX 2 Manor Rd Glasgow G32 4QX Glasgow G12 18 Dale Rd 5 Novar r Glasgow G12 9AX Flat postcoae W1 4EH B2 3SU G11 9QX B:9 1NZ I-W10 6EJ PA14 PG4 te:No CR74 Mike Ritchie 01475-392178 House CR62 Mary Tregear 01224-196720 Flat PG4 PA14 PG36 sex DOB view I 1-Oct-45 10- 'ov-60 24-Mar 53 19-Feb-70 Jun-40 13-Jun-65 con address Joe Keogh 2 Fergus Dr Aberdeen AB2 7SX Carol Farrel 6 Achray St, Glasgow G32 9DX Tina Murphy 63 Well St, Glasgow G42 Tony Shaw 12 Park Pl, Glasgow G4 OQR 24-May-04 too man 0-0 tuu emote sa ary branch No 30000 B005 12000 B003 18000 B003 9000 B007 24000 B003 9000 B005 type House Flat Flat Flat House preType maxRent 25-May-14 14-May-04-c uiri. g room 28-1.p1-04 rooms rert | 4 q 650 CO46 400 CO87 350 CO40 3 ownerNo staf No SA9 SL41 42 350 750 600 375 CO93 5 600 C087 4 450 C093 telNo 01224-861212 0141-357-7419 0141-943-1728 0141-225-7025 Registration clientNo CR 6 CR56 CR74 CRC runchNo BOU5 B003 SG37 SG37 SG 4 BU03 BUO? branchNo B007 B005 B003 B003 B003 B003 st ffNo SL41 SUC7 SG37 SAS duteJo.led J-n-0₁ 11-Ap-0 16-Nov-49 -Mia -00 Using DB, please convert below RA into SQL statements. Copy and paste sql statement and the result tables. (a) o maxRent > 400 (Client) (b) π branchNo, postCode (Branch) (c) o Client.clientNo= Viewing.clientNo (π clientNo,lastName (Client) > T clientNo,propertyNo (Viewing)) (d) π city (Branch) - t city (PropertyForRent) (e) π city (Branch) U π city (PropertyForRent) (f) π propertyNo, city (PropertyForRent) xViewing (g) Staff Staff.branchNo-Branch.branch No(o city='London'(Branch)) (h) Find the number of staff working in each branch and the sum of their salaries. Branch branchNo street B005 BOO B003 B004 B002 Staf staf No fName Name SI 21 SG37 Ann SG14 David SA9 SG5 SL41 A14 L94 DG4 PG36 PG21 PG16 PropertyForRent propertyNo street 22 Deer Rd 16 Argyi Stperdeen 103 an 5 Gla gow 32 Man e Rú Bristol 56 Clover Dr London CO46 CO87 CO40 CO93 Beech Ford Mary Howe Susan Brand Julie positio.. John White Manager M Assistani F S pervisor M Assistanu F Manager F Lee Assistant F CR₂0 CR76 CR50 CR32 CR50 city London Private Owner ownerNo fName IName Client cllentNo fNa...e IName CR76 John Kay 0207-774-5632 Flat CR56 Aline Stewart 0141-848-1825 Flat Viewing clientN pro..ertyNo city postcode Aberdeen AB/ 5SU 16 Holhead ✔rsyll St London NW2 6 Lawren-e St Glasgow G11 9QX 2 Manor Rd Glasgow G32 4QX Glasgow G12 18 Dale Rd 5 Novar r Glasgow G12 9AX Flat postcoae W1 4EH B2 3SU G11 9QX B:9 1NZ I-W10 6EJ PA14 PG4 te:No CR74 Mike Ritchie 01475-392178 House CR62 Mary Tregear 01224-196720 Flat PG4 PA14 PG36 sex DOB view I 1-Oct-45 10- 'ov-60 24-Mar 53 19-Feb-70 Jun-40 13-Jun-65 con address Joe Keogh 2 Fergus Dr Aberdeen AB2 7SX Carol Farrel 6 Achray St, Glasgow G32 9DX Tina Murphy 63 Well St, Glasgow G42 Tony Shaw 12 Park Pl, Glasgow G4 OQR 24-May-04 too man 0-0 tuu emote sa ary branch No 30000 B005 12000 B003 18000 B003 9000 B007 24000 B003 9000 B005 type House Flat Flat Flat House preType maxRent 25-May-14 14-May-04-c uiri. g room 28-1.p1-04 rooms rert | 4 q 650 CO46 400 CO87 350 CO40 3 ownerNo staf No SA9 SL41 42 350 750 600 375 CO93 5 600 C087 4 450 C093 telNo 01224-861212 0141-357-7419 0141-943-1728 0141-225-7025 Registration clientNo CR 6 CR56 CR74 CRC runchNo BOU5 B003 SG37 SG37 SG 4 BU03 BUO? branchNo B007 B005 B003 B003 B003 B003 st ffNo SL41 SUC7 SG37 SAS duteJo.led J-n-0₁ 11-Ap-0 16-Nov-49 -Mia -00
Expert Answer:
Answer rating: 100% (QA)
Youve provided a question regarding converting relational algebra expressions into SQL statements ba... 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 databases questions
-
Jamie Lee has a marginal tax rate of 15% and an average tax rate of 11%.question Explain why there is a difference between the two rates.
-
Discuss the role of pop culture allusions in contemporary literature and their reflection of societal trends and values.
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Use the following information to answer the questions that follow.... The Big Cheese Company * 2019 2020 Interest Expense 200 1950 Cash 180 30 Property, Plant, and Equipment 16000 39550 Inventories...
-
If y = f(u) and u = g(x), where f and are twice differentiable functions, show that d'y ( du dy d'u du dx d'y du? dx
-
Select a public enterprise of your choice in Namibia and analyze the various features of good corporate governance with suitable practical examples as applied in your chosen public enterprise.
-
Suppose there are \(n\) assets. Asset \(i, i=\) \(1,2, \ldots, n\), has rate of return \(r_{i}\) over a single period. There is also a risk-free asset with rate of return \(r_{f}\). The log-optimal...
-
Rockeagle Corporation began fiscal year 2018 with the following balances in its inventory accounts: Raw Materials ........................................$30,000 Work in...
-
The Paige Company wants to develop a cost equation to determine its total electricity cost for a given month. It has determined that kilowatt hours used is the best predictor of electricity cost. It...
-
Consider Coral Bay Hospital. If the initial building and equipment cost changes to $25,000,000, the MIRR will 1. Increase 2. decrease Consider Coral Bay Hospital. If the land salvage value is changed...
-
Address the following components, focusing on how these elements result in an opportunity for the selected country to thrive in the new global environment: Select at least two social or cultural...
-
Calculate the time necessary to perform a multiply using the approach given in Figure 3.8 if an integer is A bits wide and an adder takes B time units. Figure 3.8 For many reasons, we would like to...
-
Consumer confidence, disposable income, and recessions Go to the Web site of the FRED economic data base and download the quarterly series for real personal disposable income per capita (series name...
-
Go to the FRED database operated by the Federal Reserve Bank of St. Louis. Find annual data for personal consumption expenditures and gross private domestic investment as well as for real GDP. The...
-
For several years now the European Union, the largest regional trading bloc in the world, has been trying to liberalize its energy market, replacing the markets of its 27 member states with a single...
-
Describe why it is difficult to implement a cache replacement policy that is optimal for all address sequences. In this exercise, we will examine how replacement policies impact miss rate. Assume a...
-
According to the American Red Cross, 11.6% of all Connecticut residents have Type B blood. A random sample of 28 Connecticut residents is taken. X = the number of Connecticut residents that have Type...
-
Will the prediction interval always be wider than the estimation interval for the same value of the independent variable? Briefly explain.
-
Diego, age 28, married Dolores, age 27, in 2012. Their salaries for the year amounted to $46,479 and they had interest income of $3,500. Diego and Dolores' deductions for adjusted gross income...
-
In 2012, Michael has net short-term capital losses of $2,000, a net long-term capital loss of $45,000, and other ordinary taxable income of $45,000. a. Calculate the amount of Michael's deduction for...
-
Sherry rents her vacation home for 6 months and lives in it for 6 months during the year. Her gross rental income during the year is $4,000. Total real estate taxes for the home are $950, and...
-
An atom loses an electron to another atom. Is this an example of a physical or chemical change? (a) chemical change involving the formation of ions (b) physical change involving the formation of ions...
-
Why are ores so valuable? (a) They are sources of naturally occurring gold. (b) Metals can be efficiently extracted from them. (c) They tend to occur in scenic mountainous regions. (d) They hold many...
-
Aluminum ions carry a 3+ charge, and chloride ions carry a 1- charge. What is the chemical formula for the ionic compound aluminum chloride? (a) Al 3 Cl (b) AlCl 3 (c) Al 3 Cl 3 (d) AlCl
Study smarter with the SolutionInn App