• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  • Level: GCSE
  • Subject: ICT
  • Word count: 5399

Terry's Turkeys

Extracts from this document...

Introduction

Introduction I have been asked to design/ create an application, either programmed or using a relational database or using a combination of both, to replace the current manual record-keeping system for a company called Terry's Turkeys; a small farm which supplies fresh, home-grown turkeys at Christmas. Initially, at least, there will be only one standalone workstation with a printer attached. This is to be kept locked in the farm office. There are a number of methods of developing the new system. 1. Manual system. Improve the system that Terry uses at present; however this would be very tedious as invoices have to be word processed, printed and then kept in a folder for future reference. 2. Spreadsheet system. This would allow Terry to keep details of customers, turkeys and orders on separate sheets. The calculation of invoices would be made easier to some degree. However, it would take a long time to enter data and is less user friendly. Also the format of reports is much harder in Excel. 3. A purposely designed system. Written using a 'high' language such as Pascal. This would obviously have a lot of advantages as the system would cater for every aspect of Terry's activities; because it's been specifically designed for the task. However the cost of this kind of package is very high and Terry would spend a lot, if not all of the farms profits. Also it takes a long time to code some areas whereas in Access they are easily done in tables. 4. Access database. The new system can be developed using Access, making a relational database with different tables storing the customer, turkey and order details. For this project a relational database (Access) will be used. This package is suitable as it has many features which can be used in developing the system, such as: * The ability to link tables via a primary key and foreign key; * The ability to set a password to prevent unauthorised access and to protect customer details. ...read more.

Middle

Surname is recorded so the customer can check they have the correct order. Duplicates will be allowed as some people have the same surname. It is limited to a field size of 15. Middle initial is noted so that if there is more than 1 customer with the same forename and surname the middle initial will most likely be different, to make sure it is the correct customer. The field size is 1 as only one letter is needed. Duplicates allowed. Telephone number the customer's telephone number is recorded so that they can be contacted if there are any problems, but mainly so they can be contacted to tell them to come to pick up their turkey(s). Order Records The third table will be the order details. Order details (Order Number, Date of order, Requested weight, Turkey number 1, Requested weight 2, Turkey number 2, Requested weight 3, Turkey number 3, Requested weight 4, Turkey number 4, Requested weight 5, Turkey number 5) Field Name Comments Data Type and Length Validation Order Number Individual number to every order Text (7) Unique (no duplicates). Made from customer initials and date. Date of order Orders cannot be made before November 1st 2004. Entered automatically using today's date. Text, date and time. >=01/11/2004 AND <=24/12/2004 Required: YES Requested weight 1 Has to weigh between 5 and 10 kilograms. Also to the nearest half kilogram. Real number Between 5 - 10 Required: YES Requested weight 2,3,4,5 (separately) Can be 0 as customer doesn't have to order anymore turkeys. Also to the nearest half kilogram. Real number 0 OR Between 5 - 10 Turkey weight given 1,2,3,4,5 (separately) Turkey weight taken from the turkey list. Real number Unique Turkey number 1,2,3,4,5 (separately) Matching a turkey(s) to the customers order. AutoNumber No duplicates Cancelled The box will be ticked if the order is cancelled Yes/No Order Number is the primary key as it is unique and can be used to search for an order. ...read more.

Conclusion

Security Security is provided by making sure there are safeguards to ensure that data is not accidentally or maliciously corrupted. Passwords The system will have a password, which prevents the user from changing the design or appearance of forms. All the user will be able to do is enter the appropriate information in the correct sections. The only person who will have total access to all areas, both the users and behind the scenes of the database, will be the administrator (Terry). Encryption Data could be encrypted meaning data appears garbled unless you know how to decrypt the data. This would add more security. Other Security Recommendations I would suggest the user has various security measures for the system. > There should be a password to open the application and keyboards and monitors should be locked, via a password, when they are not being used or are left unattended which only the user (Terry) will know. This will keep the database secure from people who are not officially allowed access to the database. By putting passwords on the system it will also comply with the Data Protection Act. There will be several rules for passwords; these include: * Passwords should be at least 6 characters * Passwords must not be displayed on the screen but must be masked by asterisks. * Files containing passwords must be encrypted * Passwords must be kept confidential * Passwords must be changed regularly > Keeping the room containing the computer system securely locked and alarmed when they are not being used. > Installing a virus checker. Testing strategy Everything that has an input on the system will be tested. This will include command buttons, queries, validation rules and input masks. This will test the functionality of the system. It will be done by testing slightly incorrect values and extreme values. The system will also be checked against the brief to check it meets the end-user's requirements. ?? ?? ?? ?? Chris Davies Computing 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. Explain the difference between primary and secondary sources of data, with examples.

    produces qualitative data. Using closed questions (fixed response answers) produce quantitative data. Questionnaires maybe postal which has a low response rate self administered where the person fills them in themselves or in the form of a interview where the researcher reads out the questions Questionnaires are used to reaching a large number of people because the forms can just

  2. System requirements analysis

    The monitor has a coating that is anti-static/anti-reflective and produces flicker-free images and easy viewing. The E773 monitor is designed for a wide range of users and can be used at home as well as at work. This monitor is also quite cheap, being only �79.00.

  1. System administration report

    The problem with portability is that it is prone to viruses, works on a certain pattern and software and hardware are not compatible. It also has a problem with upgradability, as it is not 'downwardly compatible. If it does need to be upgraded then a new version of the IGS booking software will need to be purchased.

  2. task2-report-template 3

    This Film Transistor Monitor (TFT) size 17 To display information on the screen. RAM (3 GB) To have the ability to open more than one application at once and switch between them quickly. Keyboard, mouse and Scanner To input data. Magnetic tape To backup data Software Reason of using it Database To solve the business

  1. ICT PROJECT

    Enter unsuitable mark in the input box e.g. 15.3 To see how validation system reacts to erroneous data Should not accept data, user will be ask to enter correct data 28. Enter erroneous data e.g. bobby To see how validation system reacts to incorrect data Data should not be accepted, user will be ask to enter data within boundary 29.

  2. ICT Access

    switchboard allowing the user to navigate easily around the with a user friendly interface, therefore Mr. Hock identifies Access as the most successful application to solve his problem. Chosen Solution Finally the use of a computer software package, which allows the construction of an effective database system, will determine the most appropriate form of property and client detail storage.

  1. Create a power point presentation for people who dont understand cricket so I can ...

    game form The explanation of the possible forms of cricket The audience needs to know what type of forms are available in cricket 15 Forthcoming world cup The location as to where the world cup is going to be held with the venue country's flag Anyone from the audience interested

  2. Develop a spreadsheet application for the Ibis Hotel.

    Gathering information I collected huge information from the Ibis Hotel in order to develop a database program. I sued the following three techniques to collect data: * Observation: I visited the hotel for three days and discussed matters to the general manager and the staff of the hotel.

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