A database is designed to keep data so that it can be easily retrieved for future use. A Database of customers will be designed that operate various account types, Using GTbank as a case study.The name of the database is CHIDIEBERE_ACCT having four (4) tables with relevant fields as follows;
CUSTOMER – Customer ID, First name, Last name, address, sex
ACCOUNT_DETAILS – Account No, account name, account type, date opened, Branch ID, account officer, customer ID, Amount
BRANCH – Branch ID, branch name, branch manager
TRANSACTION_DETAILS – Transaction ID, transaction description, transaction date, debit, credit, Balance, Account No.