• 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. ICT PROJECT

    I have also added a password protection to the workbook; therefore whenever the user enters the system he will have to type the password to access the system. Macro Code These are the macros I have used on the front-end menu.

  2. Explain the difference between primary and secondary sources of data, with examples.

    Method: Questionnaire Survey Describe this method Questionnaires are simply lists of pre-written questions and sometimes also include scales. Which can either sent to the respondents home which often has a low response rate as people see no reason to fill them in, or can be given to the person directly to be filled in there or then e.g.

  1. ICT Coursework (MarcoS)

    Open Microsoft Excel 2007 * Click with the left mouse button on the start icon on the bottom left of your screen. * Then click on "All Programs" to view the other section with all the programs installed on the computer.

  2. Ict Powerpoint Coursework

    all slides in the PowerPoint Presentation, this can be further looked at in the design chapter where there is more detail about this function. The presentation would also be resented on digital boards and projectors so there is more awareness of the slideshow; this is for advertisement purposes as well.

  1. Database Coursework

    It would abandon the problem of reading messy handwriting, and it would also give us extra storage space also we wouldn't need the paper with information. Protecting it would also be easier and better as we would simply just have to create a password.

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

    record A4 - Example of one of the validation 1 A simple tip for the user 2. & 3. Scripts to show all records and unsort records 4. Header and the title of the field, clicking on the header can sort the record according to the sort order.

  1. GCSE IT Coursework

    * Customer Name * Customer Location * Customer Telephone Number * Regular Items that customer may buy * Subscriptions to magazines and the names of the subscribers * Average Weekly Shopping Bill * Papers To be delivered to the customer * Customer Reference Number This database will be used on the staff computer in the offices.

  2. task2-report-template 3

    The first question I asked him was "what problem do they have and how do they deal with them?" He has mentioned a list of problems he and the shop assistant are facing at the moment. Some of the problems he mentioned were: * A number of the documents regularly

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