Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Records And Database Management

Authors: Jeffrey R Stewart Ed D, Judith S Greene, Judith A Hickey

4th Edition

0070614741, 9780070614741

More Books

Students also viewed these Databases questions

Question

1. What are the pros and cons of diversity for an organisation?

Answered: 1 week ago

Question

1. Explain the concept of diversity and equality in the workplace.

Answered: 1 week ago