1) Write a 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.
2) Write a 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.
3) Write a short-answer response for the following:
What are four types of cardinality constraints? Provide personal examples of each.
4) Write a 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 2.2, 3.2services?