Provide a report that includes screenshots of all the tables. First, show us a picture of your ER diagram. The file format should be Doc.  

 Based on the ER diagram attached, use the SQL Server Management Studio (SSMS) database software to make a database. Make tables with the same columns and rows, and fill them with up to 10 sample rows. The primary key and the foreign key should also be named.

Provide a report that includes screenshots of all the tables. 

 Summary of Chart     

Customer: customer_id (primary key), name, email, phone_number, address
Room: room_number (primary key), room_type, price_per_night, description
Reservation: reservation_id (primary key), check_in_date, check_out_date, customer_id (foreign key), room_number (foreign key)
Staff: staff_id (primary key), name,SIN (primary key), email, phone_number, address, job_title, salary
Payment: payment_id (primary key), amount, payment_date, customer_id (foreign key), reservation_id (foreign key)
Service: service_id (primary key), service_type, price, description
Department: department_id (primary key), department_name, staff, performance_metric

 

department name) PK department 0000 gender PK SIN (PK employee id email phone number job_title name PK room number employees Departments manages employess prepares Rooms room type performance_metrics FK customer i K room number price_per_night Reservation checks in checks out room_description confirms PK service id service type price description check in date K reservation. check out date PK reservation.id) Customer requests Other Service makes Payment FK customer_id 100 0000 00 PK customer id customer_name phone number PK payment id payment date payment date