I need Database Expert IT

Angela Sherrock Abdulaziz Alghamdi Saad Alqahtani Mansour Alturki

Lab_4_Bank

The main purpose of this lab was to be able to create a bank database and to be able to understand the way it works. Being able to see the way it works with selecting the language, deciding on which account you would like to view and or pull money out of or to make a deposit.

Abdulaziz- create the tables and the data in the tables, queries Saad- did the Entity Relationship Diagram, the Designing and Implementation, and the Data Schema, queries Masour- did the data into the tables, the data dictionary, queries

Angela (I)- did the specs document, the statistic queries, and the index creation queries

Design and Implementation

With this you can choose your language, enter your pin. After entering in your pin you can choose which you would like to do, review your checking, savings accounts, make a withdrawal, or make a deposit. You change enter in numbers if you mistype a number and answer a yes or no question regarding if you want a slip printed or not. If you are withdrawing then the desired account needs to be entered. The same happens with depositing money and reviewing both accounts.

Data Schema

Entity Relationship Diagram

Process

Clients

Bank

Insert Card

Pin Code

Amount Blanace

Deposit

Withdraw

Select Acount Type (Savings or Cheking)

Need a print or Not

Another Transaction or Exit

Select Language

View Available Balance

Select Deposit Type (Cash or check)

Insert Cash Or Check

Press If correct or change

Need a Print or Not

Another Transaction or Exit

Select Acount Type (Savings or Cheking)

Inter Amount

Take Your Money

Need a Print or Not

Another Transaction or Exit