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
Q. Describe how an ER schema can be represented by relation schemas and constraints arising from ER design can be mapped to constraints on a relation schema.     The entity rela

Data Manipulation Language Data manipulation language (DML) describes a set of commands that are used to query and change data within existing schema objects. In this case comm

write-set(T): Each data items that are written by a transaction T

Give a sample of the Dynamic Model. The sample of dynamic model is given below:  Dynamic model for the car: Brake and Accelerator            Brake or Applies Accelerator

Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

ER diagram on cosmetics

Determine the rule that a value of a foreign key should appear as a value of some particular table is called a  Ans: Referential constraint.    The rule that a value of a fo

Give the reasons for allowing concurrency? The reasons for allowing concurrency is if the transactions run serially, a short transaction might have to wait for a preceding long

What are views? Explain how views are different from tables? A view in SQL terminology is a one table in which is derived from other tables. These other tables could be base t