Question 1

Entities of a given type are grouped into entity classes.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Recursive relationships can have all of the following maximum cardinalities except ________.

Accepted Answer

A) 1:1 
B) 1:N 
C) N:M 
D) M:M 
A) 1:1 
B) 1:N 
C) N:M 
D) M:M

Question 4

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

Accepted Answer

The Crow's Foot E-R diagram notation use

Question 5

ID-dependent entities are associated by a nonidentifying relationship.

Accepted Answer

A) True 
 B)False

Question 6

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

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

Accepted Answer

A) True 
 B)False

Question 8

An entity is something that users want to track.

Accepted Answer

A) True 
 B)False

Question 9

You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above,and are asked to draw the relationship between them.If a given customer can place many orders and a given order can be placed by at most one customer,which of the following should be indicated in the relationship symbol between the two entities?

Accepted Answer

A) N:M 
B) 1:1 
C) 1:N 
D) N:1 
A) N:M 
B) 1:1 
C) 1:N 
D) N:1

Question 10

The notation 1:N shows a relationship's maximum cardinalities.

Accepted Answer

A) True 
 B)False

Question 11

An attribute that determines which subtype should be used is a(n)________.

Accepted Answer

A) supertype 
B) subtype 
C) discriminator 
D) identifier 
A) supertype 
B) subtype 
C) discriminator 
D) identifier

Question 12

The characteristics of a thing are described by its ________.

Accepted Answer

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

Question 13

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) parent 
A) supertype 
B) subtype 
C) discriminator 
D) parent

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

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 N:1 relationships to 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 N:1 relationships to two parent entities

Question 17

ID-dependent entities are a common type of weak entity.

Accepted Answer

A) True 
 B)False

Question 18

What is an ID-Dependent entity? Include an example.

Accepted Answer

There are some entities that cannot be c

Question 19

Entities with an IS-A relationship should have the same identifier.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 5: Data Modeling With the Entity-Relationship Model

Entities of a given type are grouped into entity classes.

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

Recursive relationships can have all of the following maximum cardinalities except ________.

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

ID-dependent entities are associated by a nonidentifying relationship.

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

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

An entity is something that users want to track.

The notation 1:N shows a relationship's maximum cardinalities.

An attribute that determines which subtype should be used is a(n)________.

The characteristics of a thing are described by its ________.

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

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

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

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

ID-dependent entities are a common type of weak entity.

What is an ID-Dependent entity? Include an example.

Entities with an IS-A relationship should have the same identifier.

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.

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