DBM 502 Guidance Counselor / newtonhelp.com

1
DBM 502 Guidance Counselor / newtonhelp.com
2
DBM 502 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / 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 Guidance Counselor / newtonhelp.com