1. Create a series of transactions that suit the following scenarios. Make sure that each transaction includes the updating of the currentBalance in the accounts table.
   1. Create a customer with your name

Using that customer, add the following transactions (complete with all steps required) only need to do your side of the transactions. (i.e. no need to do your parents, landlords or other partys perspectives)

2. You open a chequing account at the bank and deposit $500.00
3. You open a savings account and the bank and your parents deposit $1000.00 through e-transfer
4. You buy groceries at Walmart and debit $112.34 from chequing
5. You purchase a song from iTunes for $1.99 from chequing. You receive a confirmation code of CQ3E5RZ.
6. You have to pay first and last months rent on your new apartment. The monthly rent is $800 and you write a cheque (#005) for it (i.e. chequing account).
7. The cheque you wrote bounces (NSF Non-Sufficient Funds) and the bank charges you a $45 fee
8. Your Mom and Dad withdrawal money from your RESP for school expenses $2000 which they deposit directly into your savings account.
9. You get a certified cheque for the first and last months rent plus the $25 fee your landlord charges you. There is an $8 fee for the certified cheque charged to you by the bank.
10. You go to the ATM to take out $40 cash to pay your friend back for helping you move your stuff into your new apartment.
11. Using online banking, you pay your Rogers mobile phone bill of $64.45. You receive a confirmation code of X8U2 and your rogers account number is 345678.

Req Default A3_ACCOUNTS FieldName accountNo accountType customerID currentBalance Example 655142 FieldType Size int string 1 int decimal 10, 2 Note sequence FK Y C FK 4356 456.78 Y 0.00 Yes this will be a calc field, but this is one example where that rule is ignored. Check constraint: >0 dtopen date sysdate 20200217 isActive tinyint y 1 1 A3_TRANSACTIONS FieldName FieldType Size Reg Default Note Example transactionID Int (auto) PK 8535482 accountNo int FK 655142 transaction Type string Dor C (for Debit or Credit) amount decimal 10, 2Y 0.00 781.25 description string 25 Y Seneca Pay transDate date sysdate 20200328 refNum string Authorization code, bill DC456778 account # etc. or 4785125 NOTE: debits and credits are from the perspective of the person doing the transaction. From the perspective of the account owner, a debit is a withdrawal (negative) from their account where a credit is a deposit (positive) to their account. Therefore, debits will typically have a negative amount, credits will have a positive amount. Background In the banking industry, there are many, many different areas where databases are required. We will simply cover bank accounts and everyday transactions that the general public performs in this assignment. Tables Create the following tables: Default Example A3_ACCOUNT_TYPES FieldName FieldType AccountType | string TypeName string Size 1 Req Y Note PK 15 Chequing Size Reg Default N ote | A3 CUSTOMERS FieldName FieldType customerID int (Auto) firstname string lastname string email string DOB date phone string 20 20 50 Y Y I I Example 4356 John Smith john@domain.com 19870516 9055551212 10