Entity Relationship Diagram
ludyh6
dbm_380___database_concepts_wk3.docxWeek 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 whole paper.
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 with APA guidelines
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 br
eak down an overall design to include
individual user views? Provide examples from either your workplace or class assignments.
5.
Write
200
-
to 3
00
-
word short
-
answer response to the following:
What is the difference between a database and a table?
6.
Write
200
-
to 3
00
-
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 3
00
-
word short
-
answer response to the following:
Why are entity integrity and referential integrity important in a database?
8
.
Write
200
-
to 3
00
-
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 whole
paper
.
Format your paper consistent with APA guidelines.
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 whole paper.
Format your paper consistent with APA guidelines.
