Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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 Total

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions