Question

Account id balance is a is a overdraft_fee Checking Savings number interest DebitCard uses

          Account
id
balance
is a
is a
overdraft_fee
Checking
Savings
number
interest
DebitCard
uses

Added by Jim N.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Keondre Parker

Step 1

The main entities are Account (parent class), Checking (subclass), Savings (subclass), and DebitCard (separate entity). Show more…

Show all steps

Thanks for your feedback!

Translate the diagram above by writing the SQL CREATE TABLE statements to represent this E/R diagram. Include all key constraints; you should specify both primary and foreign keys. Make sure that your statements are syntactically correct. CREATE TABLE Account ( id INT PRIMARY KEY, balance DECIMAL(10,2) ); CREATE TABLE Checking ( number INT PRIMARY KEY, overdraft_fee DECIMAL(10,2), FOREIGN KEY (number) REFERENCES Account(id) ); CREATE TABLE Savings ( number INT PRIMARY KEY, interest DECIMAL(10,2), FOREIGN KEY (number) REFERENCES Account(id) ); CREATE TABLE DebitCard ( id INT PRIMARY KEY, uses INT, FOREIGN KEY (id) REFERENCES Account(id) );