7) Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and the associations among them?
A) entity-relationship (E-R) data model
B) Unified Modeling Language (UML)
C) object-relational model
D) semantic data model
8) Which of the following is true of entities?
A) Entities have an identifier whose value is associated with every entity in the data model.
B) Entities can only represent a logical construct or transaction, not a physical object.
C) The characteristics of entities are described by attributes.
D) The names of entities are always plural.
9) ________ describe the characteristics of entities.
A) Attributes
B) Dependencies
C) Cardinalities
D) Alternatives
10) ________ are attributes whose values are associated with one, and only one, entity instance.
A) Cardinalities
B) Descriptors
C) Dependencies
D) Identifiers
11) Which of the following is true of an entity-relationship (E-R) diagram?
A) Each entity is shown in separate rectangles.
B) Many-to-many relationships are generally denoted by N:N.
C) A crow's foot represents a 1:N relationship between two entities.
D) Crow's foot is a shorthand representation for a single relationship between entities.
12) In a university, each adviser can advise multiple students, but each student can have only one adviser. In a data model, this can be best represented by ________.
A) N:M relationships
B) N:N relationships
C) 1:N relationships
D) 1:1 relationship
13) Which of the following notations signifies that an adviser can be related to many students and that a student can be related to many advisers?
A) 1:N
B) N:M
C) N:1
D) N:N
14) In an organization, the administrative department consists of one clerk whose sole responsibility is the management of various administrative functions. The notation that accurately indicates this relationship is ________.
A) 1:N
B) N:N
C) 1:1
D) N:M
15) The little lines in an entity-relationship (E-R) diagram used as shorthand to represent multiple relationships are referred to as a(n) ________.
A) crow's foot
B) identifier
C) attribute
D) cardinality line
16) Maximum cardinality in an entity-relationship (E-R) diagram refers to the maximum number of ________.
A) normalizations possible in a diagram
B) entities that can be involved in a relationship
C) identifiers possible in a particular diagram
D) attributes associated with an entity