Question 1

One example of a database design using a strong relationship is the multivalued attribute pattern.

Accepted Answer

A) True 
 B)False

Question 2

ID-dependent entities are associated by a nonidentifying relationship.

Accepted Answer

A) True 
 B)False

Question 3

What is an ID-Dependent entity?

Accepted Answer

There are some entities that cannot be c

Question 4

The occurrence of a particular entity is called 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 5

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 6

Attributes may be ________.

Accepted Answer

A) composite 
B) element 
C) multivalued 
D) A and C 
E) B and C 
A) composite 
B) element 
C) multivalued 
D) A and C 
E) B and C

Question 7

Relationships are classified by their cardinality.

Accepted Answer

A) True 
 B)False

Question 8

What is meant by the cardinality of a relationship?

Accepted Answer

In the E-R model,there are two types of

Question 9

Relationships of degree two are referred to as binary relationships.

Accepted Answer

A) True 
 B)False

Question 10

Minimum cardinality refers to ________.

Accepted Answer

A) the most instances of one entity class that can be involved in a relationship with one instance of 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 with one instance of 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 11

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

Accepted Answer

A) True 
 B)False

Question 12

An attribute that determines which subtype is appropriate is called a discriminator.

Accepted Answer

A) True 
 B)False

Question 13

Distinguish between an entity class and an entity instance.

Accepted Answer

An entity class is the collection of all

Question 14

What are supertype and subtype entities?

Accepted Answer

When instances of an entity can be categ

Question 15

Entities of a given type are grouped into entity classes.

Accepted Answer

A) True 
 B)False

Question 16

E-R models use an identifying relationship to connect entities that are ID-dependent.

Accepted Answer

A) True 
 B)False

Question 17

In today's E-R models,attributes of relationships are still used.

Accepted Answer

A) True 
 B)False

Question 18

An entity instance is the occurrence of a particular entity.

Accepted Answer

A) True 
 B)False

Question 19

In a 1:N relationship,the parent entity is on the one side of the relationship,and the child entity is on the many side of the relationship.

Accepted Answer

A) True 
 B)False

Question 20

In a minimum cardinality,minimums are generally stated as ________.

Accepted Answer

A) 0 
B) 1 
C) N 
D) A or B 
E) A,B or C 
A) 0 
B) 1 
C) N 
D) A or B 
E) A,B or C

Exam 5: Data Modeling With the Entity-Relationship Model

One example of a database design using a strong relationship is the multivalued attribute pattern.

ID-dependent entities are associated by a nonidentifying relationship.

What is an ID-Dependent entity?

The occurrence of a particular entity is called an ________.

Entities of a given type are grouped into an ________.

Attributes may be ________.

Relationships are classified by their cardinality.

What is meant by the cardinality of a relationship?

Relationships of degree two are referred to as binary relationships.

Minimum cardinality refers to ________.

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

An attribute that determines which subtype is appropriate is called a discriminator.

Distinguish between an entity class and an entity instance.

What are supertype and subtype entities?

Entities of a given type are grouped into entity classes.

E-R models use an identifying relationship to connect entities that are ID-dependent.

In today's E-R models,attributes of relationships are still used.

An entity instance is the occurrence of a particular entity.

In a 1:N relationship,the parent entity is on the one side of the relationship,and the child entity is on the many side of the relationship.

In a minimum cardinality,minimums are generally stated as ________.

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