Question 1

How is minimum cardinality expressed in IE Crow's Foot E-R diagrams?

Accepted Answer

The Crow's Foot E-R diagram notation uses a circle to indicate a minimum cardinality of zero (or "optional")and a hash mark to indicate a minimum cardinality of one (or "mandatory").Each symbol is placed on the relationship line just beyond the symbol indicating maximum cardinality.

Question 2

A relationship's minimum cardinality indicates the number of entity instances that must participate in the relationship.

Accepted Answer

A) True 
 B)False  True

Question 3

A hash mark 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. D

Question 4

Entities containing optional sets of attributes are often represented using subtypes.

Accepted Answer

A) True 
 B)False

Question 5

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

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

Question 9

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 10

An entity instance is the occurrence of a particular entity.

Accepted Answer

A) True 
 B)False

Question 11

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 12

An entity is something that users want to track.

Accepted Answer

A) True 
 B)False

Question 13

You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above.What does the symbol next to the ORDER 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 14

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 15

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

To represent an association pattern in an E-R model,________.

Accepted Answer

A) create a new ID-dependent entity with a 1:1 relationship to one other entity 
B) create a new weak,but not ID-dependent entity with a 1:1 relationship to one other entity 
C) create a new strong entity with a 1:1 relationship to one other entity 
D) create a new ID-dependent entity with a 1:N relationship to one of two parent entities 
E) create a new weak,but not ID-dependent entity with a 1:N relationship to one of two parent entities 
A) create a new ID-dependent entity with a 1:1 relationship to one other entity 
B) create a new weak,but not ID-dependent entity with a 1:1 relationship to one other entity 
C) create a new strong entity with a 1:1 relationship to one other entity 
D) create a new ID-dependent entity with a 1:N relationship to one of two parent entities 
E) create a new weak,but not ID-dependent entity with a 1:N relationship to one of two parent entities

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

E-R modeling recognizes both relationship classes and relationship instances.

Accepted Answer

A) True 
 B)False

Exam 5: Data Modeling With the Entity-Relationship Model

How is minimum cardinality expressed in IE Crow's Foot E-R diagrams?

A relationship's minimum cardinality indicates the number of entity instances that must participate in the relationship.

A hash mark across the relationship line near an entity indicates ________.

Entities containing optional sets of attributes are often represented using subtypes.

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)________.

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

Attributes may be ________.

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

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.

An entity instance is the occurrence of a particular entity.

Maximum cardinality refers to ________.

An entity is something that users want to track.

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

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

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

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

The occurrence of a particular entity is called an ________.

To represent an association pattern in an E-R model,________.

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

E-R modeling recognizes both relationship classes and relationship instances.

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