• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

You have been asked to create a database to handle various account combinations of customers in a bank of your choice. Your database must consist of at leas three tables (maximum of 7) to store information about customers, accounts, investments, mortgages

Extracts from this document...

Introduction

GNVQ ADVANCED INFORMATION AND COMMUNICATION TECHNOLOGY ASSIGNMENT - UNIT 6 DATABASE DESIGN SCENARIO You have been asked to create a database to handle various account combinations of customers in a bank of your choice. Your database must consist of at leas three tables (maximum of 7) to store information about customers, accounts, investments, mortgages, etc. The bank offers a range of accounts, such a current, student high rate deposit, etc and a range of investment services such as Individual Savings Account (ISA) or a portfolio holding shares. A customer may have more than one account and at the same time may also hold an investment or a fixed rate mortgage (or both). Your working database will allow users to: * set up new accounts * enter, view, and edit data in entry forms * initiate queries to search for specific information * and generate a monthly overall financial statement for each customer USER SPECIFICATION PURPOSE A model is a representation of something in the real world. We use models in all walks of life because they represent a simplified view of the world, highlighting the part which interests us. A good model should: Aid communication A model that is difficult to read or understand is of no use. Projects of various sizes all depend upon communication - exchanging ideas, discussing proposals, understanding requirements. A model should aid all ideas. There is no use communicating a complex model as it will be difficult to understand, to verify and to maintain. A test which can be applied to any model is to give someone unconnected with the system and ask them what the model represents. If they describe the system accurately then a good model has been produced. Fits its purpose A good model should have an explicit purpose that everyone uses it recognises. Project models are produced at many different stages of a project life cycle for various purposes. ...read more.

Middle

8) The whole database should be able to be filled in between 21 to 30 minutes. 9) A minimum of 5 tables should be implemented which will include information on customers, accounts, investments and insurances. 10) Information should be made available in different tables, which will be identified by the customer ID. 11) Colour should be implemented to make the database more interesting and easier to identify different sectors. 12) Certain boxes/cells should contain validation rules as it will mean that errors are minimised. 13) Certain formulas should also be implied as it will mean that it is for less time consuming. NORMALISTATION THE STEPS INVOLVED IN ORMALISTAION The steps involved are the creation of an un-normalised form (UNF) followed by first (FNF or 1NF), second (SNF or 2NF) and third normal forms (TNF or 3NF). UNF Collect all attributes and select a key for the un-normalised relation. The key could be any item but select a 'reasonable' key - that is, unique for the particular data source, involving the smallest combination of items possible and not textual. 1NF Remove all repeating groups of attributes (those with several values determined by a single value of the key) to form a new relation. The key to this new relation will be the key of the UNF (which should be taken with the removed group of attributes) plus any further attributes belonging to the removed group which are necessary to uniquely each row. 2NF Remove attributes determined by part of a compound or composite key to form a new relation. The determining attributes become the key of the new relation. A relation is in 2NF if it is 1NF and every non-primary key attribute is fully functionally dependent on the primary key. 3NF Remove attributes determined by non-key attributes to form a new relation. The determining attributes become the key of the new relation. Mark foreign keys. ...read more.

Conclusion

Married/Single SORT CODE PRIMARY Sort code Number LI Branch name Text 20 chars Branch address Text 50 chars CUSTOMER ID PRIMARY Customer ID Lookup wizard / / CURRENT ACCOUNT NUMBER PRIMARY Current account number Number 8 digits Date of CA transaction Text 8 digits Format:00/00/00 CA start balance Currency / / CA Money out Currency / / CA Money in Currency / / CA Overdraft limit Currency / / CA Description Text 50 chars CUSTOMER ID PRIMARY Customer ID Lookup wizard / / SAVINGS ACCOUNT NUMBER PRIMARY Savings account number Number 8 digits Date of SA transaction Text 8 digits Format:00/00/00 SA start balance Currency / / SA Money out Currency / / SA Money in Currency / / SA Overdraft limit Currency / / SA Description Text 50 chars Interest earned tax year ending 2002 (before tax) Currency / / Lower rate tax deducted Currency / / CUSTOMER ID PRIMARY Customer ID Lookup wizard / / MORTGAGE ACCOUNT NUMBER PRIMARY Mortgage account number Number 8 digits Date of MA transaction Text 8 digits Format:00/00/00 Balance bought forward Currency / / MA Description Text 50 chars Debit Currency / / Credit Currency / / ENTITY RELATIONSHIP DIAGRAM An entity relationship diagram is a graphic used to represent entities and their relationships. Entities are normally shown in rectangles or squares, and relationships are shown in diamonds. The cardinality of the relationship is shown inside the diagram. The simplest form of binary relationship is a one-to-one (1:1) relationship, in which an entity of one type is related to no more than one entity of another type. The second type of binary relationship is one to many (1:N), in which an entity of one type can be related to many entities of another type. The third and final type of binary relationship is many to many (M:N), in which an entity of one type corresponds too many entities of the second type, and an entity of the second type corresponds too many entities of the first type. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Peer reviewed

    information systems assignment 2

    4 star(s)

    available for any type of information which is needed to be used, the ones available are, * Column * Bar * Line * Pie * XY Scatter * Area * Doughnut * Radar * Surface * Bubble * Stock * Cylinder * Cone * Pyramid Each of these all have

  2. System Analysis The aim of the Jewellery store system is to make the work ...

    A System Development Life Cycle (SDLC) is an organizational process of developing an information system to solve business problems and needs. SDLC means combination of various activities. In other words we can say that various activities put together are referred as SDLC. These various activities are called phases of the SDLC.

  1. Computing Project

    Modular structure of system (Top Down Design) Membership Form - The member ship form will be used by the user to register new members with the shop. The data entered will be stored in the 'Members Table' It will also allow the user/clerk to edit or update the data of the members if necessary.

  2. What is transaction processing?

    personal reference numbers etc in order to gain money, details or personal information etc. Another disadvantage is that we as a society have become more reliant of this form of transaction and if problems arise, such as mechanical failure we could be find ourselves unable to carry out transaction in

  1. Discuss the relationship that exists in the UK between the legal rules that govern ...

    All these cases helped bring focus on the topic of corporate governance the result of this focus was The Cadbury Report which included the code of best practice. This code set out guidelines for the board of directors, non-executive directors and executive directors to follow as well as giving guidelines on reporting and controls.

  2. Smart Card System

    Portable Java achieves its portability by completely defining all aspects and properties of all types, leaving no decisions to the compiler writer. Java's libraries are designed for complete portability. f) High-Performance In Java, greater speed could be achieved by translating Java's byte codes into native machine instructions.

  1. Introduction of Communication

    RSS is relatively new and not many websites support it. The feeds create higher traffic on the server, because of this the feed is often slow, and the user might prefer to visit the website. Screen Based Personal computers Touch Screens SMS (Short Message Service)

  2. Computing Project

    start of the day he checks his diary to see what students he has and gets all their folders. He updates the student folder by adding 1 to the total lessons and writes what he has taught today, what the student did well and what they were weak at.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work