DBM 380 Entire Course

DBM 380 Entire Course

DBM 380 Week 1 DQs
DBM 380 Week 2 DQs
DBM 380 Week 3 DQs
DBM 380 Week 4 DQs
DBM 380 Week 5 DQs

DBM 380 Week 1 Individual: Database Design Paper
Write a 500-to-700-word paper in which you do the following:
• Explain what database systems are and how they are used.
• Define "database architecture." This term could potentially have multiple definitions, so pick one that makes sense to you based on your research and readings. Consider Microsoft Access , Microsoft SQL Server , Oracle , and IBM DB2 software as examples you could use to help explain your definition of database architecture.
• Describe one significant database system in your workplace by covering its purpose (why it exists), function (what it does), and architecture (using your definition from the previous part of the paper). If you do not have a workplace or do not have any database system in your workplace, then briefly describe some workplace (perhaps a store or business you frequent) and a database you believe would be in use there.
Include 2 to 4 references.
Format your paper consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.

Here is the rubric I will use to grade your assignment:
Element Points
Explain what database systems are and how they are used 25
Define database architecture 25
Describe the database systems in your workplace 25
Effective style and mechanics 25

DBM 380 Week 1 Learning Team Charter
Please submit a charter for your Learning Team. The charter will govern how your team interacts over the course of the term.

You can find a charter template in the LT Toolkit under the Library tab. A direct link is here: https://assetscdn.students.uophx.edu/content/dam/faculty/LearningTeamCharter.doc

DBM 380 Week 2 Individual: Database Environment Paper
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.

First, you must choose a database environment from the following choices:
• A college that needs to track courses, course sections, and professors teach the sections in order to publish a course schedule
• A retail business that needs to track store locations, shifts, and the employees assigned to each shift
• An appropriate database environment within your workplace (must be approved by your instructor - send me a one-paragraph email describing the environment and its purpose)
You may NOT use examples involving:
• An art museum that needs to track artists, artwork, and locations
• A consulting organization that needs to track staff, skill sets, and projects
Once you have chosen your database environment, write a 750- to 1,050-word paper in which you address these elements:
• Analyze the database environment, including its objectives (why will it be built?), its boundaries (what is in and out of scope?), its constraints (what rules must it follow?), and any challenges that will accompany its construction.
• Describe at least 3 entities (which will eventually become tables in a database)
• List attributes for each of these entities
Note that the database environment chosen will be used to build a working database in your individual assignments for weeks 3 and 4. You are only required to create three entities, which would be a very small database. As such, you'll want to choose a very focused business problem or process. You will need to look at only a slice of an organization - don't feel as though you have to model an entire business.
The part where you describe the entities and attributes is the most important, as it will be the basis for future assignments. Each entity should correspond to some thing you are trying to describe, and will become a table in the database you create in weeks 3 and 4. The attributes are the descriptive properties of the entity, and will become the columns in your tables.
Below is an example of describing three entities and their attributes. Remember that you are not allowed to use this particular topic for your assignment, but it will give you a feel for what is required.
An art gallery wants to create a database to track works of art in their collection. They will track information about artists, the pieces of art they create, and the locations in which these artworks are kept.
For each piece of art, they want to capture a unique identification number, the name of the piece, the medium used to create it, and the date the work was acquired. Every piece of art will be linked to a single artist.
For each artist, they want to track an artist identification number, full name, birthdate, and home country. An artist can create multiple works.
Each piece of art will be kept in some location within the museum. We will only record the current location. For each location, we want to track the location name (which uniquely identifies the location), whether the location is open t the
location. Multiple pieces of art can share the same location.
Click the Assignment Files tab to submit your assignment.

Here is the rubric I will use to grade this assigment:
Element Points
Analysis of the database environment, including its objectives, problems, boundaries, and constraints 50
Description of at least 3 separate entities (tables) 20
List attributes for each entity 30

DBM 380 Week 2 Learning Team: Service Request SR-ht-003: Change Request 2
Begin working on Service Request SR-ht-003 by completing Change Request #2. (See here for a description of the Huffman Trucking SRs and associated change requests.)
You will be building an Access database that matches the entity specifications found here. That is, you will be building a table for each of the entities listed in the document, and the columns in each table will match the attributes from the document.

You may find that the entities / attributes are not optimally designed. Please just implement them as they are given in the document, without changes. Each table must have a reasonable primary key, and each column must have a reasonable data type and size chosen. The Skillsoft Access exercises listed in the syllabus will give you the skills you need to do this.

You don't need to add data to the tables or create relationships between tables. Those tasks will be part of upcoming weeks.
Click the Assignment Files tab to submit your assignment.

Here is the rubric I will use to grade this assignment:
Element Points
All required tables created 25
All required attributes present 25
Reasonable data type chosen for each attribute 25
Each table has a reasonable primary key 25


DBM 380 Week 3 Individual: 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 specifications noted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty feedback.
Use a Microsoft Access database to create the preliminary database tables, columns with data types, primary keys, and relationships.
I have posted two short YouTube videos that show me completing a sample version of the assignment in the Toolwire Student Desktop environment. These should give you a good idea of what is expected.

Creating the ERD in Visio: https://www.youtube.com/watch?v=FZYG49-Hylk
Creating the database in Access: https://www.youtube.com/watch?v=sUjmplthSNQ
Click the Assignment Files tab to submit your assignment.

Here is the rubric I will be using for this assignment:
Element Points
Creates detailed ERD using Visio based on
week 2 database description - ERD includes
entities, attributes, primary keys, and foreign
keys. 40
Create database based on ERD - includes
tables, columns, primary keys, and foreign key
relationships with referential integrity enforced.
Choose the appropriate data types for your
columns (not everything should be text). 60


DBM 380 Week 3 Learning Team: Service Request SR-ht-003: Change Request 3
Continue working on Service Request SR-ht-003, due in Week Five, by completing Change Request 3.

Create relationships in your Access database from week 2. Make sure that you enforce referential integrity in your relationships. Put in 10 records of semi-realistic data per table, but don't feel as though you need to research trucking concepts for this part. If you aren't sure what to put in a field, such as FOB, just put something in there - the goal here isn't to see if you can come up with realistic trucking data.
Try to make up reasonable relationships. You may find that the entities / attributes are not optimally designed. Any reasonable set of relationships will be acceptable, as you have little information to go on here. Try to avoid making connections that are obviously wrong (e.g., a date linked to a number column, or a person's name linked to a VIN), but otherwise, you will be given wide latitude here. Try not to leave any tables stranded - ideally, every table should have one or more relationships, and all tables should be worked into the same web of relationships.
Click the Assignment Files tab to submit your assignment.

Here is the rubric I will use for this assignment:
Element Points
10 records of realistic data per table 50
Reasonable relationships established between tables 50


DBM 380 Week 4 Individual: Normalization of the ERD
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 third normal form (3NF).
Use the Microsoft Access database created in Week Three to create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables.
Note. Only the Microsoft Visio diagram must be normalized to the 3NF. The 3NF is not required for a Microsoft Access database.
Submit the ERD and final database to the appropriate Assignment link.
Click the Assignment Files tab to submit your assignment.


DBM 380 Week 4 Learning Team: SR-ht-003: Change Request 4 and 5
Continue working on Service Request SR-ht-003, due in Week Five, by completing Change Requests 4 and 5.
Change Request #4:
Create an input form in Access for each of the tables in your database. Your form should allow you to create, read, update, and delete data for the table. You need not worry about fancy design for these - the output of the Forms wizard will do the trick here - just make sure that each form can do all four of the above operations (create, read, update, delete).
Change Request #5:
Create 5 queries for your database. At least two of the queries should join two or more tables together. At least three of the queries should filter the rows (excluding these from the results) from one or more of the tables used in the query. These two requirements (joins and filtering) need not be satisfied by separate sets of queries - a single query could potentially count toward both requirements. Try to pick queries that seem useful or business relevant - none of your queries should be just a simple SELECT of all the columns and rows in a table.
Click the Assignment Files tab to submit your assignment. (All you will be submitting is your Access database with the additions described above.)

Here is the rubric I will use for this assignment:
Element Points
Each table has a form that supports reading and editing 40
At least 5 queries created with at least 2 using joins and 3 using filtering 60


DBM 380 Week 5 Learning Team Evaluation
Please submit an evaluation of your Learning Team. The template can be found in the Learning Team Toolkit under the Library tab. A direct link is here: https://assetscdn.students.uophx.edu/content/dam/faculty/LearningTeamEvaluation.doc

DBM 380 Week 5 Learning Team: Service Request SR-ht-003
Finalize the project work for SR-ht-003 by completing the base request (creating an ERD) to match the database you have been developing.
You should create your ERD in Visio. Make sure that your ERD has:
• An entity for each table in your database
• Attributes that match the tables in your database
• Entity identifiers (primary keys) defined for each entity
• Relationships (foreign keys) between entities
In short, put your database structure into an ERD diagram containing the elements listed above.

Click the Assignment Files tab to submit your assignment.

Here is the rubric I will use to grade this assignment:
Element Points
All relevant entities are modeled 30
Attributes for each entity are modeled 30
Each entity has a primary key indicated 20
Meaningful relationships have been added 20


DBM 380 Week 5 Learning Team: Service Request SR-ht-003 Presentation and Documentation
Prepare the following documentation for your project:
• A Word document of roughly one page (but you can go longer if you like) which describes any challenges you faced when using the entities and attributes document to build the ERD and the database tables. Explain how you handled those challenges (what you decided to do and why). Challenges would include things like ambiguities in which relationships should be created.
• A Word document of roughly two pages (but you can go longer if you like) that discuss how normalized the given set of entities and attributes appears to be, and describe changes your team would make to the database design if you had the latitude to do so.
• A PowerPoint presentation of 3 to 5 slides which describe the principles of database management that drove your project work, and summarize any important observations or recommendations that your team would like to make.
Click the Assignment Files tab to submit your assignment.

Here is the rubric I will use to grade this assignment:
Element Points
Describes challenges using entities and attributes document 30
Describes normalization of database and possible changes 30
Presentation sums up effort and adds additional commentary 40



DBM 380 Week 1 DQs
Supporting Activity: 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?
Supporting Activity: Unstructured and Structured Data
Write a 200- to 300-word short-answer response for the following:
• Reflect on the textbook readings. Use examples to compare and contrast unstructured and structured data. Which type is more prevalent in a typical business environment?
Supporting Activity: 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 DQs
Supporting Activity 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?
Supporting Activity: Many-To-Many Relationship
Write a 200- to 300-word short-answer response for the following:
• What are some issues when working with a many-to-many relationship? Provide some examples.
Supporting Activity: Database Designer
Write a 200 - to 300-word short-answer response for the following:
• How must a database designer balance the time to complete data modeling steps with the benefits the data modeling process offers in creating a database? Consider examples from your work place and class assignments.
Supporting Activity: 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 DQs
Supporting Activity: DBMS and Data Mining
Write a 200- to 300-word short-answer response for the following:
• 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 2.2, 3.2services?
Supporting Activity: Cardinality Constraints
Write a 200- to 300-word short-answer response for the following:
• What are four types of cardinality constraints? Provide personal examples of each.
Note. The examples from the textbooks cannot be used for this question.
Supporting Activity: Primary Key
Write a 200- to 300-word short-answer response for the following:
• 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.
Supporting Activity: Overall Design
Write a 200- to 300-word short-answer response for the following:
• Under what circumstances would you break down an overall design to include individual user views? Provide examples from either your workplace or class assignments.

DBM 380 Week 4 DQs
Supporting Activity; Normalization Process
Write a 200- to 300-word short-answer response for the following:
• In your own words, describe the nature and purpose of the normalization process. Provide some examples from sources other than the readings
Supporting Activity: Disadvantage of Normalizing
Write a 200- to 300-word short-answer response for the following:
• Discuss the disadvantages of normalizing a database to a high degree of normalization. Should there be a definite rule on when to stop normalizing? Provide some examples from sources other than the readings.
Supporting Activity: Denormalization
Write a 200- to 300-word short-answer response for the following:
• In what business database environments is denormalization appropriate and why? What would denormalization specifically involve?

DBM 380 Week 5 DQs
Supporting Activity: Database Administrator and Architect
Write a 200- to 300-word short-answer response for the following:
• Describe the differences between a database administrator and a database architect. How is your organization structured to handle the functions of these roles?
Supporting Activity: Database Service
Write a 200- to 300-word short-answer response for the following:
• Locate a hosted, distributed database service. Explore its features and talk about your experiences. In what situations would an organization consider using it?
Supporting Activity: DBMS
Write a 200- to 300-word short-answer response for the following:
• Describe the advantages and disadvantages of DBMS-provided security. Compare it to network or application security.
Supporting Activity: Database Recovery Process
Write a 200- to 300-word short-answer response for the following:
• Suppose that the database system within your organization has failed. Describe the database recovery process
Powered by