Question 1

In a university setting, the relationship between students and the professors who have been their instructors is a _____ relationship.

Accepted Answer

A)  one-to-one binary 
B)  one-to-many binary 
C)  many-to-many binary 
D)  one-to-one unary 
E)  one-to-many unary 
A)  one-to-one binary 
B)  one-to-many binary 
C)  many-to-many binary 
D)  one-to-one unary 
E)  one-to-many unary

Question 2

In a one-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity can be associated with only one occurrence of the first.

Accepted Answer

A) True 
 B)False

Question 3

In a one-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type.

Accepted Answer

A) True 
 B)False

Question 4

The cardinality of a relationship is _____.

Accepted Answer

A)  The minimum number of entities that can be involved in the relationship. 
B)  The maximum number of entities that can be involved in the relationship. 
C)  The minimum number of attributes that can be in the entity types in a relationship. 
D)  The maximum number of attributes that can be in the entity types in a relationship. 
E)  The minimum number of associations that can be involved in the relationship. 
A)  The minimum number of entities that can be involved in the relationship. 
B)  The maximum number of entities that can be involved in the relationship. 
C)  The minimum number of attributes that can be in the entity types in a relationship. 
D)  The maximum number of attributes that can be in the entity types in a relationship. 
E)  The minimum number of associations that can be involved in the relationship.

Question 5

In a one-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity can be associated with only one occurrence of the first.

Accepted Answer

A) True 
 B)False

Question 6

In a one-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of the same entity type.

Accepted Answer

A) True 
 B)False

Question 7

The modality of a relationship is _____.

Accepted Answer

A)  The minimum number of entities that can be involved in the relationship. 
B)  The maximum number of entities that can be involved in the relationship. 
C)  The minimum number of attributes that can be in the entity types in a relationship. 
D)  The maximum number of attributes that can be in the entity types in a relationship. 
E)  The minimum number of associations that can be involved in the relationship. 
A)  The minimum number of entities that can be involved in the relationship. 
B)  The maximum number of entities that can be involved in the relationship. 
C)  The minimum number of attributes that can be in the entity types in a relationship. 
D)  The maximum number of attributes that can be in the entity types in a relationship. 
E)  The minimum number of associations that can be involved in the relationship.

Question 8

A one-to-one unary relationship involves a single entity type.

Accepted Answer

A) True 
 B)False

Question 9

In a many-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of the same entity type.

Accepted Answer

A) True 
 B)False

Question 10

The Entity-Relationship (E-R) model is _____.

Accepted Answer

A)  a diagramming technique that describes record structures (i.e. the fields that make up the records of a file) 
B)  an alternative to indexing and hashing as a means for providing direct access in files 
C)  a diagramming technique that describes entities, their attributes, and the relationships between them 
D)  an alternative to file design in which attributes are used instead of fields 
E)  a diagramming technique that relates entities to each other, attributes to each other, and relationships to each other 
A)  a diagramming technique that describes record structures (i.e. the fields that make up the records of a file) 
B)  an alternative to indexing and hashing as a means for providing direct access in files 
C)  a diagramming technique that describes entities, their attributes, and the relationships between them 
D)  an alternative to file design in which attributes are used instead of fields 
E)  a diagramming technique that relates entities to each other, attributes to each other, and relationships to each other

Question 11

In a many-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with many occurrences of the first.

Accepted Answer

A) True 
 B)False

Question 12

A dependent entity _____.

Accepted Answer

A)  is the same as an associative entity 
B)  can only exist as part of a many-to-many binary relationship 
C)  can only be present if the entity it depends on is present 
D)  requires intersection data if it is part of a many-to-many binary relationship 
E)  requires intersection data if it is part of a ternary relationship 
A)  is the same as an associative entity 
B)  can only exist as part of a many-to-many binary relationship 
C)  can only be present if the entity it depends on is present 
D)  requires intersection data if it is part of a many-to-many binary relationship 
E)  requires intersection data if it is part of a ternary relationship

Question 13

An association between entities is a(n) _____.

Accepted Answer

A)  entity type 
B)  entity occurence 
C)  record 
D)  attribute 
E)  relationship 
A)  entity type 
B)  entity occurence 
C)  record 
D)  attribute 
E)  relationship

Question 14

Depending on the attributes and circumstances present, the unique identifier of an associative entity could be any of the following, except _____.

Accepted Answer

A)  the combination of the unique identifiers of the entities in the many-to-many relationship consisting of exactly one field from each entity 
B)  the combination of the unique identifiers of the entities in the many-to-many relationship consisting of several fields 
C)  the combination of the unique identifiers of the entities in the many-to-many relationship plus one or more additional fields that express times or dates 
D)  a single field that is associated with the associative entity and provides unique values 
E)  a unique combination of fields from one of the two entities in the many-to-many relationship 
A)  the combination of the unique identifiers of the entities in the many-to-many relationship consisting of exactly one field from each entity 
B)  the combination of the unique identifiers of the entities in the many-to-many relationship consisting of several fields 
C)  the combination of the unique identifiers of the entities in the many-to-many relationship plus one or more additional fields that express times or dates 
D)  a single field that is associated with the associative entity and provides unique values 
E)  a unique combination of fields from one of the two entities in the many-to-many relationship

Question 15

In a many-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with only one occurrence of the first.

Accepted Answer

A) True 
 B)False

Question 16

A one-to-one binary relationship associates one occurrence of an entity type with one occurrence of another entity type.

Accepted Answer

A) True 
 B)False

Question 17

A business school's faculty parking lot has assigned parking spaces. Each professor is entitled to one parking space. This is an example of a _____ relationship.

Accepted Answer

A)  one-to-one binary 
B)  one-to-many binary 
C)  many-to-many binary 
D)  one-to-one unary 
E)  one-to-many unary 
A)  one-to-one binary 
B)  one-to-many binary 
C)  many-to-many binary 
D)  one-to-one unary 
E)  one-to-many unary

In a university setting, the relationship between students and the professors who have been their instructors is a _____ relationship.

In a one-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity can be associated with only one occurrence of the first.

In a one-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type.

The cardinality of a relationship is _____.

In a one-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity can be associated with only one occurrence of the first.

In a one-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of the same entity type.

The modality of a relationship is _____.

A one-to-one unary relationship involves a single entity type.

In a many-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of the same entity type.

The Entity-Relationship (E-R) model is _____.

In a many-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with many occurrences of the first.

A dependent entity _____.

An association between entities is a(n) _____.

Depending on the attributes and circumstances present, the unique identifier of an associative entity could be any of the following, except _____.

In a many-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with only one occurrence of the first.

A one-to-one binary relationship associates one occurrence of an entity type with one occurrence of another entity type.

A business school's faculty parking lot has assigned parking spaces. Each professor is entitled to one parking space. This is an example of a _____ relationship.

Data: the New Corporate Resource

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters

Exam 2: Data Modeling

In a university setting, the relationship between students and the professors who have been their instructors is a _____ relationship.

In a one-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity can be associated with only one occurrence of the first.

In a one-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type.

The cardinality of a relationship is _____.

In a one-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity can be associated with only one occurrence of the first.

In a one-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of the same entity type.

The modality of a relationship is _____.

A one-to-one unary relationship involves a single entity type.

In a many-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of the same entity type.

The Entity-Relationship (E-R) model is _____.

In a many-to-many unary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with many occurrences of the first.

A dependent entity _____.

An association between entities is a(n) _____.

Depending on the attributes and circumstances present, the unique identifier of an associative entity could be any of the following, except _____.

In a many-to-many binary relationship an occurrence of one entity type can be associated with many occurrences of another entity type while each occurrence of the second entity type can be associated with only one occurrence of the first.

A one-to-one binary relationship associates one occurrence of an entity type with one occurrence of another entity type.

A business school's faculty parking lot has assigned parking spaces. Each professor is entitled to one parking space. This is an example of a _____ relationship.

Data: the New Corporate Resource

The Database Management System Concept

Relational Data Retrieval: SQL

The Relational Database Model: Introduction

The Relational Database Model: Additional Concepts

Logical Database Design

Physical Database Design

Object-Oriented Database Management

Data Administration, Database Administration, and Data Dictionaries

Database Control Issues: Security, Backup and Recovery, Concurrency

Clientserver Database and Distributed Database

The Data Warehouse

Database and the Internet

Filters