DBM 380 aid Learn/dbm380aid.com

1
DBM 380 aid Learn/dbm380aid.com

• FOR MORE CLASSES VISIT
• www.dbm380aid.com

2
DBM 380 Entire Course (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) DBM 380 Week 2 DQ 1 (New)
  DBM 380 Week 2 DQ 2 (New) DBM 380 Week 3 Team
  Assignment Service Request SR-ht-003 Change
  Request 3 (New) DBM 380 Week 3 Individual
  Assignment ERD Creation Project (New) DBM 380
  Week 3 DQ 1 (New) DBM 380 Week 3 DQ 2 (New) DBM
  380 Week 4 Team Assignment SR-ht-003 Change
  Request 4 and 5 (New) DBM 380 Week 4 Individual
  Assignment Normalization of the ERD (New) DBM 380
  Week 4 DQ 1 (New) DBM 380 Week 4 DQ 2 (New) DBM
  380 Week 5 Team Assignment Service Request
  SR-ht-003 (New) DBM 380 Week 5 Team Assignment
  Service Request SR-ht-003 Presentation (New) DBM
  380 Week 5 DQ 1 (New) DBM 380 Week 5 DQ 2 (New)

3
DBM 380 Week 1 DQ 1 (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?

4
DBM 380 Week 1 DQ 2 (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?

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

• 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. Write a 1- to 2-page
  memo in which you complete the following
  Choose a database application from the following
  o An appropriate database environment within your
  workplace. o An Art Museum that needs to track
  the artwork, artists, and locations where the art
  is displayed or stored within the museum

6
DBM 380 Week 1 Individual Assignment DataBase
Paper (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. 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. Format your paper consistent with APA
  guidelines.

7
DBM 380 Week 2 DQ 1 (New)

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

8
DBM 380 Week 2 DQ 2 (New)

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

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

• 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. Use a 2-page memo to document
  your logical design including the process you
  went through. Discuss the process you went
  through to select the appropriate data types,
  primary and foreign keys, and other constraints
  that are necessary to maintain the integrity of
  the database. Create a detailed ERD using the
  data specifications from the logical design. Use
  Microsoft Visio or another tool to create this
  diagram.

10
DBM 380 Week 2 Individual Assignment Database
Environment Paper (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) needs a database to track their
  consulting staff, each staff members skill sets,
  and what projects they are working on Analyze the
  database environment. Describe the problems and
  constraints. Describe the objectives of the
  database environment. Describe the scope and
  boundaries. List the data specifications (must
  include a minimum of three entities with
  attributes). Include 3 to 5 references. Format
  your paper consistent with APA guidelines. Note.
  The database environment chosen will be used in
  the Weeks Three and Four Individual Assignments.

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

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

12
DBM 380 Week 3 DQ 1 (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?

13
DBM 380 Week 3 DQ 2 (New)

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

14
DBM 380 Week 3 Individual Assignment Database
Normalization (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. Provide a logical design of the
  database. As a part of the design, normalize the
  database to the 3NF Use Microsoft Visio or
  another tool to create this diagram to normalize
  the ERD to third normal form (3NF). Submit the
  ERD to the appropriate Assignment Files tab.

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

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

16
DBM 380 Week 3 Team Assignment Service Request
SR-ht-003 Change Request 3 (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

17
DBM 380 Week 4 DQ 1 (New)

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

18
DBM 380 Week 4 Individual Assignment Database
Creation (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. Use a relational database
  software application to develop a database
  implementing the logical design into a physical
  design. Use an Oracle database to create the
  normalized physical database including tables,
  columns with data types, primary keys,
  constraints, etc. Create a minimum of ten rows
  of test data in each table. Submit an .sql file
  with the scripts needed to create tables with
  keys and to insert test rows, etc., into the
  tables and submit to the Assignment Files tab.

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

• 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. Provide an entity relationship diagram.
  Normalize the database. Generate and provide test
  data. Use a Microsoft Visio diagram to
  normalize the ERD to

20
DBM 380 Week 4 Team Assignment SR-ht-003 Change
Request 4 and 5 (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.

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

• 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. Two
  SQL Statements that return a subset of columns
  and a subset of rows using the WHERE clause.
  Two SQL Statements that join two or more tables
  in one query. Look for primary and foreign keys
  to help you determine join points. Use the JOIN
  clause as a part of your queries. Submit an .sql
  file with the scripts needed to create the
  required queries and submit the file using the
  Assignment Files tab.

22
DBM 380 aid Learn/dbm380aid.com

• FOR MORE CLASSES VISIT
• www.dbm380aid.com