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