Question paper (build 07.05.20.19)
must be StudentPhone.
name:
nvarchar(100)
phone
nvarchar(20)
restaurantID
int
Restaurants
has
street
nvarchar(50)
address
nvarchar(100)
city
nvarchar(50)
N
N
N
Employees
works
Shifts
emplD: int
FullName:
nvarchar(60)
gender
char(1)
Picture 1.1
shiftD int
shiftDate: date
startTime:
time
endTime: time
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:
3 of 3
Paper No: 10
