Project Part 1: Statement of Work (SOW) Assignment

Statement of Work (SOW)

<Student Name> DBST651, term year

Overview:

I will create a database to keep track of personal workout history for a fitness focused individual.

Purpose and Objective:

The database will enable a personal training client to enter and store history regarding the specific workouts, including type of exercise (cardiovascular / resistance/ weight training) exercise name, sets, reps or duration, weight setting, and the units of measurement for each exercise type. Workout sessions can be tracked over time, helping the client to identify the dates they worked out and what exercises were performed during each workout. The information stored in this database could be used for aggregating monthly workout statistics to allow an individual to track their personal fitness over time with the ability to spot trends in cardiovascular activity and weight lifting strength.

Diagram Tool:

ER Assistant

Database:

Oracle 11g, using Virtual Desktop Applications (VDA)

Hardware and Software:

UMUC (VDA) Intel(R) Xeon(R). Operating system is Linux.

DDL and DML:

SQL (Structured Query Language) will be used for the DDL and DML. For my DDL scripts, I will use SQL to translate the information captured in my ER diagram (created in ER Assistant) into database table creation scripts. For my DML scripts, I will use SQL to insert rows of data into my database tables.