name:nvarchar(200)
phone:decimal(10,0)
M
address:nvarchar(200)
M
empID:decimal(18,0)
Employees
Join Project
Projects
projID:int
projName:nvarchar(200)
startDate:date
isa
isa
PermanentEm ployees
Contract Employees
baseSalary:money
salaryScale:int
dailyPay:money
numberOfDays:int
Picture 1.1
Question 2:
[1] Write a query to retrieve the model and year of silver car(s) which as follows:
+ 120%
Zoom
Close
