Question 1

Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

Accepted Answer

A) True 
 B)False

Question 2

The relationship ____________________ is difficult to establish if you know only one side of the relationship.

Accepted Answer

The answer of The relationship ____________________ is difficult to establish...

Question 3

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 4

Explain single-valued attributes and provide an example.Is an attribute that is single-valued always simple? Why or why not? Use an example to illustrate your point.

Accepted Answer

A single-valued attribute is an attribut

Question 5

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 6

If Tiny College had some departments that were classified as "research only," they would not offer courses;therefore,the COURSE entity would be ____ to the DEPARTMENT entity.

Accepted Answer

A)  existence-dependent 
B)  independent 
C)  weak 
D)  optional 
A)  existence-dependent 
B)  independent 
C)  weak 
D)  optional

Question 7

The following step occurs first in the process of building an ERD: ____.

Accepted Answer

A)  Develop the initial ERD. 
B)  Create a detailed narrative of the organization's description of operations. 
C)  Identify the attributes and primary keys that adequately describe the entities. 
D)  Identify the business rules based on the description of operations. 
A)  Develop the initial ERD. 
B)  Create a detailed narrative of the organization's description of operations. 
C)  Identify the attributes and primary keys that adequately describe the entities. 
D)  Identify the business rules based on the description of operations.

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

In the ERD,cardinality is indicated using the ____ notation.

Accepted Answer

A)  (max, min) 
B)  (min, max) 
C)  [min ... max] 
D)  {min|max} 
A)  (max, min) 
B)  (min, max) 
C)  [min ... max] 
D)  {min|max}

Question 10

Attributes cannot share a domain.

Accepted Answer

A) True 
 B)False

Question 11

Attributes are types of entities.

Accepted Answer

A) True 
 B)False

Question 12

A(n)____________________ attribute need not be physically stored within the database.

Accepted Answer

The answer of A(n)____________________ attribute need not be physically stored...

Question 13

Explain the difference between simple and composite attributes.Provide at least one example of each.

Accepted Answer

Attributes are classified as simple or c

Question 14

The associative entity is also known as a ____ entity.

Accepted Answer

A)  unary 
B)  weak 
C)  strong 
D)  composite 
A)  unary 
B)  weak 
C)  strong 
D)  composite

Question 15

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 
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 16

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 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

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

Accepted Answer

The answer of The Crow's Foot notation depicts the strong...

Question 19

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 
A)  associative 
B)  recursive 
C)  unary 
D)  binary

Question 20

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

Accepted Answer

A) True 
 B)False

Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

The relationship ____________________ is difficult to establish if you know only one side of the relationship.

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

Explain single-valued attributes and provide an example.Is an attribute that is single-valued always simple? Why or why not? Use an example to illustrate your point.

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

If Tiny College had some departments that were classified as "research only," they would not offer courses;therefore,the COURSE entity would be ____ to the DEPARTMENT entity.

The following step occurs first in the process of building an ERD: ____.

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

In the ERD,cardinality is indicated using the ____ notation.

Attributes cannot share a domain.

Attributes are types of entities.

A(n)____________________ attribute need not be physically stored within the database.

Explain the difference between simple and composite attributes.Provide at least one example of each.

The associative entity is also known as a ____ entity.

A derived attribute ____.

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?

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

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

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

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

Database Systems

Data Models

The Relational Database Model

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters

Exam 4: Entity Relationship (ER)Modeling

Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

The relationship ____________________ is difficult to establish if you know only one side of the relationship.

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

Explain single-valued attributes and provide an example.Is an attribute that is single-valued always simple? Why or why not? Use an example to illustrate your point.

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

If Tiny College had some departments that were classified as "research only," they would not offer courses;therefore,the COURSE entity would be ____ to the DEPARTMENT entity.

The following step occurs first in the process of building an ERD: ____.

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

In the ERD,cardinality is indicated using the ____ notation.

Attributes cannot share a domain.

Attributes are types of entities.

A(n)____________________ attribute need not be physically stored within the database.

Explain the difference between simple and composite attributes.Provide at least one example of each.

The associative entity is also known as a ____ entity.

A derived attribute ____.

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?

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

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

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

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

Database Systems

Data Models

The Relational Database Model

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language (SQL)

Advanced SQL

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Connectivity and Web Technologies

Database Administration and Security

Filters