Question: 2.2) (2 Points) Devise a reasonable database instance by filling the tables with reasonable data of your choice. Make sure to have at least 3

2.2) (2 Points) Devise a reasonable database instance by filling the tables with reasonable data of your choice. Make sure to have at least 3 tuples in each table. Make sure that all tables exhibits entity integrity and referential integrity constraints.

Branch

branchName

street

city

Golden Valley

Berkshire ln

Golden Valley

Plymouth

Nathan Ave

Plymouth

Normandale

98th St

Bloomington

Account

accountNum

branchName

balance

132873

Plymouth

100029

132874

Normandale

30481

132882

Golden Valley

204

Customer

customerSSN

street

city

321546543

Nathan Ave

Plymouth

472924857

Berkshire ln

Golden Valley

89683046

98th St

Bloomington

Deposit

customerSSN

accountNum

amount

321546543

132873

239

472924857

132874

4675

89683046

132882

10

2.3) (2 Points) Write an SQL statement to decrease the amount of all deposits by 1%

2.4) (2 Points) Write a SQL statement to increase by 5% the balance of all accounts that are created in a branch with name Golden Valley

2.5) (1 Points) Write an SQL statement to select all Customers SSNs where the city has a null value

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!