• 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

    When any of these are altered the information is changed on the appointment letter according to the drop down menus. The output of this would be on the monitor and it could also be a print out. In order To print out this letter, you would have to click on

  1. task2-report-template 3

    * I changed the address field so that it includes house name and postcode separately. * I changed the order data field type to date field and its field length to 6. * I changed the validation rule of the condition field to "N" or "O".

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

    right button Clicking on the right button will take you to the next slide, clicking on the left button will take you to the previous slide No effect 5 Clicking on the background The heading should appear Split 5 Clicking on the background The description of the field should come

  1. System administration report

    - Room availability - Shows how many rooms are available. - Show departures - Number of departures in the hotel on a weekly basis. - Show rack - - Room status scan - How maintained is the room and is it ready to be re used.

  2. Features of a sports club database. The system has at least 1 table and ...

    This layout has validation on some of the fields to prevent the user entering invalid data.(A4) This layout has 3 different types of data: Number, Text and Container A1 - Creating a new record and new data being entered A2 & A3 - Amending the data and deleting the

  1. GCSE Database Project ICT

    Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300) Print technology Printing method 4-colour inkjet printer with Dual Black Ink System, Epson Micro Piezo(tm) print head Nozzle configuration 360 nozzles Black / 59 x 3 nozzles Colour (cyan, magenta, yellow) Droplet size 3 Pl (minimum)

  2. ICT Access

    An alternative solution is to devise a file within Word processor application generating an easier process to present the clients details, however requiring a large quantity of memory capacity and excluding the performance of client and property searches therefore staff will be requested to extract the appropriate information.

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