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

When It is better to use files than a DBMS? It is better to use files than a DBMS when Multiple users wish to access the data.

Log based recovery: Let us first describe the term transaction log in the context of DBMS. A transaction log is a record in DBMS that remains track of all the transactions of a dat

What are aggregate functions? And list the aggregate functions supported by SQL? Aggregate functions are functions that take a collection of values as input and return a one va

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

Design a gennalization and specialization hierarchy for an automobile sales company

What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.

Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

compare the features of oracle RDBMS with MySQL and Microsoft SQL server

In Database software have only pure security or some dis secured by administrator?