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

Database CW

Extracts from this document...

Introduction

GCSE ICT Coursework: The Creation and Manipulation of Databases Contents Page: Identification....................................................................................3 The Problem.....................................................................................3 Alternative solutions...........................................................................3 Why ICT is a sensible way of solving the problem........................................4 Quantitative Objectives........................................................................4 Analysis.......................................................................................... 5 Input ..............................................................................................5 Process.............................................................................................5 Output.............................................................................................5 Backup............................................................................................ 6 Security........................................................................................... 6 Software...........................................................................................7 Hardware..........................................................................................7 Flow Chart....................................................................................... 7 Design. ............................................................................................9 Subtasks..........................................................................................9 Student Details Form............................................................................12 Teacher Details Form...........................................................................13 Student Details Report.........................................................................14 Teacher Details Report.........................................................................15 Relationship Diagram ..........................................................................16 User Comments.................................................................................17 Test Plan..........................................................................................18 Implementation..................................................................................19 Evidence of Error Correction..................................................................19 Test Plan .........................................................................................23 Evidence of Problem Solution................................................................26 Evaluation........................................................................................29 User Comments.................................................................................30 Identification Mr. Amir Khan has begun his own weekend tuition along with his partner Mrs. Cassie Williams. The tuition is called Amir's Saturday Tuition and is for GCSE students between the ages of 14-16 of all abilities who wish to learn Mathematics, Sciences, English Literature and English Language. The tuition will run between 11am to 6pm on Saturdays. Approximately 60 students have currently enrolled and they will begin from September 2007. There are approximately 10 teachers who will teach the above stated subjects to small groups of 6 to students of different levels. Classes will be conducted in different rooms belonging to the teacher. The Problem There is no current registering system or database to file the student's details. In an emergency, student's details need to be found immediately. Mrs. Cassie Williams is very firm about students keeping a good attendance. Therefore, it is her wish that a register be included in the database. Details of all students have been requested and these details need to be put into the database. The details include their full name, date of birth, address, telephone number, mobile number and emergency contact information. Two registers need to be created for both the Mathematics teacher, Mr. Juelz Santana and the Science teacher, Mr. Chris Brown. Mr. Amir Khan has asked me to assist him in creating these two databases. He wishes for the database to include: * The student's full name, address, date of birth, telephone number and emergency contact information to be present in the database * An attendance record for all students for every week in each term. ...read more.

Middle

3. The Multi Router Traffic Grapher This software monitors the traffic load on network links Hardware To create and use the database, the following hardware will be required: 1. 3 Packard Bell Istart 1360 desktop PC - AMD Athlon 64 3200+ processor (with Microsoft Windows XP Home Edition, 512MB DDR RAM, 80GB hard disk drive) 2. 3 17" Sony Flat Panel Monitor 3. 3 keyboards 4. 3 mice 5. Inkjet printer 6. Hub 7. Cables A large memory of the computer is needed to save the database. Three computers will be needed for both teachers and receptionist or network manager and will be networked together. To network the computers, a hub and cables are needed. Since all the computers will be networked, only one printer is needed. This printer should be an inkjet one because it produces decent quality printouts at a reasonable price. Flow Chart No Yes Yes No Design Subtasks Below is a list of subtasks together with the estimated duration and start dates. Tasks Start Date Duration Interview manager and real users, the teachers 1/12/2006 1day Create forms for students to fill in with their details 2/12/2006 2 days Disperse forms to those enrolled 4/12/2006 1 day Design reports and forms 5/12/2006 5 days Create logo 10/12/2006 1 day Discuss designs with manager 11/12/2006 1 day Using user's feedback, change the design as asked 12/12/2006 3 days Collect forms from students 15/12/2006 1 day Create database 16/12/2006 10 days Discuss the database creation with manager 26/12/2006 1 day Using user's feedback, change the database as asked 27/12/2006 2 days Show the final version of database and discuss any areas that could be improved with manager and real user 29/12/2006 1 day The database should have 3 tables. One table should store the student's details. The other, the teacher's details and the last should act as an attendance record. This is the design for the Student Details table. ...read more.

Conclusion

Below is a screenshot of the Student Details form including this 'Exit Form' control button. Evaluation The objectives set for this task were: 1. To create a database, which stores student's details 2. To create a database, which also acts as an attendance record. 3. To make the database password protected 4. To enable the user to create reports 5. To enable the user to create forms 6. To enable the user to create queries 7. To link tables so that if changes are made in one table, the changes are clear in the other too. 8. To make the system easy to read and clear 9. To save the database on the appropriate backing storage. 10. To include the tuition logo in the system 11. Searching on the system should be easy 12. To make the forms include buttons linking from one record to another. I was able to achieve the first two objectives which were to create the database to store student details and act as an attendance record or register. The database was password protected, as shown above. The user could easily make reports, forms and run queries. I have also made and given examples of each. I had linked tables by making relationships so that when a change was made on one table, the change would be apparent on the other too. This was shown above. The system was easy to read and clear, in my opinion. The database was saved on the user's email account, USB device, CD-RW and internal memory too. Computers in the tuition centre are all connected via a hub and router. This way if one computer fails, the other computers and other external memory still hold the database system. The tuition logo was put on the forms and reports presentably. Searching can be easy through running queries. Lastly, the forms did include buttons so that the records linked to one another. User Comments: I then created a control button which would link the forms to queries. Evidence of this is shown below. GCSE ICT | Database Coursework - 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. Different types of technology How I use ICT at home and at school

    The thing that sticks out is the censoring system. This censoring system literally censors almost anything. Sites pertaining even to the slightest degree to pornography, piracy, games, chat rooms, forums, criminal actions, proxies and loads of others. With how strict it is, this practically limits every useful site, even those useful in studying.

  2. Standalone vs networked computers

    Standards and procedures are important because without them one device in your network could be sending data to another device in a form that the other device may not be able to interpret. In order for a network to run properly it must adopt certain procedures.

  1. ICT Report 2b: ICT in Organisations

    Through computers, you place the CD, label side up on a disc tray that then rewinds into the computer where it is read by a CD Drive. Boots also use CD ROMs in the R&D department as storage devices, however once data is burned onto a CD, it can not

  2. ICT Coursework (MarcoS)

    between the loss and the incoming is displayed 103 Formula in the cell F62 in the Profit & Loss sheet The tot. balance of January is displayed 104 Formula in the cell F63 in the Profit & Loss sheet The tot.

  1. Database design.

    No Video_Category The Category Thriller,horrer,Romantic Text 20 Yes Video_Cert The certificate U,12A,PG,15,18 Text 20 Yes Video_Rental_Price The Price to rent out per night Currency �00.00 No Video_Date_Out The date rented Date __/__/__ No Video_Date_Returned The date returned Date __/__/__ No Video_Copies The number of copies.

  2. Ict Powerpoint Coursework

    Food franchises. Using these methods there would be more awareness of the PowerPoint Presentation and this would be one of the purposes to overcome Mr. Akram's problem. DESIGN Output The questionnaire shown below is based upon the contents of the PowerPoint Presentation and is a typical primary research field on

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

    With a stamp for my letterhead, it will make the work very easy and save a lot of time. When designing a letter template the company would have to pay for the papers that are needed to design it. Especially when mistakes occur.

  2. Design-ICT Modelling CW

    * Drinks (Bar)- This will display details of all the different the drink the bar sells and how much they will cost. Graphs and charts: The new system will be used to display the results of the calculations it makes in an easy-to-read format.

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