✓ Kizspy.me 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 and the name of the attribute. For example, if table named TableA
has the multi-values attribute named AttributeB, the name of the corresponding table must
be TableAAttributeB.
brand
nvarchar(50)
computerNo
varchar(25)
skill
nvarchar(50)
emplo: int
FirstName
nvarchar(30)
Computers
modet
nvarchar(50)
serialNumber:
nvarchar(50)
isAssigned
role:
varchar(30)
proNo
varchar(20)
startDate: date
N
N
Employees
works
Projects
name
nvarchar(100)
FullName:
nvarchar(60)
LastName
nvarchar(30)
Picture 1.1
Question 2:
Display all medical records in which the treatment is 'Surgery' and the record date is in the
year 2020 as follows:
Zoom
+ 100%
Close
