submission.
You must use ER style conversions for subclasses in this diagram if exists.
The table represents the multi-values attribute must have the name which is the
concatenation of the table name and the attribute name. For example, if table named
Student has the multi-values attribute named Phone, the name of the corresponding table
must be StudentPhone.
name:
nvarchar(100)
00
nvarchar(100)
contact
hotellD int
Hotels
has
street
nvarchar(50)
city
nvarchar(50)
address
nvarchar(100)
questi int
bookingID int
N
N
N
books
Rooms
Guests
roomNumber:
int
floor int
building
nvarchar(200)
Picture 1.1
fullname:
nvarchar(50)
phone:
varchar(15)
email
varchar(50)
Question 2:
Write an SQL query to display all employees who are chefs or managers and were hired in
2021, as shown in the following figure:
Zoom
- FUO
+ 100%
Close
