• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 2743

Create a database solution for a college tutor.

Extracts from this document...


b Analysis Introduction Mr. Asif Altaf is a form tutor in NewVic College, which is located in Plaistow. He is also a Business studies teacher. Both her lesson students and the students in her tutor group are first year students. He uses a manual system to store the information about the students. He writes everything down in pen and paper. This system has many limits and constraints. Mr. Altaf now wants to upgrade to manual system to a computerised system. He is doing this so that he can store all the information in a computer database and it is easier for him to access and modify the information. He wants the computerised system for other reasons as well. A computerised system has many advantages. He can send electronic mails to parents and subject teachers, take the register, and decrease inaccuracy and time consuming to the minimum. History My user is Asif Altaf, tutor in NewVic College. He has been a teacher for a long time, and used manual database systems (pen and paper) to store details of his students and his subjects. He has now decided to keep up with the times, and upgrade to a system which is more flexible, easier to use and upgradeable. He wants a computerised database system. Location The end user is situated in NewVic College. The college is not in my neighbourhood, but I can easily interact with the user everyday and use the facilities as I study in the college and I go there every weekdays. User Skills My user is a tutor of a college. ...read more.


Text document system - This way, it will be simple for Mr Altaf to store the information without any complications, but it cannot display any reports, queries etc. Final Choice of solution: For implementing the system a database package will be ideal for Asif Altaf. It will be done in Access XP, as it has the most features. I already have some experience of using Microsoft access XP and it is possible for college and me to develop on my skills, as it is both at home. By using this package it will be possible to: Set up tables and relationships Produce customised input screens. Designing Reports Implement a customised menu system Link with MS word to perform mail merges to parents. Make and save queries to selected certain customers for mail merge Use visual basic to modules to enable fast searches for a particular customer. Database Design My database will contain the following entities and attributes: Definition of data requirements The tables will contain the following data: Student Details Attribute Type Subject Details Attribute Name Type Report Attribute Name Type Systems Flowchart Design of Input Forms This input forms will be necessary, because it will help add new student information, and also add subjects for the student. It can be used to look through all the existing details of the students, and modify to upgrade it. If a student is already in the database, mistakes while modifying the database will be noticed by the validation checks, and corrected. To make it easier for the user, the Student ID data type will be an auto number integer, so that there is continuity at work. ...read more.


Out of the chapters, Analysis and Design were the two chapters, that I am fully satisfied with. I believe, that with more time, I could have put more information in the implementation and user manual. The last two chapters are proper and correct, but not as elaborate as I planned them to be. My best part in the project is my analysis chapter, because I have done it with lots of time and care, and I am happy with the way it turned out. My worst part in the project is probably my user manual, because I did this at the end, when the time was running out. There were a few things, that did not turn out as good as my expectations. I planned to add a few screenshots to my user manual. I wanted a dropdown list in my forms, but unfortunately, I did not know how to do it. I am also unhappy, that I could not turn in this project before the deadline, since I was struggling because of my lack of implementation knowledge. Still, I am proud of the work I produced under these circumstances. I am also quite proud, than I chose to do quite an original project of sorting information, while most of my fellow classmates are doing business solutions. If I had to do the project again, I would change a few parts of it. I would plan the whole project more thoroughly, and I would put away more time for me to finish the project, so that I could turn it in the deadline. Overall, I am happy that I have produced this work. 15) Rebecca2k2@hotmail.com ...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

    This contrasts with storage mechanisms such as tapes, magnetic discs and optical discs, which rely on the physical movement of the recording medium or a reading head. In these devices, the movement takes longer than the data transfer, and the retrieval time varies depending on the physical location of the next item.

  2. a level ict project

    * The window mode shall be set as Normal Macro design to open the form of Garage Job: * Macro Action is to be OpenForm * The form name to select is Garage Job * The view should be set as Form * The window mode shall be set as

  1. Access Database

    so I can search for data and they worked the first time I tried. I achieved the objective. * Create Reports to show the output from your queries I created reports to show the output and it can be very helpful to the customer or librarian.

  2. Smarts Leisure Park Database Booking System

    In some of my tables I have used lookup fields to get information from other tables. Below are screenshots showing my tables. Table 1 - Customer Details The first table that I am going to create is the Customer Details Table.

  1. System requirements analysis

    Howard health centre will need the name of the patient, address, date of birth, illness, doctor, location, etc. Below are a few examples of a hospital booking software: This is how the patients file in the hospital looks like and it contains a picture of the patients face as well

  2. Data analysis report - Factors influencing pocket expenses of college students

    DESCRIPTIVE ANALYSIS Statistics is a subject, which can be (and is) applied to every aspect of our lives. The aim of statistical methods is simple: to present information in a clear, concise and accurate manner. The difficulty in analysing many phenomena, be they economic, social or otherwise, is that there is simply too much information for the mind to assimilate.

  1. Financial Model to help organise the year eleven prom

    This would also be an advantage because pupils in years to follow could use the same system. The only disadvantage would be that you would need someone who could work the programs, although most pupils have had ICT lessons and would know straight away how to use it.

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

    Laptops are portable, which makes it easier to work at home as well as school or anywhere. 2. Processor: The processor of my laptop is Intel Core(TM)2 Duo. 3. Keyboard: The keyboard I am using is the one that is built into the laptop.

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