✓ 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)
skit
nvarchar(50)
computerNo
varchar(25)
model
nvarchar(50)
serialNumber
nvarchar(50)
Computers
1
isAssigned
role
varchar(30)
proNo
varchar(20)
startDate: date
N
N
name
Employees
works
Projects
nvarchar(100)
emplo: int
FullName:
nvarchar(60)
FirstName
nvarchar(30)
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
- FUO
+ 100%
Close
