• 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
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  • Level: GCSE
  • Subject: ICT
  • Word count: 4593

GCSE Book DataBase Project

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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

  2. ICT PROJECT PROPOSAL

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

    For me, who goes on MSN a lot, this entertainment is quite useful as it provides a platform other than conversation to interact my friends with. It also provides a little fun and competitive nature with my friends. The ability to share files is also extremely useful.

  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. Explain the difference between primary and secondary sources of data, with examples.

    (Tick as many as needed) Detached Semi-detached Terrace Bungalow Flat Apartment Other Category: Where the respondent can only choose one of the set listed answers. E.g. How long have you lived in your current house for? Under 1 year 1-5 years 6-10 years 11-20 years 21-30 years 31 years or

  2. ICT PROJECT

    * 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. GCSE Calculator Project

    Decimal Place Allow for decimal place to used in a number eg, 35.6 and then allowing the calculation to continue Hide/Show Buttons Hide - remove memory key pad Show - replace memory key pad It should work Help Option Hovering of mouse should bring up a comment or show help message in a text box.

  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