for you to use in this course.

Write and execute DDL to create database tables in MariaDB to support a simplified version of bank accounts and transactions on those accounts.

The only types of transactions supported are deposits and withdrawals. Each deposit is designated as such using a transaction type code value of $1,$ while the transaction type code for withdrawals is $2.$ Your database should record the fact that transaction type code $1$ is associated with the transaction type name 'Deposit', and $2$ is associated with Withdrawal".

Each transaction is assigned a unique integer transaction id$.$ Assign $1$ to the first transaction you create, $2$ to the next, $3$ to the next, and so on$.$

The date and time of each transaction is captured.

The amount of each deposit and each withdrawal is stored as a positive value. YYou can assume that any soffware using these data values will know to add deposit amounts to an account baiance and to subtract withdrawal amounts. You do not need to perform any of those calculations as part of this assignment$)$ Use the data type discussed in the instructional video for storing currency amounts, and include the keyword that instructs the database to allow only positive values. You can assume all transaction amounts will be less than one bilition dollars, which means a maximum of nine digits to the left of the decimal point, plus of course two digits to the right of the decimal point for the pennies.

Each deposit or withdrawal transaction affects a single bank account, each of which is identified by a unique account number. We also know the dato each account was opened and the name of the person who owns the account. Each account has only one owner:

To keop things simple, just include a person's name as part of each account record. Do not store any additional information about bank clients. You can assume a name will be at most $16$ characters. The owner name for an account is the only field in this database that can sometimes be null

Part of your task is to decide what tabies you need to defire. Remember the guidelines mertioned in the instructional videos:

Each tatile shoud store a list of something

When you have a situation where "For each $x$ mere are multiple $Y^{**}$ then you should consider soparate taties io list instances of $x$ and $Y$