Question 1

When a regular entity type contains a multivalued attribute,one must:

Accepted Answer

A)  create a single relation with multiple lines for each instance of the multivalued attribute. 
B)  create two new relations, one containing the multivalued attribute. 
C)  create two new relations, both containing the multivalued attribute. 
D)  none of the above. 
A)  create a single relation with multiple lines for each instance of the multivalued attribute. 
B)  create two new relations, one containing the multivalued attribute. 
C)  create two new relations, both containing the multivalued attribute. 
D)  none of the above.

Question 2

List and explain all of the normal forms.

Accepted Answer

There are six different normal forms,all

Question 3

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 4

CASE tools can model more complex data relationships,such as ternary relationships.

Accepted Answer

A) True 
 B)False

Question 5

A(n)________ is a primary key that is unique across all relations.

Accepted Answer

The answer of A(n)________ is a primary key that is...

Question 6

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

Accepted Answer

A)  Sample data can be used to improve user communications. 
B)  Sample data can be used for prototype generation. 
C)  Sample data can reverse database implementation errors. 
D)  Sample data provide a convenient way to check the accuracy of your design. 
A)  Sample data can be used to improve user communications. 
B)  Sample data can be used for prototype generation. 
C)  Sample data can reverse database implementation errors. 
D)  Sample data provide a convenient way to check the accuracy of your design.

Question 7

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 8

A primary key that consists of two or more attributes is called a(n)________ key.

Accepted Answer

The answer of A primary key that consists of two...

Question 9

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

Accepted Answer

A)  Strong entity/weak entity 
B)  Multivalued 
C)  Composite foreign key 
D)  One-to-many 
A)  Strong entity/weak entity 
B)  Multivalued 
C)  Composite foreign key 
D)  One-to-many

Question 10

When a regular entity type contains a multivalued attribute,two relations are created.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

A relation that contains no multivalued attributes is in ________ normal form.

Accepted Answer

The answer of A relation that contains no multivalued attributes...

Question 13

A transversal dependency is a functional dependency between two or more nonkey attributes.

Accepted Answer

A) True 
 B)False

Question 14

A form of database specification that indicates all the parameters for data storage that are then input to database implementation is:

Accepted Answer

A)  logical. 
B)  physical. 
C)  schematic. 
D)  conceptual. 
A)  logical. 
B)  physical. 
C)  schematic. 
D)  conceptual.

Question 15

Discuss the types of integrity constraints.

Accepted Answer

The three major types of integrity const

Question 16

A constraint between two attributes is called a(n):

Accepted Answer

A)  functional relation. 
B)  attribute dependency. 
C)  functional dependency. 
D)  functional relation constraint. 
A)  functional relation. 
B)  attribute dependency. 
C)  functional dependency. 
D)  functional relation constraint.

Question 17

Unlike columns,the rows of a relation may not be interchanged and must be stored in one sequence.

Accepted Answer

A) True 
 B)False

Question 18

A named,two-dimensional table of data is called a(n)________.

Accepted Answer

The answer of A named,two-dimensional table of data is called...

Question 19

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 20

Which of the following are anomalies that can be caused by redundancies in tables?

Accepted Answer

A)  Insertion 
B)  Deletion 
C)  Modification 
D)  All of the above 
A)  Insertion 
B)  Deletion 
C)  Modification 
D)  All of the above

When a regular entity type contains a multivalued attribute,one must:

List and explain all of the normal forms.

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

CASE tools can model more complex data relationships,such as ternary relationships.

A(n)________ is a primary key that is unique across all relations.

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

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

A primary key that consists of two or more attributes is called a(n)________ key.

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

When a regular entity type contains a multivalued attribute,two relations are created.

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

A relation that contains no multivalued attributes is in ________ normal form.

A transversal dependency is a functional dependency between two or more nonkey attributes.

A form of database specification that indicates all the parameters for data storage that are then input to database implementation is:

Discuss the types of integrity constraints.

A constraint between two attributes is called a(n):

Unlike columns,the rows of a relation may not be interchanged and must be stored in one sequence.

A named,two-dimensional table of data is called a(n)________.

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

Which of the following are anomalies that can be caused by redundancies in tables?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 4: Logical Database Design and the Relational Model

When a regular entity type contains a multivalued attribute,one must:

List and explain all of the normal forms.

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

CASE tools can model more complex data relationships,such as ternary relationships.

A(n)________ is a primary key that is unique across all relations.

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

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

A primary key that consists of two or more attributes is called a(n)________ key.

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

When a regular entity type contains a multivalued attribute,two relations are created.

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

A relation that contains no multivalued attributes is in ________ normal form.

A transversal dependency is a functional dependency between two or more nonkey attributes.

A form of database specification that indicates all the parameters for data storage that are then input to database implementation is:

Discuss the types of integrity constraints.

A constraint between two attributes is called a(n):

Unlike columns,the rows of a relation may not be interchanged and must be stored in one sequence.

A named,two-dimensional table of data is called a(n)________.

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

Which of the following are anomalies that can be caused by redundancies in tables?

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters