Question 1

A relation is in first normal form if it has no more than one multivalued attribute.

Accepted Answer

A) True 
 B)False

Question 2

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Accepted Answer

A)  referential integrity constraint. 
B)  key match rule. 
C)  entity key group rule. 
D)  foreign/primary match rule. 
A)  referential integrity constraint. 
B)  key match rule. 
C)  entity key group rule. 
D)  foreign/primary match rule.

Question 3

Data structures include data organized in the form of tables with rows and columns.

Accepted Answer

A) True 
 B)False

Question 4

A primary key that consists of more than one attribute is called a:

Accepted Answer

A)  foreign key. 
B)  composite key. 
C)  multivalued key. 
D)  cardinal key. 
A)  foreign key. 
B)  composite key. 
C)  multivalued key. 
D)  cardinal key.

Question 5

The figure below is an example of mapping which type of relationship?

Accepted Answer

A)  First 
B)  Second 
C)  Unary 
D)  Ternary 
A)  First 
B)  Second 
C)  Unary 
D)  Ternary

Question 6

In the figure below, what type of relationship do the relations depict?

Accepted Answer

A)  Strong entity/weak entity 
B)  One-to-many 
C)  Ternary 
D)  Many-to-many 
A)  Strong entity/weak entity 
B)  One-to-many 
C)  Ternary 
D)  Many-to-many

Question 7

In the SQL language, the ________ statement is used to make table definitions.

Accepted Answer

A)  create session 
B)  create table 
C)  create index 
D)  select 
A)  create session 
B)  create table 
C)  create index 
D)  select

Question 8

The primary key of the many side migrates to the one side when transforming a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 9

In the figure below, what is depicted?

Accepted Answer

A)  A one-to-one relationship 
B)  A unary relationship 
C)  A one-to-many relationship 
D)  An associative entity 
A)  A one-to-one relationship 
B)  A unary relationship 
C)  A one-to-many relationship 
D)  An associative entity

Question 10

When two or more attributes describe the same characteristic of an entity, they are synonyms.

Accepted Answer

A) True 
 B)False

Question 11

Discuss the two major occasions when you benefit from using normalization.

Accepted Answer

During logical database design, normaliz

Question 12

One property of a relation is that each attribute within a relation has a unique name.

Accepted Answer

A) True 
 B)False

Question 13

The normal form which deals with multivalued dependencies is called:

Accepted Answer

A)  fifth normal form. 
B)  fourth normal form. 
C)  Boyce-Codd normal form. 
D)  sixth normal form. 
A)  fifth normal form. 
B)  fourth normal form. 
C)  Boyce-Codd normal form. 
D)  sixth normal form.

Question 14

A primary key is an attribute that uniquely identifies each row in a relation.

Accepted Answer

A) True 
 B)False

Question 15

The entity integrity rule states that a primary key attribute can be null.

Accepted Answer

A) True 
 B)False

Question 16

All of the following are the main goals of normalization EXCEPT:

Accepted Answer

A)  minimize data redundancy. 
B)  simplify the enforcement of referential integrity. 
C)  maximize storage space. 
D)  make it easier to maintain data. 
A)  minimize data redundancy. 
B)  simplify the enforcement of referential integrity. 
C)  maximize storage space. 
D)  make it easier to maintain data.

Question 17

There can be multivalued attributes in a relation.

Accepted Answer

A) True 
 B)False

Question 18

When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.

Accepted Answer

A) True 
 B)False

Question 19

In the figure below, each employee has exactly one manager.

Accepted Answer

A) True 
 B)False

Question 20

An identifier assigned to an associative entity is also called a cross-relation key.

Accepted Answer

A) True 
 B)False

A relation is in first normal form if it has no more than one multivalued attribute.

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Data structures include data organized in the form of tables with rows and columns.

A primary key that consists of more than one attribute is called a:

The figure below is an example of mapping which type of relationship?

In the figure below, what type of relationship do the relations depict?

In the SQL language, the ________ statement is used to make table definitions.

The primary key of the many side migrates to the one side when transforming a one-to-many relationship.

In the figure below, what is depicted?

When two or more attributes describe the same characteristic of an entity, they are synonyms.

Discuss the two major occasions when you benefit from using normalization.

One property of a relation is that each attribute within a relation has a unique name.

The normal form which deals with multivalued dependencies is called:

A primary key is an attribute that uniquely identifies each row in a relation.

The entity integrity rule states that a primary key attribute can be null.

All of the following are the main goals of normalization EXCEPT:

There can be multivalued attributes in a relation.

When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.

In the figure below, each employee has exactly one manager.

An identifier assigned to an associative entity is also called a cross-relation key.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 4: Logical Database Design and the Relational Model

A relation is in first normal form if it has no more than one multivalued attribute.

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Data structures include data organized in the form of tables with rows and columns.

A primary key that consists of more than one attribute is called a:

The figure below is an example of mapping which type of relationship?

In the figure below, what type of relationship do the relations depict?

In the SQL language, the ________ statement is used to make table definitions.

The primary key of the many side migrates to the one side when transforming a one-to-many relationship.

In the figure below, what is depicted?

When two or more attributes describe the same characteristic of an entity, they are synonyms.

Discuss the two major occasions when you benefit from using normalization.

One property of a relation is that each attribute within a relation has a unique name.

The normal form which deals with multivalued dependencies is called:

A primary key is an attribute that uniquely identifies each row in a relation.

The entity integrity rule states that a primary key attribute can be null.

All of the following are the main goals of normalization EXCEPT:

There can be multivalued attributes in a relation.

When transforming a unary many-to-many relationship to relations, a recursive foreign key is used.

In the figure below, each employee has exactly one manager.

An identifier assigned to an associative entity is also called a cross-relation key.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters