• 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. Different types of technology How I use ICT at home and at school

    For someone like me who likes to keep his brain in shape, I like to regularly use the brain training app and being the arrogant, boastful person I am, it gives me the chance to show off my capabilities and strengths to other people.

  1. 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.

  2. a level ict project

    a tedious and time consuming process, therefore it's more likely for mistakes to take place. Consequently, the test data will be the same as the previous data but with some changes. To test the system, I will be using a wide variety of data, so that as many errors can

  1. Access Database

    What do you think of the layout of my hand drawn plans? 5. Is the colour combination used good, is the style of the page good? 6. Overall, what do you think of the hand drawn plans, should I redo do them, or keep it as it is? 7.

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

    She can make contact with new friends and faces but also reunite with people she hasn't spoken to in a while. This pleases her as it makes her feel like a normal person. But an even bigger encouragement to Sarah is finding people who have the same troubles as she does.

  1. Smarts Leisure Park Database Booking System

    the corner and click properties: In then turned all dividing lines, scroll bars, and navigation bars off: After I had turned all of these off the form view then looked like this: After I had done this I must now design the layout of the form in general, in keeping with the designs that I have drawn.

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

    to know all the books in their library and their location in the library. 7. ALLOWING AUTHORIZED ACCESS (PROTECTION OF DATA) - Only librarians are allowed to come and delete or modify the records of books. EXISTING SOLUTION TO THE PROBLEM- As of today, our library has a library database but it is only used by the librarians.

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