Question: Providea report using the given template and your work, including screenshots of all the scripts and their database results. Execute the SQL statements below

Provide a report using the given template and your work, including screenshots of all the scripts and their database results.
 


Execute the SQL statements below against the database you created:

 

Select
Minimum of three of Delete, Insert, and Update
At least three of the Max, Min, Sum, Count, and Ave
Alter Table to add a Column

 Room room number room type price per night description employee id Employee employee id SIN gender omal phone 

Room room number room type price per night description employee id Employee employee id SIN gender omal phone number job name department id Departments department id 8 FK Payment Rem TK Room Employee department name employees performance metrics FKR Room FK Employ Departments Payment paymentid Reservation reservation_id checkin dato customer_id room numb check out date reservation d customer jd payment date amount service id room number FK Payment Beation. 8888 DK Pam C H FK Customer Customer customer_id customer name amal phone number address 8 FK Payment Other Servi FKOther Service C Other Service 1 service d service type price description customer jd

Step by Step Solution

3.36 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

As your question seems to be related to performing certain SQL operations on a database you created I can guide you on what kind of SQL statements you ... View full answer

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!