Question 1

What are supertype and subtype entities?

Accepted Answer

When instances of an entity can be categ

Question 2

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 
E) None of the above. 
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 
E) None of the above.

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

A single relationship class involves only one entity class.

Accepted Answer

A) True 
 B)False

Question 5

Subtype entities contain only attributes unique to the subtypes.

Accepted Answer

A) True 
 B)False

Question 6

Relationships are classified by their cardinality.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

The notation 1:N shows the relationship's maximum cardinality.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

The supremetype entity contains the attributes that are common to all subtypes.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

E-R models use an identifying relationship to connect entities that are ID-dependent.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The E-R model is basically made up of en

Question 18

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 19

An identifier of an entity instance must consist of one and only one attribute.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 5: Data Modeling With the Entity-Relationship Model

What are supertype and subtype entities?

Minimum cardinality refers to ________.

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

A single relationship class involves only one entity class.

Subtype entities contain only attributes unique to the subtypes.

Relationships are classified by their cardinality.

A composite attribute is an attribute that ________.

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

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

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

The notation 1:N shows the relationship's maximum cardinality.

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

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

The supremetype entity contains the attributes that are common to all subtypes.

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

E-R models use an identifying relationship to connect entities that are ID-dependent.

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

An identifier of an entity instance must consist of one and only one attribute.

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

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