Statement of Work

Here is the statement of work we did in class

History

The college wants to implement short certificates that can be earned more quickly than existing certificates. This will increase the number of completions. Registration says it cannot track these new certificates, so a new database is needed to track them.

Scope

The database should track the certificates, and the classes each certificate requires. The database must also track the classes each student takes and what certificates they have earned. For a class to qualify a student must earn at least a 2.0, the classes should all have been taken within a five year span The database should allow for class substitutions. It should allow some comments and notes. The database should produce email and phone lists for students who have earned a certificate. Students who are close to a certificate should be notified. The database should be secured to protect student information.

The database should produce reports of how many students earned particular certificates in a given period. It should report how many students almost achieved certificates but were missing one class or so. Might use database to track popular and special topic courses, and how much time it took to complete the certificates.

Constraints: The database will not read the student data directly from the school system.

Objectives

To track short term certicates.

To determine which students achieve certificates

Preliminary Time Line

TimeLine

Gathering information—4 weeks

Defining Business Rules—2 weeks

Designing databases—1 week

Normalizing data—1 week

Make the database--week

Test the database sql--week

security