• 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
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  47. 47
  48. 48
  49. 49
  50. 50
  51. 51
  52. 52
  53. 53
  54. 54
  55. 55
  56. 56
  57. 57
  58. 58
  59. 59
  60. 60
  61. 61

Computing Project

Extracts from this document...


Table of Contents Analysis Background to/Identification of the Problem 1 Identification of the prospective user 2 Justification of the chosen Solution 2 Questionnaire 2 Identification of the user needs and Acceptable Limitations 3 Realistic Appraisal of the feasibility if potential solutions 3 Entity Relationship Diagram 3 Data Sources and destinations 4/5 Summary of existing system 6 Problems with existing system 6 Objectives of the project 6 General Objectives 6 Specific objectives 6 Data Flow Diagram of current system 7 Data Flow diagram of proposed system 8 Design Overall System 9 User Interface Design 10 Database Design Including ER Model 11 Record Structure 11/12 Validation 13 Storage Media and Format 13/14 Identification of suitable algorithms for data transformation 14 Planned Valid Output 15 Description of Measures Planned for security and integrity of Data 15 Description of Measures Planned for System Security 15 Test Strategy 16 Implementation Main Menu Screen Prints 17 Availability Details Main Menu 18 Make A Booking Screen Print 19 Next Lesson Booked Screen print 20 Availabilities Screen Print 21 Student details Screen Print 22 Testing Design of test plan 23 Annotated hard copy of test plan 25 Minimal set of test data 32 System Maintenance System Overview 33 Procedure and variable developed 33 Creations and customisation of the database 34 Tables 34 Relationships 37 User Manual 38 Appraisals 47 User Feedback 49 BACKGROUND TO/ IDENTIFICATION OF PROBLEM The present system is very inefficient, when a student wishes to book a lesson the instructor has to get out his diary check the dates that are available and book in the student. After the lesson the instructor has to update his student book, he has to write in what the student did in the lesson, how they found it, whether they paid or not. Occasionally the instructor will add up how many lessons that the student has had and jot this down. This is a waste of time, as the instructor cannot book a student until he has finished all the paper work, this usually takes about 15 minutes after each lesson. ...read more.


Price per lesson Number, Decimal 5,2 How much the student pays for each lesson Date and time of next lesson Date time Date time The next lesson student has booked. VALIDATION I will use validation on some of the fields on the tables so there is less chance of wrong data being inputted. There are only some fields that can have validation but by ensuring they have a working validation it will mean that the system will not be wrong. Things that I can validate are numbers or specific number of characters. This is to make sure that the data entered conforms to a certain standard. The user cannot see the validation rules, so when they make a mistake they find out as an error message appears. VALIDATION Field Name Validation Type Validation Rule Error message Student Number Type Check 8 digits The student number must be 8 digits Lesson Code Type check 5 Digits The lesson code must be 5 digits. STORAGE AND MEDIA FORMAT For my system I need to know how large each file will be so I have calculated the size of each field, and multiplied that but the amount of fields ii may get, to get an estimate of how large the file could get. Storage and media format Field name Number of records Size of record/ bytes Total size of records/bytes Student name 30 32 960 Student number 30 8 240 Student address 30 65 1950 Lesson code 30 5 150 Price per lesson 30 8 240 Date and time of next lesson 30 16 480 Available lessons 31 20 620 Next lessons booked 6 134 804 Total 5444b 5.4kb I have calculated that the approximate maximum size that I will need for the data to be stored will be around 6kb, which is small enough to fit on almost any data storage type. The most suitable storage device for this will be the hard disk drive on the laptop to be used. ...read more.


But in reality on that day an on that time he is busy. This is one of the things the instructor is complaining about and also another thing that has been drawn to my attention is that he misreads the time, so he tells the student that he is booked at 13:00 tomorrow but he is actually free he has a lesson at 3:00 not 13:00 so this is one way the instructor is losing out on money. I wish to remove this issue and avoid these mistakes happening. Security, the system now has some good security, it only allows the instructor to long in and once the password is entered then the instructor can access the system. This is in line will all data protection acts and just general security. User feedback I asked Ian, the future user of this system, to navigate his way through the system and in turn add, edit, search output data using user manual as a guide. Here is what he found DID YOU FIND IT EASY TO FIND THE STUDENT TELEPHONE NUMBER? HOW DIFICULT WAS IT TO MAKE A BOOKING? WHAT DID YOU FIND DIFFICULT? WHAT WAS THE BEST THING ON THE SYSTEM? WHAT WOULD YOU CHANGE WITH THE SYSTEM? IS THIS AN IMPROVEMENT FROM THE EXISTING SYSTEM SIGNATURE: ?? ?? ?? ?? This document was downloaded from Coursework.Info - The UK's Coursework Database - http://www.coursework.info/ This document was downloaded from Coursework.Info - The UK's Coursework Database - http://www.coursework.info/ <GCE A2 Computing <CPT 6 <Ram Bhojani This document was downloaded from Coursework.Info - The UK's Coursework Database - http://www.coursework.info/ <Instructor Booking> |<Ram Bhojani 13HAN> This document was downloaded from Coursework.Info - The UK's Coursework Database - http://www.coursework.info/ This document was downloaded from Coursework.Info - The UK's Coursework Database - http://www.coursework.info/ This document was downloaded from Coursework.Info - The UK's Coursework Database - http://www.coursework.info/ GCE A2 Computing CPT 6 Ram Bhojani Instructor Bookings | Ram Bhojani 13HAN ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Visual basic

    * Invoked by a call. * When the Sub is invoked, it's body is executed sequentially until an End Sub or Exit Sub statement is reached. Functions * Very Similar to Sub Programs. * Created by using either the Add Procedure dialog box or by typing the directly into the code window.

  2. 140 Computing A-Level Revision Questions

    What is a key field? 30. Give an advantage and a disadvantage of fixed length over variable length fields. 31. Explain LAN and WAN with an example of where each might be used. 32. Explain the difference between compilers and interpreters.

  1. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    * Organizational Assignment infotype (0001) * Personal Data infotype (0002) * Payroll status infotype (0003) * Addresses infotype (0006) * Planned working time infotype (0007) * Basic pay infotype (0008) in which you can specify the wage types related to monthly earnings.

  2. Computing Project

    and be able to print the list out * The system must allow the user to see which DVD's have been rented out and which haven't * The system must be able to work out how much money the rental shop has made.

  1. The impact of the availability of electric information on individuals and society

    Some people in democratic countries, such as Great Britain don't have an access to the internet because of many number of reasons. A survey made in 2008 shows that most families don't have it because they just don't need it and don't feel demand of it; others said that it

  2. Primary or Secondary Storage.

    The concept is not particularly useful for floppies. Compact Disks CD-ROM (Compact Disk Read Only Memory) is a form of CD used for the storage of computer data. Data is read from the disk using a low-power laser to detect the patterns in the surface of the disk.

  1. What is transaction processing?

    On receipt of this report the company will be able to check that the address was typed in correctly or if the address is no longer recognised. Although there are a lot of benefits and advantages of using Email but with this come the downfalls and disadvantages.

  2. Discuss the relationship that exists in the UK between the legal rules that govern ...

    Article 78 which states that a director is to be appointed by the general meeting not by another director or by the board. Table A: Article 79 requests that there is a co-option between general meetings. The Combined Code suggests that the appointment of new directors should be by a

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