DBM 380 Syllabus

  This document of DBM 380 Syllabus shows the following information: Course Description
This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration.
General Questions - General General Questions
 DBM/380 College of Information Systems Technology Database Concepts

 LATEST VERSION OF SYLLABUS
 DBM380 Week 1 Individual Assignment Database Design Paper

 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.


 Database Systems

 Write a 200- to 300-word short-answer response for the following:

 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?

 Limitations With Nonrelational Structures

 Write a 200- to 300-word short-answer response for the following:

 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 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:

 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 member’s 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.

 Null Value
 Write a 200- to 300-word short-answer response for the following:
 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?

 Data Types

 Write a 200- to 300-word short-answer response for the following:

 Why it is necessary to choose appropriate data types for each data column?
 DBM/380 Week 3 Individual Assignment ERD Creation Project

 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

Search for more tutorials here - https://bitly.com/12BtKch

Taking classes is important but you should also find some kind of activities you can do on campus. All colleges have a lot of clubs or teams you can join, but you could also volunteer for an association or even start your own club. You will be able to add this experience on your resume.