Expert answer:Week 1 Definition of the Requirements Analysis sec
Solved by verified expert:I need help with beginning a data management project. The project should span over 7 weeks. Please see below for week 1 deliverables:Week 1 – Definition of the Requirements Analysis section. Identify the project you plan to work on over the next 7 weeks. This could be based on experience you have in a previous job or could be based on one of your hobbies. It should be a way to gather meaningful information to help solve a problem with a process or to improve a process. You need to make sure you’ll be able to meet the requirements with your project. I would expect to see 1-2 paragraphs each in a Background section and in a Purpose section (2-4 paragraphs total). This is providing the background information of the data model to be developed in subsequent weeks.Add business requirements. Download the file above. #2 Identify the components of data model: Define the entities, primary keys, and relationships that are used to define the data model for your project in the space provided.
data_management_project_requirements_2017__1_.docx
week1_data_management_project_description_2017__1_.doc
file_2___data_management_project_outline___entities__attributes__and_relationships_2017__1_.doc
data_management_project_requirements_2017__1_.docx
Unformatted Attachment Preview
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 model – in physical design format
Data dictionary for all tables in data model
SQL statements:Identify the database management system (DBMS) that will be used for
the database design
o minimum of two CREATE TABLE statements (for entities defined in model)
o minimum of two SELECT statements
o one insert, update or delete statement.
Identify the database management system (DBMS) that will be used for the database
design (ex: Oracle, mySQL, SQL Server, etc).
Create a basic database back-up and recovery plan.
Weekly Project Deliverables
Each week there will be a deliverable due for different components. The deliverables are as
follows:
Week 1 – Data Management Project Description
o
o
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
o
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
o
Submit a rough draft or conceptual model.
o
Use the entities, primary key, and relationships identified in Week 2 to develop
this model.
Week 4 – Data Dictionary
o
o
o
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
o
o
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)
o
o
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.
Working in Groups
You may work on this as a group or individually (whichever you prefer). I would ask the
following:
•
•
•
•
Group size should be no larger than 5 people.
Email me a list of the people in the group by the end of the week (Friday, July 10 at
11:59pm).
Please place all of your names on the assignment and each of you will need to
individually submit the assignment.
All of the written assignments are being sent through Safe Assign. This is a tool to flag
any plagiarism. I wanted each of you to know this so there weren’t any surprises. The
first offense of any plagiarism results in a 0% on the assignment and the second offense
results in me having to report you for plagiarism. Please let me know if you have any
questions regarding properly citing sources, etc.
IST7000 – Data Management Individual Project – Project Description
Student Name: _____________________________________________
Project Name/Title:__________________________________________
Provide a brief description about what type of data model you’re developing, along
with a project description.
IST7000 – Data Management Individual Project Outline –
Entities, Attributes, and Relationships:
Student Name: _____________________________________________
Project Name/Title:__________________________________________
Entities and Attributes:
Entity Name: ____________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Entity Name: ____________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Entity Name: ____________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Entity Name: ____________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Entity Name: ____________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Attribute:_______________________________________________
Relationship Definitions:
Relationship: ____________________________________________
Relationship:_____________________________________________
Relationship:_____________________________________________
Relationship:_____________________________________________
Relationship:_____________________________________________
Relationship:_____________________________________________
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 model – in physical design format
Data dictionary for all tables in data model
SQL statements:Identify the database management system (DBMS) that will be used for
the database design
o minimum of two CREATE TABLE statements (for entities defined in model)
o minimum of two SELECT statements
o one insert, update or delete statement.
Identify the database management system (DBMS) that will be used for the database
design (ex: Oracle, mySQL, SQL Server, etc).
Create a basic database back-up and recovery plan.
Weekly Project Deliverables
Each week there will be a deliverable due for different components. The deliverables are as
follows:
Week 1 – Data Management Project Description
o
o
Provide the background information of the data model to be developed.
Identify the purpose of the project and the data model.
Week 1B – Data Management Project Outline
o
Define Entities, primary keys, and relationships that are used to define the data
model for your project.
Week 2 – Data Management Project Initial Rough Draft
o
Submit a rough draft or conceptual model.
o
Use the entities, primary key, and relationships identified in Week 2 to develop
this model.
Week 3 – Data Dictionary
o
o
o
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
o
o
For all tables: primary keys, attributes, data types Define all relationships
Define all foreign keysThis database should be normalized in 3rd normal form.
Week 7 – Final Project Rough Draft Submission (before Final Draft Submission in Week 7)
o
o
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.
Working in Groups
You may work on this as a group or individually (whichever you prefer). I would ask the
following:
•
•
•
•
Group size should be no larger than 5 people.
Email me a list of the people in the group by the end of the week (Friday, July 10 at
11:59pm).
Please place all of your names on the assignment and each of you will need to
individually submit the assignment.
All of the written assignments are being sent through Safe Assign. This is a tool to flag
any plagiarism. I wanted each of you to know this so there weren’t any surprises. The
first offense of any plagiarism results in a 0% on the assignment and the second offense
results in me having to report you for plagiarism. Please let me know if you have any
questions regarding properly citing sources, etc.
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades