tables, relationship, attributes and data type of attributes as SAME as given in the given
✓ Kizspy.me ERD.
Attributes with underline are Primary Key of each entity.
Attributes which reference to the primary key of another table must have the same name as
the attributes in the primary key of the referencing table.
If a table must be created for representing a relationship, the name of the table must be the
same as the name of the relationship.
When submitting the responses for this question, submit only SQL statements for creating
tables with corresponding keys and foreign keys. Do not use "create database", "Alter
database", "use database_name" or any statements using database's name in your
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.
Zoom
brand
nvarchar(50)
+ 100%
model
computerNo
varchar(25)
nvarchar(50)
serialNumber
nvarchar(50)
Computers
proNo
isAssigned
role
varchar(30)
varchar(20)
startDate: date
Close
