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.

Deliverables:

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
how to implement hyrise in C plus plus

State the Design of Associations Before designing associations, it is essential to know the way they are used. For this, analysis of association traversals is required. It is

Explain natural join? Natural Join - Similar as equi-join except in which the join attributes (having similar names) are not involved in the resulting relation. Only one sets

Consider the subsequent relations for a database which keeps track of business trips of salespersons in a sales office: SALESPERSON (SSN, Name, start_year, Dept_no) TRIP (SSN, Fr

Explain the EXISTS and UNIQUE functions of SQL. Give an example for each? EXISTS: The EXISTS function takes one parameter that is a SQL statement. If any records exist which

CAR SALE (Car_id, Option_type, Option_listprice, Sale_date, Option_discountedprice) This relation refers to options installed in cars (e.g., cruise control) that were sold at a de

Define upgrade and downgrade? It gives a mechanism for conversion from shared lock to exclusive lock is called as upgrade. It gives a mechanism for conversion from exclusive

Explain the Difference between DROP and DELETE DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from th

Data Redundancy -A lot of information is being repeated in the relation. For instance, the information that MCS-014 is named SSAD is repetitive, address of Rahul is "D- 27, Main ro

Describe disk manager and their work? Disk Manager: Responsible for fetching data regulated through file Manager from disk storage within Main memory and deciding what data to