short-answer response for the following

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.

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.

Write a 200- to 300-word short-answer response for the following:

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

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 2.2, 3.2services?