• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  47. 47
  48. 48
  49. 49
  • Level: GCSE
  • Subject: ICT
  • Word count: 5275

Database design for a farmers herd book.

Extracts from this document...


Contents Task 1 2 Introduction 2 Explanation of databases and why they would be of use to this system 2 What is a database? 2 Data and information 2 Databases on computer 2 Relational Databases 3 How a database will aid this system 3 Task 2 4 Explanation of the entities and attributes 4 Logical data models 7 Entity Relationship-diagram 9 Task 3 11 Explanation of normalisation 11 Task 4 12 User Documentation 12 Deleting a record 16 Adding a record 17 Amending a record 17 How to use a form 18 Technical documentation 18 Entering data into the database 18 Creating the forms 19 Creating the reports 20 Creatingc a macro 21 Creating the main menu 22 Data Dictionary 24 Output from queries and reports 27 Database Structure 27 Acceptable data 28 Task 5 30 Testing of the Database 31 Time Management 37 Task 1 Introduction In this unit I have chosen to do my database on a herd book. The reason that I chose a herd book is because I have a lot of interest in cattle and in the farm that I work on my father's farm. I think that from the paper work end of farming it would be much better if a small computerised system was introduced it would save me and my father a lot of time. I was talking to my father about making a database system and explained to him what a database system is and how a database would save him a lot of time and a lot less usage of paper work and he would benefit from using a database system. Explanation of databases and why they would be of use to this system What is a database? A database is a collection of data of related data held in an organised way. A database is used to store large amounts of data so that the user can obtain the information needed when required and in an easy to understand form. ...read more.


Task 4 User Documentation Step one In order to load up the spreadsheet you have to click on the Microsoft access icon on the desktop when this has been done then you will have the following appear; You enter blank database by clicking on the and then clicking on the OK button. Step two Once you have opened the database then you have to decide where you are going to save it. In order to save it you have to click on the and then you will be able to save it to where ever you want. You enter the name - I have chosen database then click on the create button Step three The screen below will now emerge. As you can see the name of the database is show "database". It is important to know that when you are creating the database that when you are in Microsoft Access that you first click . After you have clicked new then the "New Table" window will appear: It is very important that you click design view, as this will take you into your design view; Deleting a record When deleting a record you have to click on the delete button shown below After you have clicked on this button then the following message will appear Adding a record When you are going to add a record all you have to do is to click on the add button as shown below; Amending a record Amending a record is simple. As you can see the highlighted field has got the name factory in it, this is correct so all you have to do to click on the arrow for the combo box, and on the destination that the animal went to but if you typed in a destination that is not in the combo box it wont be entered. How to use a form When using this form there is ver y little to do as there is so many drop down selection boxes to use. ...read more.


Testing number 4 For this test I tried to type in �9,999 but it wouldn't let me continue because I know that I wouldn't get that amount of money so I have to enter a number above or equal to zero and below two thousand. Testing number 5 I clicked on the arrow and the combo box appeared and the rest of the combo boxes work the same as this one. Testing number 6 As you can see beside ear tag the control tip text is working. Testing number 7 Witnessed by Testing number 8 In this test I tried not to enter anything into any of the fields but a message came up not letting me to continue Time Management Date Deadline Action Criteria met Problems Resources Used Date completed ___/___/01 13th February Task 1 Introduction Explanation of databases and why they would be of use to this system yes none ___/___/01 ___/___/01 20th February Task 2 Explain the entities and attributes Explain the reports and queries that are generated from a database E2 E3 yes none ___/___/01 ___/___/01 27th February Task 3 Explain normalisation Normalise all the data to 3NF Showing your graphical images to help to design it E1 A1 yes none ___/___/01 ___/___/01 6th March Task 5 Create a working database that allows users to append, delete, edit data and initiate queries and print reports Test the system to check for effective validation procedures in place and check the reliability of the data within the range. E3 A2 A3 yes none ___/___/01 ___/___/01 13th March Task 4 Create a user friendly database so as novice users can use it E5 A4 E7 C2yes none ___/___/01 ___/___/01 20th March Task 6 Show clear definitions of the following; A database structure and data relationships A data dictionary The range of acceptable data Example output from queries and reports E6 ___/___/01 Advanced VCE ICT Name: Declan Small Centre no: 71655 Candidate no:: Page no 37 Advanced VCE ICT Name: Centre no: 71655 Candidate no: 48 ...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. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    for a document it is very hard and time consuming to find it. The manager George Mulalay is responsible for the safety and security of the documents. The documents are stored in folders on the computer and paper documents are stored in cupboards and cabinets in labelled files.

  2. OCR Nationals Unit 21 - Task 8

    I done this by right clicking on the background I had made and then clicking on Timeline Effects before clicking on Effects and then on Blur as shown in the screenshot. After doing that, the effect was added to the background, and I pressed Ctrl and Enter on the Keyboard to preview and check whether it was alright.

  1. a level ict project

    Accepted and saved T8 12/03/07 (erroneous) Validation text appears T9 Test that all dates are in the year 2007 12 May 2007 (typical) Accepted and saved T10 1 January 2007 (extreme) Validation box appears to check entry T11 2 June 2004 (erroneous)

  2. Access Database

    7. Out of a rating of 5 being the highest, what do you rate this database? Test Plan OBJECTIVES TEST * Must have more than one table (entity) to create relationships I will check that the relationships work because if they work that means I have more than one table *

  1. The impact of ICT on a person with special/particular needs

    The spell check feature saves a lot of time for Sarah as she doesn't need to go back and spend time fixing her mistakes. Microsoft Word also allows Sarah to customise her font style, size and colour allowing her to take full control over her work.

  2. Smarts Leisure Park Database Booking System

    I did it by selecting it all and moving it to the desired position. This also makes the form more readable for the user. I must now add a heading. I will also add the logo of SLP. Now I have done all of the layout and colouring of the form, I must now add some buttons.

  1. Database design.

    I think a table will give the advantages and disadvantages: Advantages Disadvantages Organised. If the employee is not computer familiar they will need trained. Easy to search for a record. Expensive to get installed. When printing it, it will be professional looking.

  2. Computer study project outline - library and book club database.

    Using an automated computerized program to keep and maintain the record of the books has various advantages if you compare it to a manual database. What can a normal library database do? 1. It maintains all the books and reduces human errors.

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