ERD Exam 1 Questions and Answers
The database needs to capture a patients first name, last name, middle name, city, state, street
address, zip code, age, and their phone numbers - ANSWERS -Age
Word problem:
Students may own several vehicles and a vehicle may be owned by only one student.
Question:
Which of the following is an appropriate cardinality to place on the vehicle entity? (I.E. Students
owns how many vehicles) Choose all that apply. - ANSWERS -|<
>|
In the context of an Entity Relationship Diagram (ERD), vendors, books, and authors would most
likely be an example of which of the following? - ANSWERS -Entities
In the context of an Entity Relationship Diagram (ERD), _______ specify how many instances are
associated between one entity and another entity. - ANSWERS -Cardinalities
True or False: The way to create a many-to-many relationship in a database is to take the
primary key from the table on the mandatory side (one side) of the relationship and place it as
the foreign key in the table on the many side. - ANSWERS -False
In the context of an Entity Relationship Diagram (ERD), a book title, an author's name, and a
vendor ID are all examples of: - ANSWERS -Attributes
Many to Many Relationship - Associative Entity - ANSWERS -Rule 4
Nouns and Verbs - ANSWERS -Rule 1
The database needs to capture a patients first name, last name, middle name, city, state, street
address, zip code, age, and their phone numbers - ANSWERS -Age
Word problem:
Students may own several vehicles and a vehicle may be owned by only one student.
Question:
Which of the following is an appropriate cardinality to place on the vehicle entity? (I.E. Students
owns how many vehicles) Choose all that apply. - ANSWERS -|<
>|
In the context of an Entity Relationship Diagram (ERD), vendors, books, and authors would most
likely be an example of which of the following? - ANSWERS -Entities
In the context of an Entity Relationship Diagram (ERD), _______ specify how many instances are
associated between one entity and another entity. - ANSWERS -Cardinalities
True or False: The way to create a many-to-many relationship in a database is to take the
primary key from the table on the mandatory side (one side) of the relationship and place it as
the foreign key in the table on the many side. - ANSWERS -False
In the context of an Entity Relationship Diagram (ERD), a book title, an author's name, and a
vendor ID are all examples of: - ANSWERS -Attributes
Many to Many Relationship - Associative Entity - ANSWERS -Rule 4
Nouns and Verbs - ANSWERS -Rule 1
