Week 1 Definition of the Requirements Analysis section

User Generated

cvaxl0101

Programming

C170 Data Management Application

Wilmington University

Description

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.

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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Data Management Individual Project Outline –
Entities, Attributes, and Relationships:

Student Name: _____________________________________________
Project Name/Title:__________________________________________

Entities and Attributes:

Entity Name: customer

Attribute: customer Name
At...


Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags