• 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
  50. 50
  51. 51
  52. 52
  53. 53
  54. 54
  55. 55
  56. 56
  57. 57
  58. 58
  59. 59
  • Level: GCSE
  • Subject: ICT
  • Word count: 4593

GCSE Book DataBase Project

Extracts from this document...


Database Project Identify 4 Identify 4 Introduction 4 The Problems 5 The Current Situation 5 The problems with manual solutions 5 Alternative Solution 5 Why I chose ICT 7 Quantitative objectives 8 Software 9 Alternative Software Solutions 9 Hardware 10 Alternative hardware 11 Security 11 Backup Strategy 12 Data flow Diagrams 13 Data requirements for the ICT books loan database 16 Data requirements for the ICT books loan database 17 Student info table 17 Design Tasks 24 User Comments 28 Final Designs 29 QueriesCreating Tables 29 QueriesCreating Tables 30 Creating Tables 31 Validation of Data 32 Range Check 32 Range Check 33 Creating Queries 37 Testing 38 T4. 41 T4. 42 All Reports 45 All Reports 46 Simple Query searching for specific student 46 Simple Query searching for specific student 47 Simple Query searching for specific student 48 Implementation 50 Implementation 51 Implementation 52 Creating Tables 52 Errors 53 3. 3. Errors with fields on forms 53 3. 3. Errors with fields on forms 54 Test Plan 54 Test Plan 55 Quantitative objectives evaluation 57 User Response and possible improvements 58 Identify Introduction Langley Park School for Boys (also known as Langley Park Boys' School) is a boys' comprehensive secondary school in Beckenham in the London Borough of Bromley, with a mixed-sex sixth form. The school currently has about 1450 pupils. The headmaster is R W Northcott. The school's motto is Mores et studia which literally translates as 'morals and study'. The school's code of conduct is courtesy; common-sense & co-operation. The school uniform consists of a maroon blazer and tie, both with the school crest on, and dark trousers. Students are allowed to wear suits or, if female, smart clothes, in the sixth form. The Problems The library department has requested an ICT system to keep track of the textbooks that are loaned out to the 6th formers. The librarian needs a more reliable way of record books, which are out on loan and on the shelf. ...read more.


Another strategy I will be using is to send my work to my own email address through email. This would mean that even if I were to forget to bring my memory stick, I can access my work anyway because most computers now days have Internet access. There are many risks of not backing up your work, for example, the school might catch fire, the system might go down, and there might be a virus on the school system, floods. If you do not back up your work you will regret it because you will have to do all your work again, this might take time. To save everything that has been done on floppy disks, CD ROMs, USB pens, USB memory sticks. Data flow Diagrams Data requirements for the ICT books loan database Student info table Field name Data base Primary Key? Field Length Validation rule? Validation method Field description Student _ ID Auto number Yes Long Integer Must be unique Automatic A 'unique identifier' given to each student. Students first name Text No 20 None The first name of student Student last name Text No 20 None The surname of student. Form ID Text No 3 None This field relates to the student record to the "form" table. Loan ID Number No Long Integer None This field relates to the student record to the "loan" table. Staff Info Staff field Name Data Type Field Length Primary Key Validation Validation method Field description Staff initials Text 5 Yes Must be unique Unique check on primary key. This shows the initials of the staff member. Staff name Text No 30 ---------------- ---------------- This shows the name of the staff member. Form Info Staff field Name Data Type Field Length Primary Key Validation Validation method Field description Form ID Auto number Long Integer Yes Unique field Primary key This gives each record a unique identifier. ...read more.


This means that I have completed this objective. Evaluation of Objective 5 From my testing I have shown that the access of commonly used forms are readily available for the use convenient use of the librarian. Evaluation of Objective 6 The user interface of the database is very user friendly , this has been proved when I was told from the user feedback that the interface was easy to read and understand. User Response and possible improvements Subsequent to giving the questionnaire to some of the users I had a response. The majority of the users agreed to saying they thought that the interface was very straight forward to use and found that when searching for a particular search, it was very quick. All but one user thought that the database was easy to navigate between as I have made a menu linking all the appropriate forms together saving time and effort. In my testing I had checked whether all the buttons had worked correctly and navigated you to the correct form or reports. This was proved by the users as they had no problems with the links in between the forms and reports. The report format was as they expected because they have used databases which were very similar but several of the users had said they liked the picture feature in the reports so that they know which book has been loaned out. They didn't think that it needs any changes as it has more than the average database of this kind. All the relevant information that the users needed was there and they didn't have any problem retrieving it. Even though the users did think the database was good they suggested to me that they thought that I should expand the database so that it would allow them to use this database for other subjects. This would be very easy to do as all I have to do is add the system is the staffs that teach the subject, the sets and the books. ?? ?? ?? ?? Mitesh Patel GCSE Database Candidate no.XXXX 1 ...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

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    Allows you to get money out when you most need it, meaning you don't have to carry large amounts of money wherever you go and put yourself at risk * Printable receipts so you can have proof of withdrawal or deposit in-case a problem occurs * Need of pin number


    My system will help management make effective decisions because: * If they know how many customers come, they may need to buy more karts more instructors. * They may need to do some promotion or discount to attract more people come to play Data to be captured are: * All

  1. GCSE Excel Project ICT

    Table Relationships can be created to link data value together, once linked this information can be access from any of the tables. Queries enable to user to search for information or a data value with greater ease, however the initial file sizes can be large, when more information and data is inserted it makes it easier to use the information.

  2. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    After you have done this you select the row beneath it where it says validation text and then you enter the following (Please enter only Male or Female). Creating Queries First you select Microsoft Access then you open it.

  1. Hardware & Software Requirements for Database

    Both applications can store data on the disk. An example of an external hard disk in everyday life is a USB mass storage device which is reliable as the data inside the disk cannot get lost unless the drive is damaged.

  2. a level ict project

    The employees are becoming so annoyed by this they are more likely to not fill out the information sheet to avoid dealing without the archives. As a result if a customer or legal representative wanted to see a specific transaction, Victor would face a discomfiting situation because they would be unable to do so.

  1. Access Database

    Input masks, is an example of validation. Questionnaire 1. What do you think I could improve in my hand drawn plans? 2. What do you think is good in my hand drawn plans? 3. Do you think my database looks user-friendly, if not why?

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

    (If it?s not in the library they can see where they can buy it and if it is, is it available?) 4. So that students gets encourage reading more. 5. So that they can find people with similar book interest.

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