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.