| Evidence |
Deliverable Item |
Points Posible |
Points Earned |
| Instructor will review data entry forms for populating tables Insurance and Dependent with data |
A: Data Entry forms: PopulateInsurance and PopulateDependent |
4.0 |
| Instructor will review Data Sheet and Design Views for ALL database tables: Insurance, Employee, Dependent, Rate and Enrollment |
B: Access objects (tables) with data: Insurance, Employee, Dependent, Rate, Enrollment |
6.0 |
| Instructor will review relationships, cardinality (e.g., one-to-many) and referential integrity. |
C: Relationships for all tables. |
5.0 |
| Instructor will evaluate the design and output of Query 1: Query1EmplperIns |
D: Query Datasheet and Design Views. Query results will be evaluated for correct output. |
4.0 |
| Instructor will evaluate the design and output of Query 2: Query2MonthlyPayrollDeductions |
E: Query Datasheet and Design Views. Query results will be evaluated for correct output. |
6.0 |
| Instructor will evaluate the design and output of Query 3: Query3DepCodeperInsurance |
F: Query Datasheet and Design Views. Query results will be evaluated for correct output. |
9.0 |
| Instructor will review Employees by Insurance Report (reportEmployeesbyInsurance) and its associated query (QueryEmployeesByInsurance) |
G: Employees By Insurance Report. Consistent, professional design is important to have for this deliverable. Correct content of the report is also important. |
8.0 |
| Instructor will review Employee Personalized Enrollment Report (reportEmployeePersonalizedEnrollment) and its associated query (QueryPersonalizedEnrollmentNew) |
H: Employee Personalized Enrollment Report . Review both Report View and Design Views. Consistent, professional design is important to have for this deliverable. |
8.0 |
|
| Total: |
50.0 |
0.0 |
Kingmatt
Rubric.xlsx
