Test: Section 2 Quiz
Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct
answer.
Section 2 Quiz
(Answer all questions in this section)
1. A unique identifier must be made up of more than one attribute. True
or False? Mark for Review
(1) Points
True
False (*)
Correct
2. People are not born with “numbers”, but a lot of systems assign
student numbers, customer IDs, etc. A shoe has a color, a size, a Mark for Review
style, but may not have a descriptive “number". So, to be able to (1) Points
uniquely and efficiently identify one instance of the entity SHOE, a/an
______________ UID can be created.
Structured
Unrealistic
Artificial (*)
Identification
Correct
3. A _____ is a type of database that stores data in a single table.
Mark for Review
(1) Points
Hierarchical
Relational
Network
Flat file (*)
Incorrect. Refer to Section 2 Lesson 1.
4. A table must have a primary key. True or False?
Mark for Review
(1) Points
True (*)
False
Correct
5. To identify an attribute as part of a unique identifier on an ER
diagram, the # symbol goes in front of it. True or False? Mark for Review
(1) Points
True (*)
False
Correct
Section 2 Quiz
(Answer all questions in this section)
6. Which of the following statements about attributes are true?
(Choose Two) Mark for Review
(1) Points
(Choose all correct answers)
They must be single valued unless they belong to more than
one entity.
They are the primary container for data.
They are often adjectives. (*)
They describe, qualify, quantify, classify, or specify an entity.
(*)
Correct
7. Which of the attributes is a volatile attribute?
Mark for Review
(1) Points
Eye color
Date of birth
Age (*)
Race
Correct
8. An ERD is an example of a ______ Model.
Mark for Review
(1) Points
Network
Data Integrity
Conceptual (*)
Physical
Correct
9. The logical model determines relationship optionality and cardinality
Mark for Review
(1) Points
True (*)
False
Incorrect. Refer to Section 2 Lesson 2.
10. Data modeling is performed for the following reasons: (Choose Two)
Mark for Review
(1) Points
(Choose all correct answers)
The ERD becomes a blueprint for designing the actual system.
(*)
We draw an ERD solely to please the users; once completed,
the ERD is never referred to again as it serves no purpose in
the real world.
We do not need datamodels; we can just start coding right
away.
It helps discussions and reviews. (*)
Correct
Section 2 Quiz
(Answer all questions in this section)
11. Which of the following is not a goal of ER modeling:
Mark for Review
(1) Points
It is acceptable to include information that is derivable. (*)
Locate information in a logical manner
Capture all required information.
Ensure information appears only once.
Correct
12. Which of the following statements is true regarding Implementation-
Free logical models? Mark for Review
(1) Points
The model does not need to implemented on a DBMS.
The model changes depending on the relational database
software being used
The model changes depending on operating system that is
being used.
The model stays the same regardless of the DBMS or operating
system used. (*)
Correct
13. In a business that sells pet food, choose the best relationship name
between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Mark for Review
Two) (1) Points
(Choose all correct answers)
Each FOOD TYPE may be given to one or more ANIMALs. (*)
Each FOOD TYPE must be suitable for one or more ANIMALs.
(*)
Each FOOD TYPE may be made from one or more ANIMALs.
Each ANIMAL must be the seller of one or more FOOD TYPES.
Correct
14. Matrix Diagrams are used to verify that all ____________ have been
identified for an ERD. Mark for Review
(1) Points
attributes
entities
keys
relationships (*)
Correct
15. In an ERD, optionality is depicted using __________.
Mark for Review
(1) Points
names of relationships
soft boxes
solid or dashed lines (*)
single toe or crows foot
Correct
