Kizspy.me
Question 1:
Create one database and then write SQL statements to create, in this database, all tables
derived from the ERD given in the following picture with appropriate attributes, primary keys
and foreign keys.
NOTE that when creating the SQL commands as request, you MUST keep the name of
tables, relationship, attributes and data type of attributes as SAME as given in the given
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.
balance
money
accNo
varchar(25)
Zoom
- FUO
+ 100%
open Time:
Datetime
Accounts
1
1
Owns
Links
CardNo
varchar(20)
expiryDate
date
Close
