• 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)

    do something elongated such as going to a bank to withdraw a simple amount of money. If you forget some money you need, you can simply go to one of the easily accessible ATMs which are located in a wide area.

  2. Hardware & Software Requirements for Database

    RAM is a very good way of spacing out data. The more RAM the better, the faster and more effectively my database will work for Whipps Cross Hospital which will be beneficial to Whipps cross hospital as if they have more RAM that means that more then one programme can be open at once.


    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

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

    I made a letterhead. There should have been pictures inside it to show it more easily I am testing to make a template letter. To create a template letter first you then you type in everything and put dots in the personal information e.g.

  1. Different types of technology How I use ICT at home and at school

    For someone like me who is just a big fan of helping others, it becomes extremely useful for me. I can help out people who can't follow the instructions I gave them. This feature allows me to go out of my own way and in my own generosity and kindness


    * As the tests always have different maximum marks e.g. 13,15, she found it difficult to convert number into percentage. * The mark book can get lost. Interviewed Questions 1. What is your position at this school? -------------------------------------------------------------- -------------------------------------------------------------- 2.

  1. ICT Report 2b: ICT in Organisations

    exchange of data with many other devices, such as MP3 players, mobile phones, video game consoles and so forth. A USB is highly advantageous to Boots because it provides a quick and easy way of data exchange between computers and this is highly effective in the R&D department where computers are continually running.

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

    So that librarian can create a record of all their books on a computer so that it is free and easy for anyone to look into. Let us first see what exactly will this database will do- 1. KEEPING a RECORD OF ALL THE BOOKS- every library in the

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