Design and implement a database system, Database Management System

Safe Banking is a Canberra based credit union, which has several branches around Canberra and Queanbeyan. YOU have taken over Safe Banking. YOU need to create a database that organises the information to run Safe Banking's operations and administration. The bank uses several types of documents in running its business. Samples of these documents are attached. You will need to analyse these documents so that you can design and implement your database.

The first document is an application to become a member of the credit union and create one or more new accounts. This document has four pages. If the application is from a new member then a new member number will be assigned to the member. Member numbers are unique across all the branches. Likewise account numbers are unique as well. Accounts come in seven types which are listed on the form.

The second document is actually three documents on the one page. These documents are used to do the basic transactions on an account. The transactions are deposit, withdrawal and transfers. These transactions need to be recorded including the Id number of the staff member who processed the transaction. These forms have the member number, account number, date, and amount to deposit, withdraw or transfer. In the case of a transfer the account to and from are required. Members can also deposit and withdraw cheques.

The third document describes the different functions of each savings and transaction account that Safe Banking offers. YOU will need to study this document carefully to understand how the accounts differ from one another. A form is required to enter this data and show a table similar to the one at the bottom of the document.

The last document is the interest rates schedule. This again is an important document as the data contained in it needs to be stored in the database. The finance officer in the bank is in charge of keeping this data up to date. They will need a form to be able to access the records to update or print a report similar to this document.

The staff of the bank may work at any branch. The current branch a staff member is working at needs to be recorded. There are several types of staff members. The manager is the person in charge of a branch. Each branch has 5 departments: loans, teller, help desk, finance and accounts. There is a supervisor for each department. Each staff member has a unique Staff ID number.  Managers have a car and a car park spot. Supervisors have a car park spot. Tellers have done special training for using the computer system and help desk personnel have done conflict resolution courses.

Finally, an account may have more than one owner. If an account is overdrawn then a letter is sent to the account holder/s to fix the problem. For example if the member writes a cheque but does not have enough money in the account when the cheque is cashed then the account will be overdrawn.


YOU are required to design and implement a database system. Your database system must have the facilities/functionalities to:

  • Enter member and staff information.
  • Enter personal account and loan information.
  • Enter the interest rate schedule.
  • Record the transactions on the various accounts.
  • Report all the members by postcode.
  • Report on all staff by position type in staff number order.
  • Display the transactions for a single account by date.
  • Display the account type information.
  • Print a report of any overdrawn accounts.
  • Print a report of account balances by account type.
  • Print a report showing the interest rate schedule.
Posted Date: 2/21/2013 5:16:12 AM | Location : United States

Related Discussions:- Design and implement a database system, Assignment Help, Ask Question on Design and implement a database system, Get Answer, Expert's Help, Design and implement a database system Discussions

Write discussion on Design and implement a database system
Your posts are moderated
Related Questions
Briefly explain what is to be done during defining problem statement. To define Problem Statement of a system, define what is to be done and how you can go to implement that. Y

Develop Database academic assignment Project Description: For a provided set of instructions in a case study design Entity Relationship Diagram. - Entity Relationship Diag

Gyan Gurukul is a software company that provides software related solution. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan G

Why containment is important in oosystems? Containment is an significant concept in oosystems because it allows dissimilar users to view data at different granularities.

Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs

What is hashing file organization? In the hashing file organization, a hash function is computed on some attribute of every record. The result of the hash function specify in

Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator.  Altern

List the string operations supported by SQL? 1) Pattern matching Operation 2) Concatenation 3) Extracting character strings 4) Converting among uppercase and lower cas

Explain Interblock gap? Interblock Gap - A track of a disk is separated into equal-sized disk blocks. Blocks are separated through fixed-size gaps, called as interblock gaps th