• 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

    thus preventing us from procrastinating in school as we'd usually not have space to download games and such with all our work in here. People are discouraged to put unknown files into their computer account and are warned of this explicitly.

  2. ICT Report 2b: ICT in Organisations

    exchange, it is helpful for workers as credit card transactions happen at a quicker pace, and it is helpful for the suppliers because allows for better communication between business and supplier. Finally it helps the customer because they can have a fast and enjoyable shopping experience at Boots.

  1. Database design.

    I could get my customers in order of their surnames by alphabetical order or the video ID in numeric order. In order to create a query you go to new and then highlight the simple query wizard and click ok.

  2. Ict Powerpoint Coursework

    This is the page which would lead the user to when the home button is clicked on any slide. Slide 3: This is the slide that contains the burgers that S.A. Foods have to offer, there are several pictures of burgers that S.A.

  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.

  1. Database Coursework

    Rental related objectives * The user ought to be able to record details of a customer buying or renting DVDs in less than 30 seconds, as a receipt. * The user should be able to remove details of a purchase or loan if the customer wants to change the DVD,

  2. ICT notes

    Provide health and safety training and information to all staff. There are various health problems associated with the regular use of computers. Here are some of the most common problems and what can be done to reduce the risks: Health Problem Cause Solution Repetitive Strain Injury (RSI)

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