Question 1

A mutually exclusive relationship is one in which:

Accepted Answer

A)   an entity instance can participate in many different relationships.
B)   an entity instance can participate in only one of several alternative relationships.
C)   an entity instance cannot participate in a relationship with another entity instance.
D)   an entity instance bridges other XML documents.

Question 2

In an E-R diagram, there are/is ________ business rule(s)  for every relationship.

Accepted Answer

A)   two
B)   three
C)   one
D)   zero

Question 3

In the figure shown below, which of the following is true?

Accepted Answer

A)   A person can marry at most one person.
B)   A person has to be married.
C)   A person can marry more than one person, but that person can only be married to one person.
D)   A person can marry more than one person.

Question 4

One of the roles of a database analyst is to identify and understand rules that govern data.

Accepted Answer

A) True 
 B)False

Question 5

The degree of a relationship is the number of attributes that are associated with it.

Accepted Answer

A) True 
 B)False

Question 6

Some examples of attributes are: eye_color, weight, student_id, STUDENT.

Accepted Answer

A) True 
 B)False

Question 7

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

Accepted Answer

A) True 
 B)False

Question 8

In the figure below, Name would be an ideal identifier.

Accepted Answer

A) True 
 B)False

Question 9

In an E-R diagram, an associative entity is represented by a rounded rectangle.

Accepted Answer

A) True 
 B)False

Question 10

An entity type whose existence depends on another entity type is called a ________ entity.

Accepted Answer

A)   strong
B)   weak
C)   codependent
D)   variant

Question 11

The most common types of entities are:

Accepted Answer

A)   strong entities.
B)   weak entities.
C)   associative entities.
D)   smush entities.

Question 12

What is the difference between an entity type and an entity instance?

Accepted Answer

An entity type is a collection of entiti...

Question 13

A multivalued attribute may take on more than one value for a particular entity instance.

Accepted Answer

A) True 
 B)False

Question 14

A value that indicates the date or time of a data value is called a:

Accepted Answer

A)   value stamp.
B)   time stamp.
C)   checkpoint.
D)   check counter.

Question 15

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

Accepted Answer

A)   degree
B)   cardinality constraint
C)   counter constraint
D)   limit

Question 16

A ternary relationship is equivalent to three binary relationships.

Accepted Answer

A) True 
 B)False

Question 17

A time stamp is a time value that is associated with a data value.

Accepted Answer

A) True 
 B)False

Question 18

What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

Accepted Answer

An associative entity is an entity type ...

Question 19

Business policies and rules govern all of the following EXCEPT:

Accepted Answer

A)   managing employees.
B)   creating data.
C)   updating data.
D)   removing data.

Question 20

A business rule is a statement that defines or constrains some aspect of the business.

Accepted Answer

A) True 
 B)False

Exam 2: Modeling Data in the Organization

Some examples of attributes are: eye_color, weight, student_id, STUDENT.

Correct AnswerverifiedShow Answer

A value that indicates the date or time of a data value is called a:

Correct AnswerverifiedShow Answer

A time stamp is a time value that is associated with a data value.

Correct AnswerverifiedShow Answer

What is the difference between an entity type and an entity instance?

Correct AnswerverifiedAn entity type is a collection of entiti...View AnswerShow Answer

A multivalued attribute may take on more than one value for a particular entity instance.

Correct AnswerverifiedShow Answer

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

Correct AnswerverifiedShow Answer

In the figure shown below, which of the following is true?

Correct AnswerverifiedShow Answer

A ternary relationship is equivalent to three binary relationships.

Correct AnswerverifiedShow Answer

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

Correct AnswerverifiedShow Answer

In an E-R diagram, there are/is ________ business rule(s) for every relationship.

Correct AnswerverifiedShow Answer

The most common types of entities are:

Correct AnswerverifiedShow Answer

Business policies and rules govern all of the following EXCEPT:

Correct AnswerverifiedShow Answer

In the figure below, Name would be an ideal identifier.

Correct AnswerverifiedShow Answer

The degree of a relationship is the number of attributes that are associated with it.

Correct AnswerverifiedShow Answer

One of the roles of a database analyst is to identify and understand rules that govern data.

Correct AnswerverifiedShow Answer

A mutually exclusive relationship is one in which:

Correct AnswerverifiedShow Answer

What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

Correct AnswerverifiedAn associative entity is an entity type ...View AnswerShow Answer

An entity type whose existence depends on another entity type is called a ________ entity.

Correct AnswerverifiedShow Answer

A business rule is a statement that defines or constrains some aspect of the business.

Correct AnswerverifiedShow Answer

In an E-R diagram, an associative entity is represented by a rounded rectangle.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
An entity type is a collection of entiti...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
An associative entity is an entity type ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified