Project Assignment
Data Management Project Requirements:
This will be an individual project. The final project plan with all design, research, and work should be completed by each student individually. Students will become familiar with data management, database modeling and design, and the skills to develop a final project plan. These requirements include (Requirements Analysis – Data model – In physical design format):
Background
Purpose
Business goals and rules
User requirements
Data requirements
Reporting requirements
Project schedule and project costs.
Data dictionary for all tables in data model
SQL statements:Identify the database management system (DBMS) that will be used for the database design
minimum of two CREATE TABLE statements (for entities defined in model)
minimum of two SELECT statements
one insert, update or delete statement.
Each week there will be a deliverable due for different components. The deliverables are as follows:
Week 1 – Data Management Project Description
Provide the background information of the data model to be developed.
Identify the purpose of the project and the data model.
Week 2 – Data Management Project Outline
Define Entities, primary keys, and relationships that are used to define the data model for your project.
Week 3 – Data Management Project Initial Rough Draft
Submit a rough draft or conceptual model.
Use the entities, primary key, and relationships identified in Week 2 to develop this model.
Week 4 – Data Dictionary
Use one or two entities from Week 3 submission of data model.
Provide the following information for the data dictionary: attribute name, data type, size, and definition.
Sample formats are provided.
Week 5 – ERD Diagram
For all tables: primary keys, attributes, data types Define all relationships
Define all foreign keysThis database should be normalized in 3rd normal form.
Week 6 – Final Project Rough Draft Submission (before Final Draft Submission in Week 7)
All project requirements identified above should be submitted in this “final rough draft”
This will give students the capability to get feedback and identify any issues before submitting final project in Week 7.