The ER model refers to a specific table row as an entity occurrence.
True or False - Answers True
Connectivities and cardinalities are established by business rules.
True or False - Answers True
An Entity-Relationship Model (ERM) is dependent on the database type.
True or False - Answers False
The ER diagram represents the conceptual database as viewed by the end user.
True or False - Answers True
A composite identifier is a primary key composed of more than one attribute.
True or False - Answers True
Cardinality expresses the minimum and maximum number of entity occurrences associated with one
occurrence of the related entity.
True or False - Answers True
Relationships operate only in one direction.
True or False - Answers False
A ____ attribute is one that cannot be subdivided.
a. composite
b. simple
c. single-valued
d. multivalued - Answers Simple
The DBMS can easily handle multivalued attributes.
True or False - Answers False
Attributes have a domain that specifies the data type of the attribute.
True or False - Answers False
Derived attributes are stored in a special database table.
True or False - Answers False
The set of possible values for an attribute is a ____.
a. domain
b. range
c. set
d. key - Answers Domain
Ideally, a primary key is composed of several attributes.
True or False - Answers False
The Crow's foot symbol with two parallel lines indicates ____ cardinality.
a. (0,N)
b. (1,N)
c. (1,1)
d. (0,1) - Answers (1,1)
An entity is said to be __________________ if it can exist in the database only when it is associated
with another related entity occurrence.
a. existence-dependent
b. existence-independent
c. strong
d. weak - Answers Existence-dependent