Question 1

-If we want to indicate that the authors of a book have conceived it when visiting another author in some country,we would use a relationship that is:

Accepted Answer

A)  M-N 
B)  1-1 
C)  1-M 
D)  ternary 
A)  M-N 
B)  1-1 
C)  1-M 
D)  ternary

Question 2

-The following qualifies as optional:

Accepted Answer

A)  Written-by to Author 
B)  Born-in to Author 
C)  Born-in to Country 
D)  All of the above 
A)  Written-by to Author 
B)  Born-in to Author 
C)  Born-in to Country 
D)  All of the above

Question 3

-In reviewing an ERD for consistency,the property of uniqueness applies to:

Accepted Answer

A)  Entity type names 
B)  Attribute names within entity types and relationships 
C)  Attribute names in a subtype 
D)  All of the above 
A)  Entity type names 
B)  Attribute names within entity types and relationships 
C)  Attribute names in a subtype 
D)  All of the above

Question 4

In a generalization hierarchy,since each subtype entity is a supertype entity,the relationship between the two is known as ISA.

Accepted Answer

A) True 
 B)False

Question 5

An entity type that depends on two or more entity types for its primary key is a(n)_______________ entity type.

Accepted Answer

The answer of An entity type that depends on two...

Question 6

When a weak entity lacks at least one identifying relationship,this problem can be corrected by either adding an identifying relationship or converting the weak entity into a regular entity.

Accepted Answer

A) True 
 B)False

Question 7

Adherence to the completeness and consistency rules of ERD diagramming will ensure that an ERD provides an adequate data representation and that all user requirements are represented.

Accepted Answer

A) True 
 B)False

Question 8

A collection of persons,places,events or things of interest in an application is called a(n)___________________.

Accepted Answer

The answer of A collection of persons,places,events or things of...

Question 9

In an ERD that conforms to the consistency rules of diagramming,all relationships must connect two entity types,and relationships must not be connected to other relationships.

Accepted Answer

A) True 
 B)False

Question 10

An entity type that does not have its own primary key,but instead borrows part or all of its primary key from another entity type is known as a(n)___________________.

Accepted Answer

The answer of An entity type that does not have...

Question 11

-The primary key of Volume is:

Accepted Answer

A)  Volume# 
B)  #-of-pages 
C)  The combination Volume# and Title 
D)  The combination Volume# and #-of-pages 
A)  Volume# 
B)  #-of-pages 
C)  The combination Volume# and Title 
D)  The combination Volume# and #-of-pages

Question 12

-Any author in the database:

Accepted Answer

A)  Has written a book as the sole author 
B)  May be without a book in the database 
C)  Has written a book with another author 
D)  Has written at least one book, with or without another author 
A)  Has written a book as the sole author 
B)  May be without a book in the database 
C)  Has written a book with another author 
D)  Has written at least one book, with or without another author

Question 13

With regards to a generalization hierarchy,the __________________ constraint means that subtypes do not have any entities in common.

Accepted Answer

The answer of With regards to a generalization hierarchy,the __________________...

Question 14

-What statement is not true regarding inheritance in a generalization hierarchy:

Accepted Answer

A)  The attributes of the supertype apply to all of the subtypes 
B)  Every subtype entity is also a supertype entity 
C)  Attributes inherited from a supertype are shown in an ERD 
D)  All of the above 
A)  The attributes of the supertype apply to all of the subtypes 
B)  Every subtype entity is also a supertype entity 
C)  Attributes inherited from a supertype are shown in an ERD 
D)  All of the above

Question 15

An ERD diagram and a relational database diagram are similar in that both allow relationships to have attributes.

Accepted Answer

A) True 
 B)False

Question 16

When attribute(s)are associated with a combination of entity types instead of a single entity type,this relationship is usually (but not always)a(n)________________ relationship.

Accepted Answer

The answer of When attribute(s)are associated with a combination of...

Question 17

A relationship with a maximum cardinality of more than one in both directions is a(n)_____________ relationship.

Accepted Answer

The answer of A relationship with a maximum cardinality of...

Question 18

If an attribute is associated with only one entity type,the attribute should be shown as part of a relationship that the entity type participates in.

Accepted Answer

A) True 
 B)False

Question 19

In an ERD,each generalization hierarchy must participate in at least one relationship with an entity type not in the generalization hierarchy.

Accepted Answer

A) True 
 B)False

Question 20

-If we want to add the relationship "Published-in" between Book and Country,it would be:

Accepted Answer

A)  M-N 
B)  1-1 
C)  1-M 
D)  M-way 
A)  M-N 
B)  1-1 
C)  1-M 
D)  M-way

-If we want to indicate that the authors of a book have conceived it when visiting another author in some country,we would use a relationship that is:

-The following qualifies as optional:

-In reviewing an ERD for consistency,the property of uniqueness applies to:

In a generalization hierarchy,since each subtype entity is a supertype entity,the relationship between the two is known as ISA.

An entity type that depends on two or more entity types for its primary key is a(n)_______________ entity type.

When a weak entity lacks at least one identifying relationship,this problem can be corrected by either adding an identifying relationship or converting the weak entity into a regular entity.

Adherence to the completeness and consistency rules of ERD diagramming will ensure that an ERD provides an adequate data representation and that all user requirements are represented.

A collection of persons,places,events or things of interest in an application is called a(n)___________________.

In an ERD that conforms to the consistency rules of diagramming,all relationships must connect two entity types,and relationships must not be connected to other relationships.

An entity type that does not have its own primary key,but instead borrows part or all of its primary key from another entity type is known as a(n)___________________.

-The primary key of Volume is:

-Any author in the database:

With regards to a generalization hierarchy,the __________________ constraint means that subtypes do not have any entities in common.

-What statement is not true regarding inheritance in a generalization hierarchy:

An ERD diagram and a relational database diagram are similar in that both allow relationships to have attributes.

When attribute(s)are associated with a combination of entity types instead of a single entity type,this relationship is usually (but not always)a(n)________________ relationship.

A relationship with a maximum cardinality of more than one in both directions is a(n)_____________ relationship.

If an attribute is associated with only one entity type,the attribute should be shown as part of a relationship that the entity type participates in.

In an ERD,each generalization hierarchy must participate in at least one relationship with an entity type not in the generalization hierarchy.

-If we want to add the relationship "Published-in" between Book and Country,it would be:

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 5: Understanding Entity Relations

-If we want to indicate that the authors of a book have conceived it when visiting another author in some country,we would use a relationship that is:

-The following qualifies as optional:

-In reviewing an ERD for consistency,the property of uniqueness applies to:

In a generalization hierarchy,since each subtype entity is a supertype entity,the relationship between the two is known as ISA.

An entity type that depends on two or more entity types for its primary key is a(n)_______________ entity type.

When a weak entity lacks at least one identifying relationship,this problem can be corrected by either adding an identifying relationship or converting the weak entity into a regular entity.

Adherence to the completeness and consistency rules of ERD diagramming will ensure that an ERD provides an adequate data representation and that all user requirements are represented.

A collection of persons,places,events or things of interest in an application is called a(n)___________________.

In an ERD that conforms to the consistency rules of diagramming,all relationships must connect two entity types,and relationships must not be connected to other relationships.

An entity type that does not have its own primary key,but instead borrows part or all of its primary key from another entity type is known as a(n)___________________.

-The primary key of Volume is:

-Any author in the database:

With regards to a generalization hierarchy,the __________________ constraint means that subtypes do not have any entities in common.

-What statement is not true regarding inheritance in a generalization hierarchy:

An ERD diagram and a relational database diagram are similar in that both allow relationships to have attributes.

When attribute(s)are associated with a combination of entity types instead of a single entity type,this relationship is usually (but not always)a(n)________________ relationship.

A relationship with a maximum cardinality of more than one in both directions is a(n)_____________ relationship.

If an attribute is associated with only one entity type,the attribute should be shown as part of a relationship that the entity type participates in.

In an ERD,each generalization hierarchy must participate in at least one relationship with an entity type not in the generalization hierarchy.

-If we want to add the relationship "Published-in" between Book and Country,it would be:

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters