Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

An entity whose identifier includes the identifier of another 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 3

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 4

There are three types of recursive relationships: 1:1,1:N and N:M.

Accepted Answer

A) True 
 B)False

Question 5

What is an ID-Dependent entity?

Accepted Answer

There are some entities that cannot be c

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

When transforming a data model into a relational design,relationships of all degrees are treated as combinations of binary relationships.

Accepted Answer

A) True 
 B)False

Question 8

When designing a database,first identify the entities,then determine the attributes,and finally create the relationships.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The broad definition of a weak entity in

Question 10

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

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

Distinguish between entity identifiers and keys.

Accepted Answer

An entity identifier is an attribute or

Question 13

ID-dependent entities are associated by a nonidentifying relationship.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

To represent a multivalued attribute 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 
E) create a new weak,but not 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 
E) create a new weak,but not ID-dependent entity with a 1:1 relationship

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

The principal difference between an entity and a table is that you can express a relationship between entities without using foreign keys.

Accepted Answer

A) True 
 B)False

Question 19

Entities can be associated with one another in relationships.

Accepted Answer

A) True 
 B)False

Question 20

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 one or more customers,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

Exam 5: Data Modeling With the Entity-Relationship Model

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

An entity whose identifier includes the identifier of another entity is a(n)________.

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

There are three types of recursive relationships: 1:1,1:N and N:M.

What is an ID-Dependent entity?

What is meant by the degree of a relationship?

When transforming a data model into a relational design,relationships of all degrees are treated as combinations of binary relationships.

When designing a database,first identify the entities,then determine the attributes,and finally create the relationships.

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

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

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

Distinguish between entity identifiers and keys.

ID-dependent entities are associated by a nonidentifying relationship.

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

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

To represent a multivalued attribute in an E-R model,________.

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

The principal difference between an entity and a table is that you can express a relationship between entities without using foreign keys.

Entities can be associated with one another in relationships.

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