Database Management System of a Bank Essay Example

will appear; Transaction No,

Account No, Date, Transaction Type, Transaction Amount, Account Balance. There will be a back button as well in order to navigate through the forms. Deposit Form: The date and user will be automatically visible on the form. 0 Date: System Date 0 User: Manager's Name or Teller's Name (Login User) The manager can enter An Account Number and search the Account; the Customer Name, NICE No and Account Balance will appear and thereafter the manager can enter the deposit amount and click the deposit button. A message box will appear saying "Deposit Successful".

There will be a back button as well in order to navigate through the forms. Withdraw Form: enter the withdrawal amount and click the withdrawal button. A message box will appear saying "Withdraw Successful". There will be a back button as well in order to Teller: A teller can only insert and view data from the database. The teller can search the account details by entering an account number in the Account Number, Account Type, Account Balance and Created Date. The teller cannon create an account . The delete and create button will be hidden in the form so that he manager cannot create and delete an account.

There will be a back button as well in order to navigate through the forms. The teller can search the customer details by entering the customer NICE No in the Date. The delete, update and create button will be hidden in the form so that the teller cannot create, update and delete a customer. There will be a back button as The teller can search the transaction details by entering

an Account No in the search bar therefore all details of the transactions will appear; Transaction No, Account No, Date Transaction Type, Transaction Amount, Account Balance.