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", "Alterdatabase", "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.
accNo varchar(25)
openTime:
Datetime
branchNo: int
address: text
balance:money
N
Account
N
OpenAt
Branch
N
Owns
nvarchar(100)
1
Bank
N
Belong To
role:
Customers
Zoom
+ 100%
Close
