specify
Member rating: No Rating | Words: | Submitted: Sat Oct 20 2007
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
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...


