DBM 380 All Discussions

The Latest Version A+ Study Guide

**********************************************

DBM 380 All Discussions Link

https://hwsell.com/category/dbm-380-all-discussions/

**********************************************

DBM 380 Wk 1 Discussion – Comparing Relational Databases

Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students.

Due Thursday

Respond to the following in a minimum of 175 words:

RDBMS are currently very popular, and many are available in the marketplace. The application that specific RDBMS are most appropriate for depends on the application’s requirements in terms of functionality, speed, security, cost, ramp-up time (the time it takes staff responsible for installing, managing, and working with the software to become proficient at doing so), and the ability to integrate easily with other systems.

For this discussion, research at least one commercial and one open-source RDBMS such as Oracle®, MS SQL server, MySQL, MS Access, IBM DB2, and PostgreSQL. (You may choose others.)

Discuss what you find with your instructor and classmates.

Answer the following in your discussion:

• Which commercial database and which open source database did you select?
• What are the pros and cons of each database based on the criteria listed above?
• If you were to implement a new RDBMS for a new start-up company, which one would you choose? Why?
• What are some concerns of implementing a new database?

Due Monday

Respond to two of your peers, comparing the RDBMS you selected with those your peers selected. What are the similarities and differences between the two? Be constructive and professional in your responses.

DBM 380 Wk 2 Discussion – Databases vs. Spreadsheets/Relationships

Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students.

Due Thursday

Respond to one of the following in a minimum of 175 words:

Discuss the differences between storing data in a spreadsheet verses storing data in a database.

• In what business scenarios might one approach be superior to the other?
• What are the pros and cons of each approach?
• Why do you think many businesses today use both spreadsheets and databases to manage their data?

OR

Share at least one real-world example of the following types of data relationships:

• 1:1
• 1:M
• M:N (many-to-many)

Your example can be from work, school, a hobby, or daily life.

Discuss why you think making the distinction between these types of relationships is important for database designers. How does each of these types of relationships affect the complexity of storing and retrieving data? How do database architects apply the concepts of primary and foreign keys to each type of data relationship?

Due Monday

Then respond to two of your peers, comparing the example you presented with the one each of your peers presented. What are the similarities and differences between the two? Be constructive and professional in your responses.

DBM 380 Wk 3 Discussion – Populating Tables

Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students.

Due Thursday

Respond to the following in a minimum of 175 words:

After you create a relational table using the SQL statement CREATE TABLE, you can populate that table with data using the INSERT INTO statement.

Do you think it is more common that businesses populate databases table by table, one record at a time, using the INSERT INTO statement, or using some other method?

What happens if human error occurs and data is incorrectly populated into one or more tables?

How would a user of a database system know that an error occurred?

Due Monday

Reply to at least 2 of your classmates. Be constructive and professional in your responses.

DBM 380 Wk 4 Discussion – Updating Data

Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students.

Due Thursday

Respond to the following in a minimum of 175 words:

One of your duties as a data specialist at a local bank includes updating customer data. You were given training and a job aid to complete the task, but you accidentally updated the wrong records.

Your supervisor discovered this mistake when she walked by your desk seconds after you ran your SQL UPDATE statement against the database and noticed the message “113,253 records updated,” and she knew your task was to update only 10 records. Your update criteria must have been incorrect.

Discuss the most important difference between updating and selecting data in terms of data integrity.

• How can you know that you updated data correctly?
• How can you prevent making a mistake when you update data?
• How do you discover a mistake after you have made one?
• If you discover you made a mistake, what are some ways to correct it?

Due Monday

Reply to at least 2 of your classmates. Be constructive and professional in your responses.

DBM 380 Wk 5 Discussion – Backing Up Data to the Cloud

Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students.

Due Thursday

Respond to the following in a minimum of 175 words:

Research and discuss the possible security benefits and drawbacks of migrating a database to the cloud. What types of businesses might benefit most from backing up data to the cloud? 

Due Monday

Respond to two of your peers. For each of the business scenarios a peer lists, what criteria do you think a business might use to weigh the security risks against the ease of administration? Be constructive and professional in your responses.