Project Part 1 - Prepare and submit 1-2 page statement of work (SOW) to describe the need to create, design and implement the database that you propose for your project. Check syllabus and review sample SOW available under course content as reference (Note: the sample SOW is a barebone example and only provides a highlight of the basic components of a SOW. Please use it as reference only and add more contents to your SOW).

Statement of Work (SOW)

DBST651, term year(SAMPLE)

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.

• 2Create a simple Entity Relationship Diagram (ERD) using ER Assistant or any suitable diagram tool consisting of 3 tables of your choice (not graded).
• Project Part 1 - Prepare and submit 1-2 page statement of work (SOW) to describe the need to create, design and implement the database that you propose for your project. Check syllabus and review sample SOW available under course content as reference (Note: the sample SOW is a barebone example and only provides a highlight of the basic components of a SOW. Please use it as reference only and add more contents to your SOW).

Statement of Work (SOW)

DBST651, term year(SAMPLE)

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.

• 2Create a simple Entity Relationship Diagram (ERD) using ER Assistant or any suitable diagram tool consisting of 3 tables of your choice