Database Design and Implementation Products on Sale Database

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