DBMS and Data Mining

What are the Primary elements of civilization
August 15, 2017
Social Problems
August 15, 2017
Show all

DBMS and Data Mining

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

Leave a Reply

Your email address will not be published. Required fields are marked *