Using the data model shown above write SQL statements as specified below. Some q

Question

Using the data model shown above write SQL statements as specified below.
Some questions may require more than one SQL statement to get the full answer. You may make up whatever data values you like to complete the assignments.

SQL Exercises

Where are transactions being made? Write SQL statement(s) that will create a new table to track the branches where transactions are performed. Store data about the name, location, and phone number of each branch. Be sure to also modify whatever table is necessary to connect this new table to the existing data.

What happens when a new account is opened? Write SQL statement(s) to add data to the tables for a new account opened by an existing customer at an existing branch. (Go ahead, give yourself a million dollars!)

How much money do I have? Write 1 SQL statement to retrieve the current balance for each of your accounts.

What happens when an account is closed? Write SQL statement(s) to delete all the data associated with a single account. Extra Credit (10 points): Why is deleting these records a bad idea and what can be done differently to close an account?

Account PK Acct ID Acct num Acct Type Open date Interest Rate Transaction PK Date PK.FK1 Acct ID PK.FK2 Cust ID Amount Type Customer PKA Cust ID Name Address Phone SSN

Explanation / Answer

create table info( name , location, phone_no,branch)

update table account

inert values{ }

select current_blc from table .

drop table table-name where acc=closed;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.