-Do not use any commands having the database name such as create database, alter database, use
[database name], etc.
-Your response must contain only necessary commands for answering the question. Do not include any
other command. For example, if you are required to create a trigger/procedure, then your response
should contain only commands for creating the corresponding trigger/procedure; all commands for
testing the created trigger/procedure are forbidden.
-Do not use GO command in your code
- On completion, import your work by browsing to the above folder.
- Note that:
+ You could use only SQL Server, SQL Server Management Studio, and paper or offline
document in your computer.
+ If any of the previous requirements is not respected, your mark will be 0.
From the 2nd question, you should use the database provided in the .sql file which has the following
database diagram. Please, run the provided script to create tables and insert data into your database.
ReservationTables
ReservationID
Tables
TablelD
TableNumber
•
TableID
Capacity
Location
Reservations
ReservationID
CustomerID
ReservationTime
GuestCount
OrderTables
OrderID
Status
Notes
Customers
* CustomerlD
FullName
Phone
Email
CreatedDate
Zoom
- FUO
Employees
EmployeelD
FullName
TableID
Orders
OrderID
CustomerID
OrderDetails
OrderID
EmployeelD
MenuItems
ItemID
ItemName
8
ItemID
ReservationID
Quantity
Category
OrderTime
bo-
88
Price
Price
Role
HireDate
Salary
Status
+ 100%
PaymentTime
Payment Method
TotalAmount
IsAvailable
Close
