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

OCR I.C.T Double AwardI must design a system which would then be implemented and help solve the sports centres problem. I must Introduction state the;

Extracts from this document...

Introduction

Section E: System Design Section E - System Design Introduction User Requirements Sources of Information Inputs, Process and Output Required Software Applications to be used Objectives of the System Design of Tables Introduction In this section, I must design a system which would then be implemented and help solve the sports centres problem. I must Introduction state the; o User Requirements o Sources of Information o Inputs, Process and Output Required o Software Applications to be used o Objectives of the System o Design of Tables Then using this information I will implement the system to replace their current manual system. The problem the system faces is that the sports centre must do everything manually; they must file each member's into the cabinet, they must type each member's letter out, look up each member's mailing details from their paper application form and then add the details into each individual letter. This system should solve this problem, but in this section I will only design it. Design of Tables Table name: Field Data Type Description Validation Rule Members ID Text, Autonumber Enter member ID <L000 Surname Text Enter the surname Field size 25 First name Text Enter the first name Field size 15 Address Text Enter the address Date of Birth Text Enter the D.O.B Short Date City Text Enter the City Field size 10 Postcode Text Enter the postcode Field size 8 Contact phone, home number Text Enter the home number Field Size 11 ...read more.

Middle

10 Add new member Enter Mrs. Smith with doctor's number as 020789155555 Error message should appear, number is too long. 11 Close database button Open and close database. Database and all other applications inside the database should close. 12 qryFirstname Run qryFirstname in customer database in the first name field. All first names should appear. 13 >C100 Validation Rule Enter CV136 in member database Error message should appear. 14 Mobile phone number validation rule Enter 077788775555 in customer database Error message should appear, field size is 11 15 Name validation Enter in RamaanarRamaannar in customer database Error message should appear, field size is maximum 15. User Requirements The user should be able to send mass mailing to selected members; this would be the need for their problem of having to send each letter individually. The user should be able to store and retrieve customer information; this would be the need for their problem of having to search for each person's information in a filing cabinet. The user should be able to sort customer information alphabetically; this would be the need for their problem of having to order each member's information alphabetically in a filing cabinet. The user should be able to track each member and the classes they take. System should be accessible to all staff members. It should be able to protect customer information and prevent loss if information by being backed up regularly. ...read more.

Conclusion

This is better than spreadsheets as it offers a wider range of facilities and options to the user. For newsletters and other posters, a desktop publishing application would have been used such as Microsoft publisher. They can use various templates which make it easier to design the poster or newsletter. For letters, reports and other general information a simple letter would have been used. The Sports centre may have had a pre-made template which would have contained header/footer containing their information and their logo. All they would have had to do was enter the information. This would have been done using word processing, such as Microsoft Word as it is easier to enter the information and since letters are mainly formal statements Microsoft words' template would make it easier to create. Objectives of the System The system should be able to create mail merged letters containing all customer information. The system should be able to store and show customer information. The system should be able to create new customer information and sort them out alphabetically. The user should be able to see each member's information and their history. The system should be able to log each member's activities and the classes they take. The system should have security. The system should be able to add new class details and check for activity times. The system should be able to edit customer information and apply it to the database. ?? ?? ?? ?? Rohan Meswani Section E - System Design Page 1 of 12 ...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 ICT in Business 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 ICT in Business essays

  1. Business Aims and Objectives.

    Security is often contracted out to specialist security companies. In many cases, security guards also monitor and report health and safety risks and some may be trained to perform first aid. The organisation's head of security will advise on security precautions, such as the installation of closed - circuit television.

  2. The purpose of this document is to define the Context of Cain Motors Information ...

    Raised: 02/05/2007 Project Manager: Mr Shirley Risk Description of Resources/Outcomes: Analysis may not match high-level management strategy Likelihood: Low Impact: High Impact Description: The cost on the project, for changing the design methodology, would be that production would be stopped, while further investigation into the system was covered.

  1. Describe the functions and structural design of the cerebrum.

    It is considered a 'primitive' structure of the brain and acts with the thalamus to control wakefulness, attentiveness, and sleep patterns. It is composed of the midbrain, pons, and medulla oblongata. The midbrain aids in controlling ocular motion. The pons aids in controlling eye and facial movements, facial sensation, hearing, and balance.

  2. Business options

    Appendices Glossary Virus - a virus is a piece of software which has negative effects on your personal computer. This can range from complete loss of control to wiping of your hard drive. Anti virus - anti virus software is software which is designed to combat viruses which you may have contracted while using your computer.

  1. Critique of Klemperer's 'Auction Design'

    And with this method, it is much easier to convince the human mind to believe that the house is worth $1,000,000, or more! However, as the article mentions, one should not be over-excited at the prospect of auctioning everything. Like most things, auctions can have their pit-falls.

  2. Estate agent.I will be creating a system that will help my client to let ...

    Observation Advantages: You get to see first hand how the business is run. Disadvantages: People might behave differently when being observed. The reason that I have chosen to do an observation is so I can see first hand how the business is run and no one will lie.

  1. Unit 9 Impact Of ICT on society

    Video conferencing requires at least two locations, each with its own system, network, conference or meeting room and operating instructions. Each location, therefore, normally should have a skilled operator of video systems to assist users in getting a conference started and keeping it running.

  2. The Entourage System: A Feasibility Study

    Hardware * The hardware of the system should be compatible to support the website's interface, and provided with a reliable and consistent processor speed. The system should have sufficient memory and disk storage to operate the websites features successfully. Audio Visual clips This option is only available in certain versions

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