The activities in this project are designed to provide a better understanding of how data is organized into a relational database. A relational database enables management information systems to suppo

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