Provide a report that includes screenshots of all the tables. First, show us a picture of your
Question:
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
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill