Question 1

Minimum cardinality refers to ________.

Accepted Answer

A) the most instances of one entity class that can be involved in a relationship with one instance of 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 with one instance of 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 C

Question 2

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  True

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

Describe and discuss the main elements of the Entity-Relationship (E-R)model.Include an example.

Accepted Answer

The E-R model is basically made up of en

Question 5

A for-use-by 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 6

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

Accepted Answer

The Crow's Foot E-R diagram notation use

Question 7

What is meant by the cardinality of a relationship?

Accepted Answer

In the E-R model,there are two types of

Question 8

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

Accepted Answer

A) True 
 B)False

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

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

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

What are supertype and subtype entities? Include an example.

Accepted Answer

When instances of an entity can be categ

Question 13

An identifier may be ________.

Accepted Answer

A) composite 
B) optional 
C) a relationship 
D) minimal 
A) composite 
B) optional 
C) a relationship 
D) minimal

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

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

Accepted Answer

A) True 
 B)False

Question 18

In today's E-R models,attributes of relationships are still used.

Accepted Answer

A) True 
 B)False

Question 19

Entities of a given type are grouped into an ________.

Accepted Answer

A) entity class 
B) entity relationship 
C) entity instance 
D) entity attribute 
A) entity class 
B) entity relationship 
C) entity instance 
D) entity attribute

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Data Modeling With the Entity-Relationship Model

Minimum cardinality refers to ________.

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.

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

Describe and discuss the main elements of the Entity-Relationship (E-R)model.Include an example.

A for-use-by pattern must involve what kind of entity?

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

What is meant by the cardinality of a relationship?

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

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.

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?

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

What are supertype and subtype entities? Include an example.

An identifier may be ________.

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

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

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

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

In today's E-R models,attributes of relationships are still used.

Entities of a given type are grouped into an ________.

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

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