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
Adding Redundant Associations for Efficient Access The expression redundant association means using "duplicate association for proficient access". While analysis, it is not a

Describe the storage structure of indexed sequential files and their access method.  Ans:   Storage structure of Indexed Sequential files and their access: To achieve fast rand

Question: (a) Discuss the difference between a composite key and a composite attribute. How would each be indicated in an E-R diagram? Support your answer with appropriate exam

WRITE SHORT NOTES ON INDEX STRUCTURE OF FILES? There are two basic parts of indices 1.   Ordered indices 2.   Hash indices Every technique must be evaluated on the bas

What is Disadvantages Of DBMS ? 1. Cost of Software and Hardware and Migration - A important disadvantage of the DBMS system is cost. 2. Reduced Response and Throughpu

Submission Requirements All answers must be computer generated (including text and diagrams). The hand-in version must include a header page (or with sufficient space)

1 NF Normal Form The domain of attribute must add only atomic (simple, indivisible) values First normal form (Minimal Form or 1NF) is a normal form need in database normalizat

1.  Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table (as shown in class).  Label the types of depe

Define the concept of aggregation.  Give two examples where this concept is useful. Ans: Aggregation transforms a relationship among the objects into a higher-level object. A

Project Description: I want to build a card playing Website. The user should be able to 1. Login. 2. Have profile access. 3. Put money into the site. 4. Selects t