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
WhatsApp us