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

System specification

Extracts from this document...

Introduction

Specification This shows my final system and what I would like it to be able to do. The system will be successful if - - The interviews and research took place and were successful enough to uncover all the problems about the current system - The data collected can be analysed in detail so the current system can be completely studied - The system has some validation as the data is entered to help the new user understand it, and where they might have gone wrong - this limits the number of mistakes that can be made e.g. a multiple membership number would not be allowed by the system - The data structure has been carefully designed to accommodate all the data needed in the database e.g. if a field needed to be a 'text' field, with words no longer than '10' letters long, the system will only allow text up to 10letters long - this will limit the amount of space the data can take up - The system can sort and search data easily so a particular customer or cd can be found quickly and easily - the staff can find a ...read more.

Middle

I would like my system to be - - User friendly - Easy to use - Presented effectively - a good understandable layout - Easy to understand - instructions that can be understood by first-time users Member's Table For the membership table I want - - To create a table in a database to store all the member's information. It needs to contain these fields - Title Email Address Name Cardholder Initials Surname Card Number Address Card Type City Expiry Date County Music Preference One Post Code Music Preference Two Telephone Number All these fields essential because the information is needed to tell the company about the individual customer e.g. name, address etc. It will also be able to let the customer buy cds from the company, and it will also tell the company what types of music the customer is interested in. - To have all the number fields i.e. post code, telephone number, credit card number, credit card expiry date; to be entered using an input mask. - To have the fields title, credit card type, music preference one and two; to have a look-up wizard - this will save time in typing and there will be no mistakes in spelling. ...read more.

Conclusion

- All other fields will be text fields with different field lengths (field lengths are in place in order to save space and so that a title, or name can be no longer that the set number) - o Cd Title - 25 o Cd Band Name - 30 - To be able to query the data so that the company can find a particular cd, and to speed up the process of ordering. Orders Table For the orders table I want - - To create a table in a database to store all the information about what customer has orders what cds. It needs to contain these fields - Product ID Membership Number Quantity Order Date - All these fields essential because the information is needed to tell the company about what cds a particular has ordered. - To have all the fields i.e. product ID, membership number, quantity and order date; to be entered using an input mask. - To be able to query the data so that the company can find a particular cd, and to speed up the process of ordering. Emma Smith Specification ICT Coursework ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Database Coursework

    It should be able to do this within 2 minutes. I was successful in doing this. Customers can be added easily in 2 minutes. At the most, it may take around a minute to add them. Findings specific records within 30 seconds: it should be able to find specific criteria's within 30 seconds.

  2. ICT Coursework (MarcoS)

    On the second sheet, there will be inserted all the data about loss of money with a chart and the total amount of loss. The third sheet will be about incoming money, also here there will be inserted all the data about it and there will be a graph and the total amount of incoming.

  1. Hospital Information System

    Majority of the doctors do not believe that the existing system can help reduce the cost of patient care or shorten the stay of the patient in the hospital. Table - 3 Disadvantages of existing Hospital Information System Doctor's responses regarding the existing system Strongly Agree Agree Disagree Strongly disagree

  2. ICT specification

    Furthermore this type of personal is in charge of all toe new buys the company makes for example in cars and they make sure improvements are made. The customers of this business are people in need to rent a car these people could be anyone whom for example, is in

  1. ICT car insurance quotation System Coursework

    What outputs will the end user receive? Answer: Once the user form has been processed, the output is a detailed summary of the data entered previously. What will the output be used for? Answer: The output will be used for confirmation to the end user of their quote, and will be given a policy and reference number.

  2. drum kit costing system

    Zildjian ZBT/ZXT cymbal cleaner � 7.00 Doc's Proplugs � 12.95 Isolation Headphones � 27.99 Qwik Time metronome � 19.99 Stagg MC-03XX DL/BL 3 metre mic cable � 4.40 ProMark Cymbal Rattler � 11.95 Stagg MSFM Free mounting music stand � 17.50 Vater's Stick Holders � 11.95 Moongel � 5.99 Pearl K050 drum key � 2.19 Cymbals Price (�)

  1. Design Specification for Dream Tours.

    When the business develops there will be supplementary cruises to each countries, I the systems developer can explain you how to insert a new row/ column for a country devoid of remaking a new spreadsheet. Around the sides of the spreadsheet rows and columns heading are displayed.

  2. Creating an IT system for Rileys an American pool and snooker hall.

    Shahaan - Thank you for your time Manager - - Thank you . . I talked to customer as he became a member and asked him what personal information they asked in the membership forum so I can use it to put in database.

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