Database Design and Implementation Products on Sale Database
CIS 3100 - Database Design and Implementation
Scoring Rubric
|
Criteria |
|
Points Possible |
Points Earned |
|
A. Employee Table 1. Table & data types created correctly 2. Records / attributes populated correctly
|
(5) (5) |
10 |
|
|
B. Import Data 1. Customer data imported correctly 2. Product Supplier data imported correctly
|
(5) (5) |
10 |
|
|
C. Forms 1. Supplier form is functional 2. Product Category form is functional
|
(5) (5) |
10 |
|
|
D. Relationships 1. Relationships are properly configured
|
(20) |
20 |
|
|
E. Queries 1. MostProductsSold query is functional 2. CustomerOrders query is functional 3. ProductPrices query is functional
|
(10) (10) (10) |
30 |
|
|
F. Report 1. Report meets management expectations
|
(10) |
10 |
|
|
G. Assessment 1. Assessment meets management expectations 2. Assessment embedded in personal record
|
(5) (5) |
10 |
|
|
Total |
100 |
|