Question 1

An identifier of an entity instance must consist of one and only one attribute.

Accepted Answer

A) True 
 B)False

Question 2

In a 1:N relationship,the term parent refers to the N side of the relationship.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

An identifier of an entity instance is one or more attributes that name or identify entity instances.

Accepted Answer

A) True 
 B)False

Question 6

Maximum cardinality refers to ________.

Accepted Answer

A) the most instances of one entity class that can be involved in a relationship instance with another entity class 
B) the minimum number of entity classes involved in a relationship 
C) whether or not an instance of one entity class is required to be related to an instance of another entity class 
D) whether or not an entity is a weak entity 
E) None of the above. 
A) the most instances of one entity class that can be involved in a relationship instance with another entity class 
B) the minimum number of entity classes involved in a relationship 
C) whether or not an instance of one entity class is required to be related to an instance of another entity class 
D) whether or not an entity is a weak entity 
E) None of the above.

Question 7

Data modelers agree that weak,non-ID-dependent entities exist and are important.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

The characteristics of a thing are described by its ________.

Accepted Answer

A) identifiers 
B) entities 
C) objects 
D) attributes 
E) relationships 
A) identifiers 
B) entities 
C) objects 
D) attributes 
E) relationships

Question 10

In an E-R model,the three types of maximum cardinality are 1:1,1:N and N:M.

Accepted Answer

A) True 
 B)False

Question 11

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

The method of constructing data models used in the text is the extended entity-relationship (E-R)model.

Accepted Answer

A) True 
 B)False

Question 13

In E-R modeling,an attribute describes the characteristics of an entity.

Accepted Answer

A) True 
 B)False

Question 14

An exclusive subtype pattern has one supertype entity that relates to one or more subtype entities.

Accepted Answer

A) True 
 B)False

Question 15

In E-R modeling,entities within an entity class may have different attributes.

Accepted Answer

A) True 
 B)False

Question 16

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 17

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 18

A circle across the relationship line near an entity indicates ________.

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

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

Question 20

An entity whose existence depends on the presence of another entity,but whose identifier does not include the identifier of the other entity is a(n)________.

Accepted Answer

A) strong entity 
B) weak entity 
C) ID-dependent entity 
D) A and C 
E) B and C 
A) strong entity 
B) weak entity 
C) ID-dependent entity 
D) A and C 
E) B and C

Exam 5: Data Modeling With the Entity-Relationship Model

An identifier of an entity instance must consist of one and only one attribute.

In a 1:N relationship,the term parent refers to the N side of the relationship.

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

Recursive relationships can have which of the following maximum cardinalities?

An identifier of an entity instance is one or more attributes that name or identify entity instances.

Maximum cardinality refers to ________.

Data modelers agree that weak,non-ID-dependent entities exist and are important.

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

The characteristics of a thing are described by its ________.

In an E-R model,the three types of maximum cardinality are 1:1,1:N and N:M.

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

The method of constructing data models used in the text is the extended entity-relationship (E-R)model.

In E-R modeling,an attribute describes the characteristics of an entity.

An exclusive subtype pattern has one supertype entity that relates to one or more subtype entities.

In E-R modeling,entities within an entity class may have different attributes.

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

Which of the following is not true about subtype entities?

A circle across the relationship line near an entity indicates ________.

Discriminators can be ________.

An entity whose existence depends on the presence of another entity,but whose identifier does not include the identifier of the other entity is a(n)________.

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

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters