DBM 380 Start With a Dream/newtonhelp.com

1
DBM 380 Start With a Dream/newtonhelp
2
DBM 380 Start With a Dream/newtonhelp

• DBM 380 All Assignments
• For more course tutorials visit
• www.newtonhelp.com
•  
• DBM 380 Assignment Week 1 Database Recommendation
• DBM 380 Assignment Week 2 Normalized Database
  Design Assignment

3
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Assignment Week 1 Database Recommendation
• For more course tutorials visit
• www.newtonhelp.com
•  
• Database Recommendation
• Instructions
• The first and most important database-related
  decisions are whether to
• use a database at all and, if so, which database
  management system to

4
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Assignment Week 2 Normalized Database
  Design Assignment
• For more course tutorials visit
• www.newtonhelp.com
•  
• Normalized Database Design Assignment
• Instructions
• A relational database must be designed and
  normalized before it can
• be created, populated with data, and used.
  Database design depends
• on the business scenario(s) a database architect
  needs to model

5
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Assignment Week 3 Create and Populate a
  Database
• For more course tutorials visit
• www.newtonhelp.com
• Create and Populate a Database
• Instructions
• Resources "SQL CREATE DATABASE Statement," "SQL
  CREATE
• TABLE Statement," "SQL PRIMARY KEY Constraint,"
  "SQL FOREIGN
• KEY Constraint," and "SQL INSERT INTO Statement"

6
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Assignment Week 4 Select and Update Data
  in Related Tables
• For more course tutorials visit
• www.newtonhelp.com
•  
• Select and Update Data in Related Tables
• Instructions
• Running reports on existing data and updating
  data records are very
• common tasks in the industry.

7
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Assignment Week 5 Database Administrator
• For more course tutorials visit
• www.newtonhelp.com
•  
• Database Administrator
• Instructions
• Imagine that you have the educational background,
  skills, and abilities
• to be a database administrator. The XYZ company
  recently announced
• a vacancy for a database administrator position

8
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 1 DQ 1
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
• Using the Ghanem (2010) article as a guide, what
  are the benefits of using Views in a database?

9
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 1 DQ 2
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
• Based on the Manegold (2009) article, what are
  two new methods of optimizing data retrieval from
  a high-use database?

10
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 2 DQ 1
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
• What are the issues identified in the Cox (2009)
  article that a database administrator should know
  when working with a many-to-many relationship.
  Identify and discuss one of them.

11
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 2 DQ 2
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
• Using the Geiger (2009) article as a guide, how
  must a database administrator balance the time to
  complete data modeling step with the benefits
  this step offers in creating a database?

12
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 2 Individual Assignment Database
  Design Paper
• For more course tutorials visit
• www.newtonhelp.com
•  Write a 350- to 700-word paper in which you do
  the following
•           Explain what database systems are and
  how they are used at your workplace.
•          Define database architecture. For the
  database systems in your workplace, identify
  which architecture they fall under.

13
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 2 Team Assignment (Huffman Trucking)
  Entities and Attributes Requirements
• For more course tutorials visit
• www.newtonhelp.com
•  
• Begin work on Service Request SR-ht-003, due in
  Week Five, by completing Change Request 2.
• Create documentation for this project that
  summarizes the process for using the entities and
  attributes for fleet truck maintenance.

14
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 3 DQ 1
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Wang and Gong (2007) explain how database
  management systems (DBMS) and data mining can
  help a motor vehicle maintenance center improve
  its services. Based on your reading of the
  article, which tables are needed

15
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 3 DQ 2
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
• Why do you think the use of icons in
  entity-relationship diagrams as described in the
  Masri (2008) article resulted in a better
  understanding of these complex diagrams by users?

16
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 3 Individual Assignment ERD Creation
  Project
• For more course tutorials visit
• www.newtonhelp.com
•  
• The following assignment refers to material found
  in the Virtual Organizations.
•  
• Create a detailed ERD using the Entities and
  Attributes for Driver's Log document found on the
  Huffman Trucking Intranet site. A copy of the
  tables is posted at the end of this document.

17
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 3 Team Assignment
• For more course tutorials visit
• www.newtonhelp.com
•  
• DBM 380 Week 3 Team Assignment

18
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 4 DQ 1
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
• Based on the Chen (2007) article, why must a
  database administrator consider more than just
  function dependency during the normalization
  process?

19
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 4 DQ 2
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
• Do you consider the new approach to teaching the
  concepts of database normalization introduced in
  the Wang (2010) article easier for you to grasp?
  Explain why.

20
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 4 Individual Assignment
  Normalization of the ERD
• For more course tutorials visit
• www.newtonhelp.com
•  
• Normalize the ERD.
• Use Microsoft Access to create the keys and
  relationships between tables for the Huffman
  Trucking Driver Log.

21
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 4 Team Deliverables
• For more course tutorials visit
• www.newtonhelp.com
•  
• DBM 380 Week 4 Team Deliverables

22
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 5 DQ 1
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
•   Identify and discuss the data mining techniques
  outlined in the Ting (2009) article. How will
  understanding these techniques affect the way you
  approach database design?

23
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 5 DQ 2
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Based on the Yew (2009) article, how does the
  information presented to decision makers affect
  the quality of their decisions?

24
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 5 Team Assignment Service Request SR
  ht 003 Presentation
• For more course tutorials visit
• www.newtonhelp.com
•  
•  
• Create a 3- to 5-slide Microsoft PowerPoint
  presentation in which you explain how the
  principles of database management and your
  recommendations were applied to the project.

25
DBM 380 Start With a Dream/newtonhelp

• DBM 380 Week 5 Team Assignment Service Request
  SR-ht-003
•  
• For more course tutorials visit
• www.newtonhelp.com
•  
•  Finalize the project work for SR-ht-003 and
  Change Requests 25.
• Compile all documentation from your Change
  request from Weeks Two through Five.
• Submit your teams project work and documentation
  to your faculty.

26
DBM 380 Start With a Dream/newtonhelp