Paper instructions:

Write 200 to 300-word short-answer responses 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?

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

· Note. The examples from the textbooks cannot be used for this question.

· 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.

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