| Lecture notes for the Introduction to computers by James Tam | Return to the course web page |
Ensuring the integrity of the data |
|
Max max |
Mark received |
||
| Employees table | 12 | ||||
| Locations table | 11 | ||||
| Titles table | 4 | ||||
| SUBTOTAL FOR ENSURING DATA INTEGRITY | 27 | ||||
Other changes to the tables |
|||||
|
|
Providing useful error messages | 2 | |||
| Documenting the description fields | 8 | ||||
|
|
Adding images to the picture field | 5 | |||
|
|
Setting the primary keys | 6 | |||
|
|
Matching way in which data is stored in the fields of the database with the type of data to be stored | 2 | |||
|
|
SUBTOTAL FOR MAKING THE OTHER CHANGES TO THE TABLES | 23 |
|
|
|
|
|
|
Max max |
Mark received |
||
| Creating a form for all the fields of the Employees table | 9 | ||||
|
|
|
Max max |
Mark received |
||
| First query (showing the correct fields: 2 marks, query: 2 marks) | 4 | ||||
| Second query (showing the correct fields: 2.5 marks, query: 4 marks) | 6.5 | ||||
| Third query (showing the correct fields: 2 marks, query: 4 marks) | 6 | ||||
| Fourth query (showing the correct fields: 2, query: 4 marks) | 6 | ||||
| Fifth query (showing the correct fields: 2.5 marks, query: 3 marks) | 5.5 | ||||
| Sixth query (showing the correct fields: 2.5 marks, query: 7 marks) | 9.5 | ||||
|
|
Seventh query (showing the correct fields: 2.5 marks, query: 5 marks) | 7.5 | |||
| SUBTOTAL FOR THE QUERIES | 45 | ||||
OVERALL RAW SCORE (MAX 104) |
|
LETTER GRADE: |
| A | 100 - 104 | C | 70 - 74 | |
| A- | 95 - 99 | C- | 65 - 69 | |
| B+ | 90 - 94 | D+ | 55 - 64 | |
| B | 85 - 89 | D | 45- 54 | |
| B- | 80 - 84 | F | < 45 | |
| C+ | 75 - 79 |