DBM 380 Slingshot Academy / dbm380aid.com

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

• DBM 380 Entire Course (New)

• DBM 380 Week 1 DQ 1 (New)

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

• 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 / dbm380aid.com

• DBM 380 Week 1 DQ 2 (New)

• DBM 380 Week 1 Individual Assignment Database
  Environment Proposal (NEW)

• 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?

• DBM 380 Week 1 ASSIGNMENT Individual Database
  Environment Proposal As one of the program
  outcomes for the Bachelor of Science in
  Information Technology program, students must
  design and develop a database using professional
  principles and standards.

4
DBM 380 Slingshot Academy / dbm380aid.com

• DBM 380 Week 1 Individual Assignment DataBase
  Paper (New)

• DBM 380 Week 2 DQ 1 (New)

• 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.

• 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?

5
DBM 380 Slingshot Academy / dbm380aid.com

• DBM 380 Week 2 DQ 2 (New)

• DBM 380 Week 2 Individual Assignment Database
  Design and ERD Creation (NEW)

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

• DBM 380 Week 2 ASSIGNMENT Individual Database
  Design and ERD Creation The following assignment
  is based on the database environment proposed in
  the Week One Individual Assignment. Perform a
  logical design on the proposed database
  environment without going through the full
  normalization process. Include the identification
  of all entities and attributes associated with
  the environment.

6
DBM 380 Slingshot Academy / dbm380aid.com

• DBM 380 Week 2 Individual Assignment Database
  Environment Paper (New)

• DBM 380 Week 2 Team Assignment Service Request
  SR-ht-003 Change Request 2 (New)

• Write a 750- to 1,050-word paper in which you
  complete the following Choose a database
  environment from the following An appropriate
  database environment within your workplace (must
  be approved by your instructor) An Art Museum
  that needs to track the artwork, artists, and
  locations where the art is displayed or stored
  within the museum Smith Consulting (Virtual
  Organization)

• 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.

7
DBM 380 Slingshot Academy / dbm380aid.com

• DBM 380 Week 3 DQ 1 (New)

• DBM 380 Week 3 DQ 2 (New)

• 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.

8
DBM 380 Slingshot Academy / dbm380aid.com

• DBM 380 Week 3 Individual Assignment Database
  Normalization (NEW)

• DBM 380 Week 3 Individual Assignment ERD
  Creation Project (New)

• DBM 380 Week 3 ASSIGNMENT Individual Database
  Normalization The following assignment is based
  on the database environment designed in the Week
  Two Individual Assignment. Your database project
  must meet the following assessment requirements
  Design a database using professional principles
  and standards

• 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.

9
DBM 380 Slingshot Academy / dbm380aid.com

• DBM 380 Week 3 Team Assignment Service Request
  SR-ht-003 Change Request 3 (New)

• DBM 380 Week 4 DQ 1 (New)

• 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. Format
  your paper consistent with APA guidelines. Submit
  a draft of your teams documentation

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

10
DBM 380 Slingshot Academy / dbm380aid.com

• DBM 380 Week 4 Individual Assignment Database
  Creation (NEW)

• DBM 380 Week 4 Individual Assignment
  Normalization of the ERD (New)

• DBM 380 Week 4 ASSIGNMENT Individual Database
  Creation The following assignment is based on the
  database environment designed in the Week Three
  Individual Assignment. Your database project must
  meet the following assessment requirements
  Create a database using professional principles
  and standards

• 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
  Design and develop a database using professional
  principles and standards. Provide a logical and
  physical design of the database. Use relational
  database software application to develop database.

11
DBM 380 Slingshot Academy / dbm380aid.com

• DBM 380 Week 4 Team Assignment SR-ht-003 Change
  Request 4 and 5 (New)

• DBM 380 Week 5 Individual Assignment SQL Queries
  (NEW)

• 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. Format your paper
  consistent with APA guidelines. Submit a draft of
  your teams documentation to the Assignments link.

• DBM 380 Week 5 ASSIGNMENT Individual SQL Queries
  The following assignment is based on the database
  environment created in the Week Four Individual
  Assignment. Design and develop the below queries
  using professional principles and standards A
  set of SQL Statements that returns all rows and
  all data for each table in your database.

12
DBM 380 Slingshot Academy / dbm380aid.com
For More Tutorials
www.dbm380aid.com