DBM 502 Experience Tradition/newtonhelp.com

1
DBM 502 Experience Tradition/newtonhelp.com
2
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• DBM 502 Week 1 Database Fundamentals

3
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• DBM 502 Week 2 Entity Relationship Diagram

4
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• Learning Team Database Roles
• Review the Learning Team Project Instructions.
• Write a 2- to 3-page paper describing the
  organization's staffing needs relative to
  database and application development, and
  database administration. The team needs to agree
  on the staff positions to use. From there, they

5
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• Learning Team Database Roles
• Review the Learning Team Project Instructions.
• Write a 2- to 3-page paper describing the
  organization's staffing needs relative to
  database and application development, and
  database administration. The team needs to agree
  on the staff positions to use. From there, they

6
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• Learning Team Database Design Standards
• Review the Learning Team Project Instructions.
• Create database design standards and validation
  approaches for the organization. This needs to
  include how the design would be checked from each
  perspective, with each role again contributing
  according to its interests (for

7
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• Learning Team Database Validation Plan
•  
• Create a 1- to 2-page paper defining the
  standards and approaches for the validation of
  database and application code. These include
  coding standards, expectations for what has been
  checked at each stage of testing (unit test,
  system test, user test), expectations for code
  review or inspection, etc.

8
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• DBM 502 Week 4 Database Warehouse and Historical
  Data (100 Score)

9
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• Explain the technology and approach you would use
  to handle the needs for studying historical
  trends in the information you have collected,
  combining it with other databases if needed. What
  information from the database would you collect
  over time?

10
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• DBM 502 WEEK 5 ASSIGNMENT 1
• Assignment 1
• Learning Team Database Administration Standards
• Create standards for database administration.
  This should include how performance will be
  monitored and tuned, how backups will happen, how
  data quality will be monitored and improved, how
  information should be secured, etc. The
  administration role is major here, but
  development roles will need to contribute on
  where they can build

11
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• This assignment reflects an accumulation of the
  individual assignments from Weeks One through
  Five, which included creating an ERD, exploring
  database fundamentals, Data Architecture for
  Transactional Databases, Interacting with a
  Transactional Database, Data and Database
  Administration for Transactional Databases, Data
  Warehouses and Historical Data.

12
DBM 502 Experience Tradition/newtonhelp.com

• For more course tutorials visit
• www.newtonhelp.com
•  
• Learning Team Executive Presentation
• Combine the work from the preceding weeks. If not
  already done, make sure that the interests of
  each role are considered, and, where important,
  explicitly described for each area.

13
DBM 502 Experience Tradition/newtonhelp.com