Lab Assignment
You're working at ABankForYou...A bank that prides itself on its database systems and applications. You will be designing and implementing the database as well as three interactions for the system:
1) Check Balance
2) Deposit Money
3) Withdraw Money
Information that is stored in the system is as follows:
Each person has a name and an address. Each person also has the ability to have a checking and a savings account, although they don't have to have both, they MUST have one. The way the system handles overdrafts is completely up to you. An overdraft is when a person tries to withdrawl more money than they have in their account.
Your group is expected to design the entities for the system, design the database schema, input at least twenty users, and design the functionality as transactions for the three scenarios outlined above.
Deliverables:
- Entity Relationship Diagram
- Database schema (including indexed fields with documentation of why these fields were chosen to be indexed)
- Transaction descriptions
o Perform the steps for SQL coding and tuning efficiency (focus on tying the query to the business need)
o Queries for transactions
- Including what complexities, they possess (joins, etc...only the ones covered in lecture are necessary)
- Application design (on paper or powerpoint) showing what happens when each element is interacted with including which transaction is being performed
o You may consider turning in a separate document for each of the three interactions
- Show database statistics covered in class (From the GitHub from the book) for your system
- .sql file with database structure
- .sql file with data population
- .sql file with index creation
- .sql with queries included in transactions
- .sql with statistics
- A document from each individual letting me know what they, AND EACH GROUP MEMBER in their group did.