Question: Please help solve, showing SQL queries. The ER Diagrams and relational schema are shown. 1) Display the SMemberID, SMemberName, and the number of apartments that

Please help solve, showing SQL queries. The ER Diagrams and relational schema are shown.

1) Display the SMemberID, SMemberName, and the number of apartments that the staff member cleans, for all staff members.

2) Display the SMemberID and SMemberName of staff members cleaning apartments rented by corporate clients whose corporate location is Chicago. Do not display the same information more than once.

Thank you! Please help solve, showing SQL queries. The ER Diagrams and relational

HAFHMORE ERD and Relational Schema InsID INSPECTOR DateNext InsName CCID CCIndustry Inspects Datelast Artio NoOfBedrooms CCName CCLocation BuildingID BUILDING Locatedin Leases APARTMENT (5,10) -0H CORPCLIENT BNoOfFloors Residesin Cleans Refers Manages (1.2) STAFFMEMBER Manager ID MANAGER MSalary MPhone MBonus (0) sMemberID SMemberName MAge MBdate (MFullName MFirstName MLastName INSPECTING InsID (FK) Building ID (FK) Datelast DateNext CLEANING INSPECTOR InsID InsName BUILDING Building ID BNoOfFloors BManagerID (FK Building ID ] MANAGER Manager ID MFirstName MLastName MBdate MSalary MBonus (0) MResBuildingID (FK) AptNo SMemberID (FK) APARTMENT Building ID (FK) AptNo ANoOfBedrooms CCID (C)(FK) STAFFMEMBER SMemberID SMemberName MANAGERPHONE Manager ID (FK) MPhone CORPCLIENT CCID CCName (U) CCIndustry CCLocation CCIDReferredBy COXFK)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

- HAFH ("Home Away from Home") Realty Company leases apartments to corporate clients. HAfH flealty Company Property Management Database will keep track of HAFH buildings, apartments, corporate...

Schema for the HAFH (Home Away from Home) Realty Company. INSPECTOR table Attributes: InsID InsName Primary key (InsID) BUILDING table Attributes: BuildingID BNoOfFloors ManagerID Primary key...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Consider Hoare triples of the form {T} V := E {V = E} where T is the atomic formula 'true' and V and E range over variables and expressions, respectively. (i) Write down an instance of such a triple...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Please help solve in SQL database 1) ADD_MONTHS command What is the date 10 years or 120 months from now? Label the column Future. 2) INSTR command Whats the position of I in Oracle Internet Academy?...

Chapter 8 Analysis of Variance. Please help solve showing work? 23. Consider an experiment to determine the effects of alcohol and marijuana on driving. Five randomly selected subjects are given...

Please help solve, showing work will be helpful! Plum Pastries uses a mixing department and a baking department in producing its cake. Its process-costing system in the mixing department has two...

On April 15, 2021, fire damaged the office and warehouse of Wildhorse Corporation. The only accounting record saved was the general ledger, from which the balance sheet data below was prepared....

hello im seeking help with the question. please help by showing work and explaining. a-f only Firm Measures: Productivity, Costs, and Profits Labor 0 1 2 3 4 Total Product (TP) Fixed Cost (TFC)...

Assume the same facts as in Exercise 9-25, except that the book value of the press traded in is $108,500. (a) What is the amount of cash given? (b) What is the gain or loss on the exchange? In...

A fighter aircraft has the transfer function Where is the pitch rate (rad/s) and 5 is the elevator deflection (rad). The four poles represent the phugoid and short-period modes. The phugoid mode has...

2 ) Ravi is considering investing in segregated funds for his retirement savings. Which of the following features are typically associated with segregated funds? ( Select all that apply. ) I....

solve c please The following questions will take a different and more revealing look at spin, spin operators, and eigenfunctions. In this question we will limit our consideration to a one electron...

The chapter notes that the rise in the U.S. trade deficit during the 1980s was due largely to the rise in the U.S. budget deficit. On the other hand, the popular press sometimes claims that the...

In 1998, the Russian government defaulted on its debt payments, leading investors worldwide to raise their preference for U.S. government bonds, which are considered very safe. What effect do you...

A case study in the chapter analyzed purchasing-power parity for several countries using the price of Big Macs. Here are data for a few more countries: Predicted Country Big Mac Rate Rate Indonesia...