DBM 380 Aprentice tutors / snaptutorial.com

1
DBM 380 Slingshot Academy / snaptutorial.com
For More Tutorials
www.snaptutorial.com
2
DBM 380 Slingshot Academy / snaptutorial.com

• DBM 380 Entire Course

• DBM 380 Week 1 DQ 1

• DBM 380 Week 1 Individual Assignment DataBase
  Paper
• DBM 380 Week 1 DQ 1
• DBM 380 Week 1 DQ 2
• DBM 380 Week 2 Team Assignment Service Request
  SR-ht-003 Change Request 2
• DBM 380 Week 2 Individual Assignment Database
  Environment Paper

• Reflect on the textbook readings. Using the
  search strings listed in the Electronic Reserve
  Readings for Week one search for additional
  information on database systems. What information
  would your provide to an organization or your
  employer on why database systems should be used?

3
DBM 380 Slingshot Academy / snaptutorial.com

• DBM 380 Week 1 DQ 2

• DBM 380 Week 1 Individual Assignment DataBase

• What limitations have you or someone you know
  encountered in the past in using nonrelational
  structures (such as in a Microsoft Excel or
  Word file) to store data?
• What were the advantages?

• Write a 350- to 700-word paper in which you do
  the following
• Explain what database systems are and
  how they are used.
• Define database architecture. Consider
  Microsoft Access, Microsoft SQL Server,
  Oracle, and IBM DB2 software as possible
  examples.

4
DBM 380 Slingshot Academy / snaptutorial.com

• DBM 380 Week 2 DQ 1

• DBM 380 Week 2 DQ 2

• Think of a situation where null value should be
  allowed and a situation where it should not be
  allowed. What are the consequences of
  inappropriate null settings?

• Why it is necessary to choose appropriate data
  types for each data column?

5
DBM 380 Slingshot Academy / snaptutorial.com

• DBM 380 Week 2 Individual Assignment

• DBM 380 Week 2 Team Assignment Service Request

• Write a 750- to 1,050-word paper in which you
  complete the following
• Choose a database environment from the
  following
• o An appropriate database environment within
  your workplace (must be approved by your
  instructor)

• Begin working 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. The
  Entities and Attributes for Fleet Truck
  Maintenance can be found in the Huffman Trucking
  Virtual Organization.

6
DBM 380 Slingshot Academy / snaptutorial.com

• DBM 380 Week 3 DQ 1

• DBM 380 Week 3 DQ 2

• A motor vehicle maintenance center wants to
  improve its services by using database management
  systems (DBMS) and data mining. What tables are
  needed in such a database and how can it help
  improve their services?

• How do you select the primary key from the
  candidate keys? How do foreign keys relate to
  candidate keys? Provide examples from either your
  workplace or class assignments.

7
DBM 380 Slingshot Academy / snaptutorial.com

• DBM 380 Week 3 Individual Assignment ERD

• DBM 380 Week 3 Team Assignment Service Request

• The following assignment is based on the database
  environment chosen and discussed in the Week Two
  Individual Assignment.
• Use a Microsoft Visio diagram to create a
  detailed ERD using the data specificationsnoted
  in the Week Two Individual Assignment. Make any
  necessary changes provided in your facultys
  feedback.

• Continue working on Service Request SR-ht-003,
  due in Week Five, by completing Change Request 3.
• Create documentation that explains the process of
  creating the entity-relationship diagrams in the
  change request relative to this project

8
DBM 380 Slingshot Academy / snaptutorial.com

• DBM 380 Week 4 DQ 1

• DBM 380 Week 4 DQ 2

• In your own words, describe the nature and
  purpose of the normalization process. Provide
  some examples from sources other than the
  readings.

• In what business database environments is
  denormalization appropriate and why? What would
  denormalization specifically involve?

9
DBM 380 Slingshot Academy / snaptutorial.com

• DBM 380 Week 4 Individual Assignment

• DBM 380 Week 4 Team Assignment SR-ht-003

• The following assignment is based on the database
  environment chosen and created in the Week Three
  Individual Assignment.
• Your database project must meet the following
  assessment requirements

• Continue working on Service Request SR-ht-003,
  due in Week Five, by completing Change Requests 4
  and 5.
• Create documentation describing the principles
  and importance of normalization in relation to
  this project and the process by which this
  project was normalized.

10
DBM 380 Slingshot Academy / snaptutorial.com

• DBM 380 Week 5 DQ 1

• DBM 380 Week 5 DQ 2

• Describe the advantages and disadvantages of
  DBMS-provided security. Compare it to network or
  application security.

• Locate a hosted, distributed database service.
  Explore its features and talk about your
  experiences. In what situations would an
  organization consider using it?