Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

A foreign key is a primary key of a relation that also is a primary key in another relation.

Accepted Answer

A) True 
 B)False

Question 3

An attribute that may have more than one meaning is called a(n):

Accepted Answer

A)  homonym. 
B)  alias. 
C)  double defined attribute. 
D)  synonym. 
A)  homonym. 
B)  alias. 
C)  double defined attribute. 
D)  synonym.

Question 4

A synonym is an attribute that may have more than one meaning.

Accepted Answer

A) True 
 B)False

Question 5

A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.

Accepted Answer

A) True 
 B)False

Question 6

The ________ states that no primary key attribute may be null.

Accepted Answer

A)  referential integrity constraint 
B)  entity integrity rule 
C)  partial specialization rule 
D)  range domain rule 
A)  referential integrity constraint 
B)  entity integrity rule 
C)  partial specialization rule 
D)  range domain rule

Question 7

An understanding of how to merge relation is important because:

Accepted Answer

A)  there may be a need to merge relations on projects with subteams. 
B)  different views may need to be integrated. 
C)  new data requirements may produce new relations to be merged. 
D)  all of the above. 
A)  there may be a need to merge relations on projects with subteams. 
B)  different views may need to be integrated. 
C)  new data requirements may produce new relations to be merged. 
D)  all of the above.

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Referring to the figure below,,which of the following is NOT true?

Accepted Answer

A)  A component is part of an item. 
B)  A component is always used in only one item. 
C)  A component can be part of an item. 
D)  A component may be used in many items. 
A)  A component is part of an item. 
B)  A component is always used in only one item. 
C)  A component can be part of an item. 
D)  A component may be used in many items.

Question 10

An anomaly is a type of flaw in the database server.

Accepted Answer

A) True 
 B)False

Question 11

An attribute in a relation that serves as the primary key of another relation in the same database is called a(n)________.

Accepted Answer

The answer of An attribute in a relation that serves...

Question 12

A partial functional dependency is a functional dependency in which one or more non-key attributes are functionally dependent on part (but not all)of the primary key.

Accepted Answer

A) True 
 B)False

Question 13

Discuss why it is a good idea to create an instance of your relational schema with sample data.

Accepted Answer

Using sample data allows you to test any

Question 14

How do you convert weak entities to relations?

Accepted Answer

A weak entity becomes a relation.However

Question 15

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.

Accepted Answer

A)  Business rule constraint 
B)  Data integrity 
C)  Business integrity 
D)  Data structure 
A)  Business rule constraint 
B)  Data integrity 
C)  Business integrity 
D)  Data structure

Question 16

A ________ dependency is a functional dependency between the primary key and one or more nonkey attributes that are dependent upon the primary key via another nonkey attribute.

Accepted Answer

The answer of A ________ dependency is a functional dependency...

Question 17

The relational data model consists of which components?

Accepted Answer

A)  Data structure 
B)  Data manipulation 
C)  Data integrity 
D)  All of the above 
A)  Data structure 
B)  Data manipulation 
C)  Data integrity 
D)  All of the above

Question 18

A candidate key must satisfy all of the following conditions EXCEPT:

Accepted Answer

A)  the key must uniquely identify the row. 
B)  the key must indicate the row's position in the table. 
C)  the key must be nonredundant. 
D)  each nonkey attribute is functionally dependent upon it. 
A)  the key must uniquely identify the row. 
B)  the key must indicate the row's position in the table. 
C)  the key must be nonredundant. 
D)  each nonkey attribute is functionally dependent upon it.

Question 19

In the relational data model,associations between tables are defined through the use of primary keys.

Accepted Answer

A) True 
 B)False

Question 20

A cascading delete removes all records in other tables associated with the record to be deleted.

Accepted Answer

A) True 
 B)False

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

A foreign key is a primary key of a relation that also is a primary key in another relation.

An attribute that may have more than one meaning is called a(n):

A synonym is an attribute that may have more than one meaning.

A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.

The ________ states that no primary key attribute may be null.

An understanding of how to merge relation is important because:

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

Referring to the figure below,,which of the following is NOT true?

An anomaly is a type of flaw in the database server.

An attribute in a relation that serves as the primary key of another relation in the same database is called a(n)________.

A partial functional dependency is a functional dependency in which one or more non-key attributes are functionally dependent on part (but not all)of the primary key.

Discuss why it is a good idea to create an instance of your relational schema with sample data.

How do you convert weak entities to relations?

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.

A ________ dependency is a functional dependency between the primary key and one or more nonkey attributes that are dependent upon the primary key via another nonkey attribute.

The relational data model consists of which components?

A candidate key must satisfy all of the following conditions EXCEPT:

In the relational data model,associations between tables are defined through the use of primary keys.

A cascading delete removes all records in other tables associated with the record to be deleted.

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

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

A foreign key is a primary key of a relation that also is a primary key in another relation.

An attribute that may have more than one meaning is called a(n):

A synonym is an attribute that may have more than one meaning.

A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.

The ________ states that no primary key attribute may be null.

An understanding of how to merge relation is important because:

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

Referring to the figure below,,which of the following is NOT true?

An anomaly is a type of flaw in the database server.

An attribute in a relation that serves as the primary key of another relation in the same database is called a(n)________.

A partial functional dependency is a functional dependency in which one or more non-key attributes are functionally dependent on part (but not all)of the primary key.

Discuss why it is a good idea to create an instance of your relational schema with sample data.

How do you convert weak entities to relations?

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.

A ________ dependency is a functional dependency between the primary key and one or more nonkey attributes that are dependent upon the primary key via another nonkey attribute.

The relational data model consists of which components?

A candidate key must satisfy all of the following conditions EXCEPT:

In the relational data model,associations between tables are defined through the use of primary keys.

A cascading delete removes all records in other tables associated with the record to be deleted.

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