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

# Computing Project

Extracts from this document...

Introduction

Middle

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.

Conclusion

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

# 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. ## Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

meaning: For example, you can also specify in this infotype that payment should be effected by cheque/bank transfer. * Recurring payments/deductions infotype (0014) in which you capture the details of periodic/regular earnings or deductions. For Mastek, Indian payroll, they will be Medical Reimbursement, Reimbursement of Books, Leave Without Pay, Guesthouse Deduction, Personal Courier and Personal STD/ISD Phone Call.

1. ## Computing Project

This will be received in a paper form. * The DVD's will be obtained from the shop itself and its details will be entered into the system by the shop clerk/user. 5. Data Flow Diagram (Current System) (Proposed System) 6.

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. ## Video Club Database Project

replace the current methods of recording records so that the details are typed directly into the computer and the required copies printed out. This could then be extended to link into a computerized accounts system. Software The customer has requested that the system be developed using Ms Access, so useless

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

This is to keep the management fresh as well as to allow the shareholders to have their opinion on a director who they do not think is acting in the best interests of a company. Going back to the fifth principle of the code; "The board should be supplied in

1. ## Different ways of data capture

Upgrades can do the following: *Documents or applications produced by the upgrade are not 'downwardly compatible' i.e documents written in Version 6 can usually be read in version 7 but ones written in 7 cant be read in version 6!

2. ## Tod's Tyres is a small business that supplies new car tyres to company car ...

* Data entry must be limited to authorised personnel only. * All output should be inspected for reasonableness and any inconsistencies investigated. Security of data Computer-based information systems are vulnerable to crime and abuse, natural disaster and human error.

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