Question 1

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

Question 2

Subtype entities contain,apart from the identifier,only attributes that do not appear in the supertype.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Explain the ambiguity in the broad definition of a weak entity.

Accepted Answer

The broad definition of a weak entity in

Question 5

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 6

What is meant by the degree of a relationship?

Accepted Answer

In the E-R model,the degree of a relatio

Question 7

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

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

Which of the following is not a key element of an E-R model?

Accepted Answer

A) Relationships 
B) Entities 
C) Objects 
D) Attributes 
A) Relationships 
B) Entities 
C) Objects 
D) Attributes

Question 10

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" 
A) A maximum cardinality of "zero" 
B) A maximum cardinality of "one" 
C) A minimum cardinality of "optional" 
D) A minimum cardinality of "required"

Question 11

A line-item pattern must involve what kind of entity?

Accepted Answer

A) Strong entity 
B) Supertype entity 
C) Weak entity with one identifying relationship 
D) Weak entity with two identifying relationships 
A) Strong entity 
B) Supertype entity 
C) Weak entity with one identifying relationship 
D) Weak entity with two identifying relationships

Question 12

Distinguish between an entity class and an entity instance.

Accepted Answer

An entity class is the collection of all

Question 13

The degree of a relationship is the number of entity classes in the relationship.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Relationships are classified by their cardinality.

Accepted Answer

A) True 
 B)False

Question 16

An entity class is described by the structure of the entities in that class.

Accepted Answer

A) True 
 B)False

Question 17

Suppose you have created a data model for an airline based on a variety of forms,reports,user interviews,data sources,etc.Your client comes forward with a new desired report that includes passenger weights and a relationship between passengers and employees,neither of which is in your E-R diagram.You should ________.

Accepted Answer

A) create a new,separate E-R diagram with just the new information 
B) add the relationship and the weight attribute to the existing data model 
C) add the relationship but not the weight attribute 
D) add the weight attribute but not the relationship 
A) create a new,separate E-R diagram with just the new information 
B) add the relationship and the weight attribute to the existing data model 
C) add the relationship but not the weight attribute 
D) add the weight attribute but not the relationship

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

An entity's minimum cardinality in a relationship indicates whether or not an entity must participate in the relationship.

Accepted Answer

A) True 
 B)False

Question 20

The supremetype entity contains the attributes that are common to all subtypes.

Accepted Answer

A) True 
 B)False

Exam 5: Data Modeling With the Entity-Relationship Model

Maximum cardinality refers to ________.

Subtype entities contain,apart from the identifier,only attributes that do not appear in the supertype.

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

Explain the ambiguity in the broad definition of a weak entity.

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

What is meant by the degree of a relationship?

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

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

Which of the following is not a key element of 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?

A line-item pattern must involve what kind of entity?

Distinguish between an entity class and an entity instance.

The degree of a relationship is the number of entity classes in the relationship.

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

Relationships are classified by their cardinality.

An entity class is described by the structure of the entities in that class.

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

An entity's minimum cardinality in a relationship indicates whether or not an entity must participate in the relationship.

The supremetype entity contains the attributes that are common to all subtypes.

Introduction

Introduction to Structured Query Language

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 2014

Managing Databases With Oracle Database

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With 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 Netbeans IDE

Business Intelligence Systems

Big Data

Filters