Question 1

Software vendors have adopted the Chen representation because of its compact representation.

Accepted Answer

A) True 
 B)False

Question 2

Ideally, a primary key is composed of several attributes.

Accepted Answer

A) True 
 B)False

Question 3

The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)

Accepted Answer

A)  CRS_CODE 
B)  CLASS_SECTION 
C)  CRS_CODE and CLASS_SECTION 
D)  There is no primary key

Question 4

The Crow's Foot model is less implementation-oriented than the Chen model.

Accepted Answer

A) True 
 B)False

Question 5

In Chen notation, there is no way to represent cardinality.

Accepted Answer

A) True 
 B)False

Question 6

A ____ should be a derived attribute.

Accepted Answer

A)  person's name 
B)  person's age 
C)  person's social security number 
D)  person's phone number

Question 7

What is a weak relationship? Provide an example.

Accepted Answer

The answer of What is a weak relationship? Provide an...

Question 8

A relationship is an association between ____.

Accepted Answer

A)  objects 
B)  entities 
C)  databases 
D)  fields

Question 9

A ____ attribute is one that cannot be subdivided.

Accepted Answer

A)  composite 
B)  simple 
C)  single-valued 
D)  multivalued

Question 10

A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

Accepted Answer

A) True 
 B)False

Question 11

A ____ attribute can have only one value.

Accepted Answer

A)  composite 
B)  simple 
C)  single-valued 
D)  multivalued

Question 12

Participation is ____________________ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

Accepted Answer

The answer of Participation is ____________________ if one entity occurrence...

Question 13

A relationship is identified by a name that describes the relationship.

Accepted Answer

A) True 
 B)False

Question 14

A weak entity must be ____________________-dependent.

Accepted Answer

The answer of A weak entity must be ____________________-dependent....

Question 15

A(n) ____ entity is composed of the primary keys of each of the entities to be connected.

Accepted Answer

A)  associative 
B)  recursive 
C)  unary 
D)  binary

Question 16

A derived attribute ____.

Accepted Answer

A)  must be stored physically within the database 
B)  need not be physically stored within the database 
C)  has many values 
D)  must be based on the value of three or more attributes

Question 17

In both the Chen and Crow's Foot models, an entity is represented with a rectangle containing the entity's name.

Accepted Answer

A) True 
 B)False

Question 18

Attributes are types of entities.

Accepted Answer

A) True 
 B)False

Question 19

Storing ____________________ attributes requires constant maintenance.

Accepted Answer

The answer of Storing ____________________ attributes requires constant maintenance....

Question 20

A ____ relationship exists when three entities are associated.

Accepted Answer

A)  unary 
B)  binary 
C)  ternary 
D)  weak

Exam 7: Data Modeling With Entity Relationship Diagrams

Software vendors have adopted the Chen representation because of its compact representation.

Ideally, a primary key is composed of several attributes.

The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)

The Crow's Foot model is less implementation-oriented than the Chen model.

In Chen notation, there is no way to represent cardinality.

A ____ should be a derived attribute.

What is a weak relationship? Provide an example.

A relationship is an association between ____.

A ____ attribute is one that cannot be subdivided.

A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

A ____ attribute can have only one value.

Participation is ____________________ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

A relationship is identified by a name that describes the relationship.

A weak entity must be ____________________-dependent.

A(n) ____ entity is composed of the primary keys of each of the entities to be connected.

A derived attribute ____.

In both the Chen and Crow's Foot models, an entity is represented with a rectangle containing the entity's name.

Attributes are types of entities.

Storing ____________________ attributes requires constant maintenance.

A ____ relationship exists when three entities are associated.