DBM 380 Slingshot Academy / snaptutorial.com

1
DBM 380 Slingshot Academy snaptutorial
For more course Tutorials
www.snaptutorial.com
2
 DBM 380 Slingshot Academy snaptutorial
DBM 380 Week 1 DQ 1
DBM 380 Entire Course
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
DBM 380 Week 2 DQ 1 DBM 380 Week 2 DQ 2
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
DBM 380 Week 1 Individual Assignment DataBase
Paper
DBM 380 Week 1 DQ 2
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.
Summarize your paper by describing the database
systems in your workplace, identifying which
database systems and architecture they fall
under. Include 2 to 4 references.
4
 DBM 380 Slingshot Academy snaptutorial
DBM 380 Week 2 DQ 2
DBM 380 Week 2 DQ 1
Why it is necessary to choose appropriate data
types for each data column?
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 snaptutorial
DBM 380 Week 2 Team Assignment Service Request
SR-ht-003 Change Request 2
DBM 380 Week 2 Individual Assignment Database
Environment Paper
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) o
An Art Museum that needs to track the artwork,
artists, and locations where the art is displayed
or stored within the museum o Smith Consulting
(Virtual Organization) needs a database to
track their consulting staff, each staff members
skill sets, and what projects they are working on
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. Format your paper
consistent with APA guidelines. Submit a draft of
your teams documentation.
6
 DBM 380 Slingshot Academy snaptutorial
DBM 380 Week 3 DQ 2
DBM 380 Week 3 DQ 1
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.
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?
7
 DBM 380 Slingshot Academy snaptutorial
DBM 380 Week 3 Team Assignment Service Request
SR-ht-003 Change Request 3
DBM 380 Week 3 Individual Assignment ERD Creation
Project
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
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. Use a Microsoft
Access database to create the preliminary
database tables, columns with data types, primary
keys, and relationships.
8
 DBM 380 Slingshot Academy snaptutorial
DBM 380 Week 4 DQ 2
DBM 380 Week 4 DQ 1
In what business database environments is
denormalization appropriate and why? What would
denormalization specifically involve?
In your own words, describe the nature and
purpose of the normalization process. Provide
some examples from sources other than the
readings.
9
 DBM 380 Slingshot Academy snaptutorial
DBM 380 Week 4 Team Assignment SR-ht-003 Change
Request 4 and 5
DBM 380 Week 4 Individual Assignment
Normalization of the ERD
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.
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.
10
 DBM 380 Slingshot Academy snaptutorial
DBM 380 Week 5 DQ 2
DBM 380 Week 5 DQ 1
Locate a hosted, distributed database service.
Explore its features and talk about your
experiences. In what situations would an
organization consider using it?
Describe the advantages and disadvantages of
DBMS-provided security. Compare it to network or
application security.
11
 DBM 380 Slingshot Academy snaptutorial
DBM 380 Week 5 Team Assignment Service Request
SR-ht-003
DBM 380 Week 5 Team Assignment Service Request
SR-ht-003 Presentation
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 facilitator.
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. Submit your team presentation to your
facilitator.
12
 DBM 380 Slingshot Academy snaptutorial
For more course Tutorials
www.snaptutorial.com