• 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

    numerous other terms), is an item of personal computer hardware whose function is to generate and output images to a display.

  2. Financial Model to help organise the year eleven prom

    so they can then begin to save for things such as limousines. * A system that when research is done allows mechanical calculations to be Done in a couple of minutes. * A system that can be re-used for next years pupils.


    percentages, on sheet 8 Sheet 7-Pivot Table B The second pivot table will be used to summarise the outcome of student performance. This sheet will therefore help the user to write letter home, individual report for parent evening etc. This will linked to the archive in the marking archive sheet.

  2. GCSE Excel Project ICT

    D4 Pass Drop Down Boxes Expected Result Predicted Result Actual Result None Present Medusa Present XP Home Edition SP3 Present Vista Ultimate Present Vista Premium Present Vista Basic Present Mackintosh Present IF Formula Expected Result Predicted Result Actual Result IF: None Produce: None Present IF: Medusa WarlordTF Present IF:XP Home

  1. Database design.

    ID number Number 6 Foreign No Rent_Video_ID Video ID Number Number 4 Foreign >9999< No Rent_date_out Date Of Video Rented out Date __/__/__ No Rent_date_returned Date of video returned Date __/__/__ No Output from queries and reports The output from the queries allowed me to create a letter.

  2. Database Analysis and Database Design Project - DVD library for moving images.

    As we can see below I have use a validation rule so not other data can be enter onto the system . RATING TABLE * RATING On this table I also have only one field, which is rating , being the only one and like in all the other tables

  1. Computer project Alevels

    Easy to use and handle. 4. Integration between softwares is easier. 5. Transferring, editing, moving or amending data is easier. 6. It stores large number of data and even in a large company they store lots of data and these can be used in other network databases * MS Access is the most demanding and conceptually challenging software.

  2. Ict Powerpoint Coursework

    The PowerPoint Presentation would be easy and simple to show to everyone as it is mainly used for advertising purposes. Also they're will be administrator accounts to help answer user questions, update the PowerPoint Presentation etc... Information of the products would be placed on the information slide on the presentation.

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