Question 1

Discuss the properties of relations.

Accepted Answer

Each relation (or table)has a unique nam

Question 2

A relation in fifth normal form may not contain any anomalies.

Accepted Answer

A) True 
 B)False

Question 3

An error or inconsistency resulting from redundancy in tables is called a(n)________.

Accepted Answer

The answer of An error or inconsistency resulting from redundancy...

Question 4

The truncate table statement in SQL creates a new table.

Accepted Answer

A) True 
 B)False

Question 5

A weak entity must always have a(n)________ that distinguishes the various occurrences of the weak entity for each owner entity instance.

Accepted Answer

The answer of A weak entity must always have a(n)________...

Question 6

A(n)________ is a rule that states that either each foreign key value must match a primary key value in another relation or the foreign key value must be null.

Accepted Answer

referentia

Question 7

Which of the following are properties of relations?

Accepted Answer

A)  Each attribute has a unique name. 
B)  No two rows in a relation are identical. 
C)  There are no multivalued attributes in a relation. 
D)  All of the above. 
A)  Each attribute has a unique name. 
B)  No two rows in a relation are identical. 
C)  There are no multivalued attributes in a relation. 
D)  All of the above.

Question 8

The first step in transforming EER diagrams into relations is to ________.

Accepted Answer

map regula

Question 9

Discuss the various relational keys.

Accepted Answer

A primary key uniquely identifies each r

Question 10

View integration is the process of merging relations together.

Accepted Answer

A) True 
 B)False

Question 11

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 12

All values that appear in a column of a relation must be taken from the same domain.

Accepted Answer

A) True 
 B)False

Question 13

A ________ is a functional dependency where one or more nonkey attributes are functionally dependent on part (but not all)of the primary key.

Accepted Answer

partial fu

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

Accepted Answer

A) True 
 B)False

Question 16

Understanding the steps involved in transforming EER diagrams into relations is important because:

Accepted Answer

A)  you must be able to check the output of a CASE tool. 
B)  there are rarely legitimate alternatives from which to choose. 
C)  CASE tools can model any situation. 
D)  none of the above. 
A)  you must be able to check the output of a CASE tool. 
B)  there are rarely legitimate alternatives from which to choose. 
C)  CASE tools can model any situation. 
D)  none of the above.

Question 17

An attribute or combination of attributes that uniquely identifies a row in a relation is called a(n)________.

Accepted Answer

The answer of An attribute or combination of attributes that...

Question 18

A functional dependency in which one or more nonkey attributes are functionally dependent on part,but not all,of the primary key is called a __________ dependency.

Accepted Answer

A)  partial key-based 
B)  partial functional 
C)  cross key 
D)  merged relation 
A)  partial key-based 
B)  partial functional 
C)  cross key 
D)  merged relation

Question 19

A co-dependency is a constraint between two attributes or two sets of attributes.

Accepted Answer

A) True 
 B)False

Question 20

A domain definition consists of the following components EXCEPT:

Accepted Answer

A)  domain name. 
B)  data type. 
C)  integrity constraints. 
D)  size. 
A)  domain name. 
B)  data type. 
C)  integrity constraints. 
D)  size.

Discuss the properties of relations.

A relation in fifth normal form may not contain any anomalies.

An error or inconsistency resulting from redundancy in tables is called a(n)________.

The truncate table statement in SQL creates a new table.

A weak entity must always have a(n)________ that distinguishes the various occurrences of the weak entity for each owner entity instance.

A(n)________ is a rule that states that either each foreign key value must match a primary key value in another relation or the foreign key value must be null.

Which of the following are properties of relations?

The first step in transforming EER diagrams into relations is to ________.

Discuss the various relational keys.

View integration is the process of merging relations together.

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

All values that appear in a column of a relation must be taken from the same domain.

A ________ is a functional dependency where one or more nonkey attributes are functionally dependent on part (but not all)of the primary key.

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

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

Understanding the steps involved in transforming EER diagrams into relations is important because:

An attribute or combination of attributes that uniquely identifies a row in a relation is called a(n)________.

A functional dependency in which one or more nonkey attributes are functionally dependent on part,but not all,of the primary key is called a __________ dependency.

A co-dependency is a constraint between two attributes or two sets of attributes.

A domain definition consists of the following components EXCEPT:

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

Discuss the properties of relations.

A relation in fifth normal form may not contain any anomalies.

An error or inconsistency resulting from redundancy in tables is called a(n)________.

The truncate table statement in SQL creates a new table.

A weak entity must always have a(n)________ that distinguishes the various occurrences of the weak entity for each owner entity instance.

A(n)________ is a rule that states that either each foreign key value must match a primary key value in another relation or the foreign key value must be null.

Which of the following are properties of relations?

The first step in transforming EER diagrams into relations is to ________.

Discuss the various relational keys.

View integration is the process of merging relations together.

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

All values that appear in a column of a relation must be taken from the same domain.

A ________ is a functional dependency where one or more nonkey attributes are functionally dependent on part (but not all)of the primary key.

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

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

Understanding the steps involved in transforming EER diagrams into relations is important because:

An attribute or combination of attributes that uniquely identifies a row in a relation is called a(n)________.

A functional dependency in which one or more nonkey attributes are functionally dependent on part,but not all,of the primary key is called a __________ dependency.

A co-dependency is a constraint between two attributes or two sets of attributes.

A domain definition consists of the following components EXCEPT:

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