• 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

    Then arrange a checklist, so I can see exactly what I need to test. Checklist * To be able to model various scenarios in order to work out break even point * To be able to let pupils know the final price of an individual ticket as soon as possible,


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

    I used this query for my merged letter. When you go to the design view it will look like this, it shows the tables the fields came from. I have typed something in the criteria space which is [Enter customer ID No] this means the query is a parameter where you have to type in the customers ID number.

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

    On the loans form in the managers menu we are able to see which DVDs has not been return and how much the surcharge is. On the member form (manager's menu), we can see all the details of the customer and their personal information.

  2. Computer project Alevels

    * A screen shown below will appear asking you what you want to do with the CD. * Click on "Open folder to view files using Windows Explorer" which is highlighted in the above diagram. * Under the drive, the CD is in, you will see a folder named "MediCare Hospital System".

  1. Ict Powerpoint Coursework

    Updating Product Information Mr Akram's food chain (S.A. Foods) regularly updates there range of products for their customers. Therefore to keep up to date the PowerPoint Presentation has to be regularly updated to keep up with the innovative products from time to time.

  2. Producing a database and standard letters - difference between computerised and manual systems

    Also other disadvantages this is that if you phone the company up then it will add on your bill hence you will be paying to get your information. Furthermore you go could get more information than you need e.g. when you surf the net looking for their information their information

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