Question 1

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

Accepted Answer

A) supertype 
B) subtype 
C) discriminator 
D) A and C 
E) B and C 
A) supertype 
B) subtype 
C) discriminator 
D) A and C 
E) B and C

Question 2

Subtypes can be exclusive or inclusive.

Accepted Answer

A) True 
 B)False

Question 3

Supertype/subtype entities are said to have a(n)________ relationship.

Accepted Answer

A) HAS-A 
B) IS-A 
C) recursive 
D) redundant 
E) multivalue 
A) HAS-A 
B) IS-A 
C) recursive 
D) redundant 
E) multivalue

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

In an E-R model,the three types of minimum cardinality are mandatory,optional and indeterminate.

Accepted Answer

A) True 
 B)False

Question 6

-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) 0:1 
B) 1:1 
C) 1:N 
D) N:1 
E) N:M 
A) 0:1 
B) 1:1 
C) 1:N 
D) N:1 
E) N:M

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

A compound identifier is an identifier consisting of two or more attributes.

Accepted Answer

A) True 
 B)False

Question 9

A relationship's maximum cardinality indicates the maximum number of entities that can participate in the relationship.

Accepted Answer

A) True 
 B)False

Question 10

A data model is a plan for a database design.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

An identifier serves the same role for a table that a key does for an entity.

Accepted Answer

A) True 
 B)False

Question 13

Relationships between supertypes and subtypes are called IS-A relationships.

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

A composite attribute is an attribute that ________.

Accepted Answer

A) is multivalued 
B) describes a characteristic of the relationship 
C) consists of a group of attributes 
D) is calculated at run-time 
E) is an identifier 
A) is multivalued 
B) describes a characteristic of the relationship 
C) consists of a group of attributes 
D) is calculated at run-time 
E) is an identifier

Question 18

An entity instance of an entity class is the representation of a particular entity and is described by the values of the attributes of the entity.

Accepted Answer

A) True 
 B)False

Question 19

An ID-dependent entity is an entity whose identifier includes the identifier of another entity.

Accepted Answer

A) True 
 B)False

Question 20

What is meant by the degree of a relationship?

Accepted Answer

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

Exam 5: Data Modeling With the Entity-Relationship Model

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

Subtypes can be exclusive or inclusive.

Supertype/subtype entities are said to have a(n)________ relationship.

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

In an E-R model,the three types of minimum cardinality are mandatory,optional and indeterminate.

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

A compound identifier is an identifier consisting of two or more attributes.

A relationship's maximum cardinality indicates the maximum number of entities that can participate in the relationship.

A data model is a plan for a database design.

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

An identifier serves the same role for a table that a key does for an entity.

Relationships between supertypes and subtypes are called IS-A relationships.

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

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

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

A composite attribute is an attribute that ________.

An entity instance of an entity class is the representation of a particular entity and is described by the values of the attributes of the entity.

An ID-dependent entity is an entity whose identifier includes the identifier of another entity.

What is meant by the degree of a relationship?

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