Question: Program in SQL: A software product that records and tracks all your bank accounts. The main menu shows the following possible transactions: NewAccount: Enter information

Program in SQL:

A software product that records and tracks all your bank accounts. The main menu shows the following possible transactions:

NewAccount: Enter information of a new bank account: BankName, Account#;

DeleteAccount: Delete an account;

Deposit: Enter information of every deposit transaction using Account# or BankName: Date, Amount, amount of CashOut;

Withdraw: Enter the information of every withdraw transaction using Account# or BankName: Date , Amount;

EnterCheck: Enter information of each check you write: Check#, CheckDate, Amount, ToWhom, ForWhat;

EnterStatement: Enter the information of each bank statement you receive: StatementDate, StartDate, EndDate, Balance, and a single line for each,

Check cashed including: Check#, CheckDate, Amount, DateCashed;

Deposit: Date, Amount;

Withdraw: Date, Amount.

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!