- Home
- Table of Contents
- Statement of Authenticity
- Personal Mission Statement
- Elevator Speech
- Education
- Resume
- Work Samples
- Professional Development and Training
- Letters of Reference
- Reference List
- Awards and Accomplishments
- Volunteer History
- Professional Affiliations
- Career Pathing
- DeVry University Computer
Project Management Example
Download Example
Software and materials used: Microsoft 2007, Microsoft Visio, Excel, Notepad, Oracle
Language used: SQL Script/SQL select statements
The following documentation is a copy of a course project generated by my fellow classmates as team members and myself, serving as project manager. The project centers on a fictitious company called MiniQuest’s Prime Time System. Our task was to present a detailed data model scenario, which would include an Entity Relationship Diagram (ERD), and metadata chart (data dictionary), and to create a database that will be used to track all customers, the types of subscription they purchased and incorporate a billing system as well. The ERD diagram is used to depict all the entities and their specific attributes and how they relate to each other.
We accomplished the detailed data model scenerio by using Microsoft Visio and developed the dataset for MiniQuest by using Oracle and used Notepad for the CREATE STATEMENTS and the CREATE TABLE statements to create database tables. The SQLScript/SQL select statements and methods were used to retrieve data from the database tables. We positioned the DROP TABLE statements at top of file in order to reuse the file and placed the CREATE TABLE statements in reverse order due to integrity constraints. Then, we tested and verified create statements worked and then created a spooled output file with the SET ECHO ON session command so that the code and results would show. Then we developed SQL statements to insert records into the database in the same order that the tables were created to minimize any integrity constraint errors. We also noted that any values being inserted into a field defined as a foreign key must first exist in a previous table’s primary key field. In addition, we also developed a query to identify and mark inactive customers that have bills overdue by more than 30 days using a sub-query under the heading called “MODIFY STATEMENTS”. Furthermore, in order to support the requested reports, queries were developed under the heading “REPORTING STATEMENTS”. This project was designed to touch on all aspects of the
fundamental concepts of database design and logical data modeling.
The entire project/report is available to read in the following pages. Below, I have listed certain skills I used in the project that may be of particular interest: ·
Project management: The following example demonstrates my ability to task, organize, and motivate a team. A project of this size, although relatively small, still required the same attention to detail and motivation as a larger project. This project also required a great deal of time and resource management.
Writing sample: The document serves as an example of my project documentation skills.
Language used: SQL Script/SQL select statements
The following documentation is a copy of a course project generated by my fellow classmates as team members and myself, serving as project manager. The project centers on a fictitious company called MiniQuest’s Prime Time System. Our task was to present a detailed data model scenario, which would include an Entity Relationship Diagram (ERD), and metadata chart (data dictionary), and to create a database that will be used to track all customers, the types of subscription they purchased and incorporate a billing system as well. The ERD diagram is used to depict all the entities and their specific attributes and how they relate to each other.
We accomplished the detailed data model scenerio by using Microsoft Visio and developed the dataset for MiniQuest by using Oracle and used Notepad for the CREATE STATEMENTS and the CREATE TABLE statements to create database tables. The SQLScript/SQL select statements and methods were used to retrieve data from the database tables. We positioned the DROP TABLE statements at top of file in order to reuse the file and placed the CREATE TABLE statements in reverse order due to integrity constraints. Then, we tested and verified create statements worked and then created a spooled output file with the SET ECHO ON session command so that the code and results would show. Then we developed SQL statements to insert records into the database in the same order that the tables were created to minimize any integrity constraint errors. We also noted that any values being inserted into a field defined as a foreign key must first exist in a previous table’s primary key field. In addition, we also developed a query to identify and mark inactive customers that have bills overdue by more than 30 days using a sub-query under the heading called “MODIFY STATEMENTS”. Furthermore, in order to support the requested reports, queries were developed under the heading “REPORTING STATEMENTS”. This project was designed to touch on all aspects of the
fundamental concepts of database design and logical data modeling.
The entire project/report is available to read in the following pages. Below, I have listed certain skills I used in the project that may be of particular interest: ·
Project management: The following example demonstrates my ability to task, organize, and motivate a team. A project of this size, although relatively small, still required the same attention to detail and motivation as a larger project. This project also required a great deal of time and resource management.
Writing sample: The document serves as an example of my project documentation skills.