DATABASE APPLICATIONS SCORING SHEET Points Points Unless indicated otherwise, contestant receives all points or none. Possible Earned Job 1 Employee Table (200 points maximum) – Designed as instructed (10 points off per field for inaccurate field names, 80 inappropriate data types, and properties not set as instructed) Proofreading/data entry 100 (100 0 errors; 90 1 error; 70 2 errors; 0 3+ errors) – – – – 10 Sorted by “Last Name” (ascending) Printed using best fit in landscape orientation (all data shows, 1 page) 10 Job 2 Management Table (90 points maximum) – Designed as instructed (10 points off per field for inaccurate field names, 20 inappropriate data types, and properties not set as instructed) Proofreading/data entry (1 point off for each error) 50 (50 0 errors; 45 1 error; 35 2 errors; 0 3+ errors) – – – – Sorted by in ascending order 10 ‘Department’ Printed in portrait orientation, 1 page, all fields fully visible 10 Job 3 Create a Permanent Relationship (25 points maximum) – One-to-Many relationship created 10 Referential integrity enforced 10 Printed with both tables fully visible 5 Job 4 Performance Review Query (50 points maximum) – Correct fields are visible: Emp Id, First Name, Last Name, Department, 25 Manager (5 points off for each missing field) Sorted by (ascending) and then by Employee Last Name “Department” 10 (ascending) Results show design correctly joins both tables (no extra records) 10 Printed in landscape orientation, 1 page, all fields fully visible 5 Job 5 Performance Review Report (35 points maximum) – Title is PerformanceReview-XX-XXXX-XXXX 5 Correct fields are included in the Report: all fields in the query except 10 Emp ID Sorted by Name" 10 Employee’s “Last Printed in portrait orientation, 1 page, all fields fully visible 10 Total Points Earned 400
DATABASE APPLICATIONS SCORING SHEET Unless indicated otherwise, contestant receives all points or none. Points Possible Points Earned Job 1 – Employee Table (200 points maximum) Designed as instructed (10 points off per field for inaccurate field names, inappropriate data types, and properties not set as instructed) 80 Proofreading/data entry (100 – 0 errors; 90 – 1 error; 70 – 2 errors; 0 – 3+ errors) 100 Sorted by “Last Name” (ascending) 10 Printed using best fit in landscape orientation (all data shows, 1 page) 10 Job 2 – Management Table (90 points maximum) Designed as instructed (10 points off per field for inaccurate field names, inappropriate data types, and properties not set as instructed) 20 Proofreading/data entry (1 point off for each error) (50 – 0 errors; 45 – 1 error; 35 – 2 errors; 0 – 3+ errors) 50 Sorted by ‘Department’ in ascending order 10 Printed in portrait orientation, 1 page, all fields fully visible 10 Job 3 – Create a Permanent Relationship (25 points maximum) One-to-Many relationship created 10 Referential integrity enforced 10 Printed with both tables fully visible 5 Job 4 – Performance Review Query (50 points maximum) Correct fields are visible: Emp Id, First Name, Last Name, Department, Manager (5 points off for each missing field) 25 Sorted by “Department” (ascending) and then by Employee Last Name (ascending) 10 Results show design correctly joins both tables (no extra records) 10 Printed in landscape orientation, 1 page, all fields fully visible 5 Job 5 – Performance Review Report (35 points maximum) Title is PerformanceReview-XX-XXXX-XXXX 5 Correct fields are included in the Report: all fields in the query except Emp ID 10 Sorted by Employee’s “Last Name" 10 Printed in portrait orientation, 1 page, all fields fully visible 10 Total Points Earned 400
240-Database%20Applications_R_2016.docx