week 3 dbm

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 services?

1

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.

1

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.

1

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.

1

Learning Team Instructions

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 documentation that explains the process of creating the entity-relationship diagrams in the change request relative to this project.

Format your paper consistent with APA guidelines.

Submit a draft of your team’s documentation

2

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

Use a Microsoft® Access® database to create the preliminary database tables, columns with data types, primary keys, and relationships.

12