Question
Q14. (12) As her family checked out of their condo, Madison Peterson gave her bracelet to the housekeeping staff member, who was cleaning the condo,
Q14. (12) As her family checked out of their condo, Madison Peterson gave her bracelet to the housekeeping staff member, who was cleaning the condo, to hold for her so that her sister would not break it. She forgot to ask for it back. Find the name and phone number of the employee who is holding Madisons bracelet we need to return it to her. The room was cleaned Aug 19 of 2017. Q15. (4) For each manager, find their last name (Manager) and hire date and the last names and hire dates of all employees (Employee) working under them. Show by the manager's last name.
Code the queries within SQL Server and use the EERD below.
Family Adventure Resorts PERSONNE Name Name hone HOUSEKEEPING IKI CLEANING HKID FAMILIES CONDOS uesra Fna Condo GUIDES drms GUEST Fee LName CONDOSTAYS ACTIVITIES RESERVATIONS RID Guest AID TotalFeePaid] Hrs RDate Type TotalCost INVOICE INVOICEDETAILS Guest# RLName Departure Date] CondoFee] Details Totall Invoice Total SalesTax] Person Price] Activity Total Details Total Family Adventure Resorts PERSONNE Name Name hone HOUSEKEEPING IKI CLEANING HKID FAMILIES CONDOS uesra Fna Condo GUIDES drms GUEST Fee LName CONDOSTAYS ACTIVITIES RESERVATIONS RID Guest AID TotalFeePaid] Hrs RDate Type TotalCost INVOICE INVOICEDETAILS Guest# RLName Departure Date] CondoFee] Details Totall Invoice Total SalesTax] Person Price] Activity Total Details TotalStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started