Entity Relationship Diagram

Week 3.   Discussion                                              

Entity Relationship Diagram

1. 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?

APA format requires a concluding paragraph which sums up the wholepaper.     

Format your paper consistent with APA guidelines.

The following assignment is based on the database environment chosen and discussed in the Week Two Individual Assignment.

Use a Microsoft® Visio® diagram to create a detailed ERD using the data specifications noted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty’s feedback.

Use a Microsoft® Access® database to create the preliminary database tables, columns with data types, primary keys, and relationships.

Note. The database environment chosen will be used in the Weeks Three and Four Individual Assignments.

Format your paper consistent