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
Get step-by-step solutions from verified subject matter experts
