Entity Relationship Diagram
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?
2. Write a 200- to 300-word short-answer response for the following:
• What are four types of cardinality constraints? Provide personal examples of each.
3. 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.
4. 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.
5. Write 200- to 300-word short-answer response to the following:
What is the difference between a database and a table?
6. Write 200- to 300-word short-answer response to the following:
What does it mean to say that a database displays both entity integrity and referential integrity?
7. Write 200- to 300-word short-answer response to the following:
Why are entity integrity and referential integrity important in a database?
8. Write 200- to 300-word short-answer response to the following:
What are the requirements that two relations must satisfy to be considered union-compatible?