DBM 502 Improved tutorial / newtonhelp.com

1
DBM 502 Improved tutorial / newtonhelp.com
2
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Apply Team Week 4 Data Models
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Read the following sections of Case Forondo
  Artist Management Excellence Inc. of Modern
  Database Management
• Case Description
• Email from Alex Martin, Administrative
  Assistant
• Email from Dale Dylan, Established Artist
• Email from Sandy Wallis, Event Organizer

3
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Apply Week 1 Database Management Plan
  Part 1 Storing and Extracting Information
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• ScenarioYou are the Vice President for
  Information Technology at a small, growing
  business. You have been tasked with developing a
  plan for maintaining databases for storage of
  business data and use in business analytics.?In
  Weeks 1-5 you will work on gathering information
  in a Database Management Plan.

4
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Apply Week 2 Database Management Plan
  Part 2 Database Storage
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Create 700-word entry in your Database Management
  Plan. You will use information from this entry in
  your presentation due in Week 6. Ensure you   
• Assess the best way to organize data into your
  database.
• Distinguish how organizational data can be used
  in the most effective way through developing a
  database.
• Describe the relationship model and conceptual
  design to be used.  

5
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Apply Week 2 Team Database Instruction
  Analysis
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Read the following sections of Case Forondo Artis
  t Management Excellence Inc. on p. 51 of Modern
  Database Management
• Case Description
• Email from Martin Forondo, Owner
•  
• As a Learning Team, create a 750-word memo
  describing your initial analysis of the situation
  at Forondo Artist Management Excellence (FAME) as
  it relates to the design of the database
  application.

6
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Apply Week 3 Database Management Plan
  Part 3 Database Administration and Data
  Governance
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Based on your previous work in the previous
  week, create a 700-word entry in your Database
  Management Plan. 
•  
•  Ensure you  
• Evaluate and assist company decision makers in
  understanding the importance of database
  administration and data governance in relation to
  building scalable and robust applications.

7
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Apply Week 4 Database Management Plan
  Part 4 Administration and Validation
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Based on your previous work in the previous
  week, create a 700-word entry in your Database
  Management Plan. You will use information from
  this entry in your presentation due in Week 6.
  Ensure you
• List the benefits of data administration compared
  to database administration.
• Propose an effective data governance program.

8
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Apply Week 5 Database Management Plan
  Part 5 Monitoring and Team Roles
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Based on your previous work in the previous
  weeks, create a 700-word entry in your Database
  Management Plan.
•  
• Consider the previous weeks creation of
  standards for database administration and explain
  the following in your entry  
• How performance will be monitored and tuned 
• How backups will happen 

9
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Apply Week 6 Database Management Plan
  Final Project Plan for Business Data and
  Analytics
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• You are the Vice President of Information
  Technology at a small, growing business. You have
  been tasked with developing a plan for
  maintaining databases for storage of business
  data and use in business analytics. 
•  
• Using the work from Weeks 1-5, create a 20-minute
  presentation (10-12 slides) to explain your
  Database Management Plan. Ensure you  

10
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Week 1 Discussion Data and Information
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Respond to the following in a minimum of 175
  words
• Contrast the terms data and information.
• Use Figure 1-1 in?Ch. 1, "The Database
  Environment and Development Process," of?Modern
  Database Management as a starting point.

11
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Week 2 Discussion Entity Relationship
  Diagrams
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Respond to the following in a minimum of 175
  words
• Describe the benefits of using Entity
  Relationship Diagrams (ERDs) in database design,
  implementation, and documentation.

12
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Week 3 Discussion SQL Server
• For more course tutorials visit
• www.newtonhelp.com
•  
• Mertel Insurance is implementing a Microsoft?SQL
  Server?database that will track customer
  information, policy information, and transaction
  histories. The biggest concern is providing
  access to the information each team needs.

13
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Week 4 Discussion Database Administration
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Respond to the following in a minimum of 175
  words
• Compare and contrast the roles of database
  administrators and data stewards in an
  organization.
• What responsibilities do both have in order to
  meet data management, quality, and governance
  standards?

14
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Week 5 Discussion Data Warehouse
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Respond to the following in a minimum of 175
  words
• Describe how business intelligence can help an
  organization monitor, manage, and make decisions
  for its business.
• How are data integrated via the use of data
  warehouses and data marts?
• How will the increasing trend to use cloud-based
  databases impact your thinking? 

15
DBM 502 Improved tutorial / newtonhelp.com

• DBM 502 Week 6 Discussion Big Data and Analytics
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Respond to the following in a minimum of 175
  words
• How can Hadoop and associated technologies, like
  Hive and Pig, be used to manage big data within
  an organization?
• How can the use of data analytics and using
  languages like R and Python help an organization
  in tangible ways? 

16
DBM 502 Improved tutorial / newtonhelp.com