Question 1

An entity that represents something that can exist on its own is called a strong entity.

Accepted Answer

A) True 
 B)False

Question 2

Distinguish between an entity class and an entity instance.

Accepted Answer

An entity class is the collection of all

Question 3

A binary relationship is a relationship based on numerical entity instance identifiers.

Accepted Answer

A) True 
 B)False

Question 4

Relationships among instances of a single entity class are called redundant relationships.

Accepted Answer

A) True 
 B)False

Question 5

An entity that holds specialized attributes that distinguish it from one or more other similar entities is a ________.

Accepted Answer

A) supertype 
B) subtype 
C) discriminator 
D) A and C 
E) B and C 
A) supertype 
B) subtype 
C) discriminator 
D) A and C 
E) B and C

Question 6

One example of a database design using an ID-dependent relationship is the association pattern.

Accepted Answer

A) True 
 B)False

Question 7

Entities of a given type are grouped into an ________.

Accepted Answer

A) entity class 
B) entity relationship 
C) entity instance 
D) entity attribute 
E) None of the above. 
A) entity class 
B) entity relationship 
C) entity instance 
D) entity attribute 
E) None of the above.

Question 8

An ID-dependent entity is an entity whose identifier includes the identifier of another entity.

Accepted Answer

A) True 
 B)False

Question 9

Subtypes can be exclusive or inclusive.

Accepted Answer

A) True 
 B)False

Question 10

Recursive relationships can have which of the following maximum cardinalities?

Accepted Answer

A) 1:1 
B) 1:N 
C) N:M 
D) A or B 
E) A,B,or C 
A) 1:1 
B) 1:N 
C) N:M 
D) A or B 
E) A,B,or C

Question 11

A composite identifier is defined as a composite attribute that is an identifier.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is not true about subtype entities?

Accepted Answer

A) Subtypes may be exclusive. 
B) The supertype and subtypes will have the same identifier. 
C) Subtypes are used to avoid a situation in which some attributes are required to be null. 
D) Subtypes have attributes that are required by the supertype. 
E) Subtypes can produce a closer-fitting data model. 
A) Subtypes may be exclusive. 
B) The supertype and subtypes will have the same identifier. 
C) Subtypes are used to avoid a situation in which some attributes are required to be null. 
D) Subtypes have attributes that are required by the supertype. 
E) Subtypes can produce a closer-fitting data model.

Question 13

For a relationship to be considered a binary relationship it must satisfy which of the following conditions?

Accepted Answer

A) It must involve exactly two entity classes. 
B) It must have a maximum cardinality of 1:1. 
C) It must have a maximum cardinality of 1:N. 
D) A and B 
E) A and C 
A) It must involve exactly two entity classes. 
B) It must have a maximum cardinality of 1:1. 
C) It must have a maximum cardinality of 1:N. 
D) A and B 
E) A and C

Question 14

Recursive relationships only exist for one-to-one relationships.

Accepted Answer

A) True 
 B)False

Question 15

A binary relationship is a relationship between two or more entities.

Accepted Answer

A) True 
 B)False

Question 16

A weak entity is an entity that cannot exist in the database without (and is logically dependent upon)another type of entity also existing in the database.

Accepted Answer

A) True 
 B)False

Question 17

To represent an archetype/instance pattern in an E-R model,________.

Accepted Answer

A) create a new ID-dependent entity with a 1:N relationship 
B) create a new weak,but not ID-dependent entity with a 1:N relationship 
C) create a new strong entity with a 1:1 relationship 
D) create a new ID-dependent entity with a 1:1 relationship 
E) create a new weak,but not ID-dependent entity with a 1:1 relationship 
A) create a new ID-dependent entity with a 1:N relationship 
B) create a new weak,but not ID-dependent entity with a 1:N relationship 
C) create a new strong entity with a 1:1 relationship 
D) create a new ID-dependent entity with a 1:1 relationship 
E) create a new weak,but not ID-dependent entity with a 1:1 relationship

Question 18

You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above.What does the symbol next to the CUSTOMER entity indicate?

Accepted Answer

A) A maximum cardinality of "zero" 
B) A maximum cardinality of "one" 
C) A minimum cardinality of "optional" 
D) A minimum cardinality of "required" 
E) None of the above. 
A) A maximum cardinality of "zero" 
B) A maximum cardinality of "one" 
C) A minimum cardinality of "optional" 
D) A minimum cardinality of "required" 
E) None of the above.

Question 19

When an entity has a relationship to itself,we have a(n)________.

Accepted Answer

A) supertype/subtype relationship 
B) archetype/instance relationship 
C) recursive relationship 
D) A or C 
E) B or C 
A) supertype/subtype relationship 
B) archetype/instance relationship 
C) recursive relationship 
D) A or C 
E) B or C

Question 20

Discriminators can be ________.

Accepted Answer

A) exclusive only 
B) inclusive only 
C) decisive only 
D) A or B 
E) B or C 
A) exclusive only 
B) inclusive only 
C) decisive only 
D) A or B 
E) B or C

Exam 5: Data Modeling With the Entity-Relationship Model

An entity that represents something that can exist on its own is called a strong entity.

Distinguish between an entity class and an entity instance.

A binary relationship is a relationship based on numerical entity instance identifiers.

Relationships among instances of a single entity class are called redundant relationships.

An entity that holds specialized attributes that distinguish it from one or more other similar entities is a ________.

One example of a database design using an ID-dependent relationship is the association pattern.

Entities of a given type are grouped into an ________.

An ID-dependent entity is an entity whose identifier includes the identifier of another entity.

Subtypes can be exclusive or inclusive.

Recursive relationships can have which of the following maximum cardinalities?

A composite identifier is defined as a composite attribute that is an identifier.

Which of the following is not true about subtype entities?

For a relationship to be considered a binary relationship it must satisfy which of the following conditions?

Recursive relationships only exist for one-to-one relationships.

A binary relationship is a relationship between two or more entities.

A weak entity is an entity that cannot exist in the database without (and is logically dependent upon)another type of entity also existing in the database.

To represent an archetype/instance pattern in an E-R model,________.

You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above.What does the symbol next to the CUSTOMER entity indicate?

When an entity has a relationship to itself,we have a(n)________.

Discriminators can be ________.

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Transforming Data Models Into Database Designs

Sql for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters