Question 1

Ideally,a primary key is composed of several attributes.

Accepted Answer

A) True 
 B)False

Question 2

The DBMS can easily handle multivalued attributes.

Accepted Answer

A) True 
 B)False

Question 3

Explain multivalued attributes,and provide an example.How are multivalued attributes indicated in the Chen model? How are they indicated in the Crow's Foot model?

Accepted Answer

Multivalued attributes are attributes th...

Question 4

The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.

Accepted Answer

A)   mandatory
B)   optional
C)   multivalued
D)   single-valuedE) C) and D)
F) B) and D)

Question 5

When the PK of one entity does not contain the PK of a related entity,the relationship is ____.

Accepted Answer

A)   missing
B)   weak
C)   strong
D)   neutralE) C) and D)
F) A) and B)

Question 6

All simple attributes are also single-valued.

Accepted Answer

A) True 
 B)False

Question 7

A ____ relationship exists when an association is maintained within a single entity.

Accepted Answer

A)   unary
B)   ternary
C)   binary
D)   weakE) B) and C)
F) None of the above

Question 8

The ____ type of attribute cannot be created in a DBMS.

Accepted Answer

A)   derived
B)   multivalued
C)   simple
D)   compositeE) B) and C)
F) A) and D)

Question 9

The term "____" is used to label any condition in which one or more optional relationships exist.

Accepted Answer

A)   participation
B)   optionality
C)   cardinality
D)   connectivityE) A) and B)
F) C) and D)

Question 10

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

Accepted Answer

optional

Question 11

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 attributesE) A) and B)
F) All of the above

Question 12

The ERM forms the basis of a(n)___________________________________.

Accepted Answer

ERD
entity relations...

Question 13

The word "entity" in the ER model corresponds to a table.

Accepted Answer

A) True 
 B)False

Question 14

If an entity can exist apart from one or more related entities,it is said to be ____-independent.

Accepted Answer

A)   existence
B)   relationship
C)   business
D)   weakE) A) and B)
F) C) and D)

Question 15

Attributes do not have a domain.

Accepted Answer

A) True 
 B)False

Question 16

The ____________________ refers to a specific table row as an entity instance.

Accepted Answer

ER model
E...

Question 17

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 numberE) B) and D)
F) A) and D)

Question 18

An attribute representing one or more college degrees belonging to a person would be a(n)____________________ attribute.

Accepted Answer

The answer of An attribute representing one or more college...

Question 19

The Crow's Foot notation depicts the strong relationship with a(n)____________________ line between the entities.

Accepted Answer

solid

Question 20

In the original Chen model,each attribute is represented using an oval with the attribute name connected to the entity with a line.

Accepted Answer

A) True 
 B)False  True

Exam 4: Entity Relationship (ER)Modeling

Ideally,a primary key is composed of several attributes.

Correct AnswerverifiedShow Answer

The DBMS can easily handle multivalued attributes.

Correct AnswerverifiedShow Answer

Explain multivalued attributes,and provide an example.How are multivalued attributes indicated in the Chen model? How are they indicated in the Crow's Foot model?

Correct AnswerverifiedMultivalued attributes are attributes th...View AnswerShow Answer

The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.

Correct AnswerverifiedShow Answer

When the PK of one entity does not contain the PK of a related entity,the relationship is ____.

Correct AnswerverifiedShow Answer

All simple attributes are also single-valued.

Correct AnswerverifiedShow Answer

A ____ relationship exists when an association is maintained within a single entity.

Correct AnswerverifiedShow Answer

The ____ type of attribute cannot be created in a DBMS.

Correct AnswerverifiedShow Answer

The term "____" is used to label any condition in which one or more optional relationships exist.

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedoptional

A derived attribute ____.

Correct AnswerverifiedShow Answer

The ERM forms the basis of a(n)___________________________________.

Correct AnswerverifiedERDentity relations...View AnswerShow Answer

The word "entity" in the ER model corresponds to a table.

Correct AnswerverifiedShow Answer

If an entity can exist apart from one or more related entities,it is said to be ____-independent.

Correct AnswerverifiedShow Answer

Attributes do not have a domain.

Correct AnswerverifiedShow Answer

The ____________________ refers to a specific table row as an entity instance.

Correct AnswerverifiedER modelE...View AnswerShow Answer

A ____ should be a derived attribute.

Correct AnswerverifiedShow Answer

An attribute representing one or more college degrees belonging to a person would be a(n)____________________ attribute.

Correct AnswerverifiedShow Answer

The Crow's Foot notation depicts the strong relationship with a(n)____________________ line between the entities.

Correct Answerverifiedsolid

In the original Chen model,each attribute is represented using an oval with the attribute name connected to the entity with a line.

Correct AnswerverifiedTrue

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Multivalued attributes are attributes th...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
optional

Correct Answer
verified

Correct Answer
verified
ERD
entity relations...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
ER model
E...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
solid

Correct Answer
verified
True