UOP DBM380 All Weeks Discussions Latest

DBM380 Database Concepts

Week 1 Discussion

Why Relational Databases Make Sense for Big Data

Read "Big Data and RDBMS: Can They Coexist?" from Information Week. Note: This article introduces the concept of big data and discusses the types of database models that can be used to implement extremely large amounts of data. It also points out some important benefits of using a relational database management system (RDBMS).

What is a Database Model?

Read "What is a Database Model?" from Lucidchart. Note: This article describes several different database models, including the hierarchical, network, object-oriented, NoSQL, and relational database models. Using simple diagrams to show how the data in these different database models are organized, this article explains the data scenarios for which each database model is best suited.

Understanding Data Storage Models

Watch the section "Understanding Data Storage Models" of the Lynda.com® course "Database Foundations: Core Concepts" with Adam Wilbert.

Big Data: The Next New Thing?

Research and discuss some other vendors with this technology. How does the NoSQL model used in big data compare to the relational model? What types of businesses might benefit from using NoSQL?

 

DBM380 Database Concepts

Week 2 Discussion

Null Value

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?

 Many-To-Many Relationship

What are some issues when working with a many-to-many relationship? Provide some examples.

Database Designer

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

Data Types

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

 

 

DBM380 Database Concepts

Week 3 Discussion

DBMS and Data Mining

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?

Cardinality Constraints

What are four types of cardinality constraints? Provide personal examples of each.

Primary Key

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.

Overall Design

Under what circumstances would you break down an overall design to include individual user views? Provide examples from either your workplace or class assignments.

 

DBM380 Database Concepts

Week 4 Discussion

Normalization Process

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

Disadvantage of Normalizing

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.

Denormalization

In what business database environments is denormalization appropriate and why? What would denormalization specifically involve?

 

 

 

 

 

DBM380 Database Concepts

Week 5 Discussion

Database Administrator and Architect

Describe the differences between a database administrator and a database architect. How is your organization structured to handle the functions of these roles?

Database Service

Locate a hosted, distributed database service. Explore its features and talk about your experiences. In what situations would an organization consider using it?

DBMS

Describe the advantages and disadvantages of DBMS-provided security. Compare it to network or application security.

Database Recovery Process

Suppose that the database system within your organization has failed. Describe the database recovery process.