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.
accNo
varchar(25)
openTime:
Datetime
balance
money
Accounts
1
Owns
Customers
SUSID: int
FullName
nvarchar(60)
FirstName:
nvarchar(30)
phone
nvarchar(100)
Links
CardNo
varchar(20)
expiryDate:
date
LastName
nvarchar(30)
Picture 1.1
N
Cards
cardType
varchar(30)
creditLimit
money
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
