Question 1

A rule that requires every value in a foreign key to match values in the corresponding primary key is called a(n)________ constraint.

Accepted Answer

referentia

Question 2

The primary key is used both to identify unique rows in a relation and to represent rows in relationships.

Accepted Answer

A) True 
 B)False

Question 3

To be a well-formed relation,every ________ in the relation must be a candidate key.

Accepted Answer

The answer of To be a well-formed relation,every ________ in...

Question 4

Distinguish between the primary key and a candidate key.

Accepted Answer

Both the primary key and a candidate key

Question 5

The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.

Accepted Answer

A) True 
 B)False

Question 6

Although Microsoft Access is a personal database,the database tables in Access are still subject to ________ if they are not well-formed.

Accepted Answer

modificati

Question 7

In the normalization process,it is not necessary to:

Accepted Answer

A)  identify all the candidate keys of a relation. 
B)  identify all the foreign keys of a relation. 
C)  identify all the functional dependencies of a relation. 
D)  identify all the determinants of a relation. 
E)  determine if every determinant is a candidate key. 
A)  identify all the candidate keys of a relation. 
B)  identify all the foreign keys of a relation. 
C)  identify all the functional dependencies of a relation. 
D)  identify all the determinants of a relation. 
E)  determine if every determinant is a candidate key.

Question 8

Explain how to create a relationship in Microsoft Access.

Accepted Answer

In Microsoft Access,relationships are cr

Question 9

In Microsoft Access,a relationship between two tables is created:

Accepted Answer

A)  by entering the name of the foreign key in the appropriate table in Design View. 
B)  by entering the name of the primary key in the appropriate table in Design View. 
C)  by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window. 
D)  by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window. 
E)  by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window. 
A)  by entering the name of the foreign key in the appropriate table in Design View. 
B)  by entering the name of the primary key in the appropriate table in Design View. 
C)  by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window. 
D)  by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window. 
E)  by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window.

Question 10

Null values can cause problems because they are ambiguous.

Accepted Answer

A) True 
 B)False

Question 11

In Microsoft Access,referential integrity constraints are created:

Accepted Answer

A)  by setting a property value on the primary key in the table which contains it. 
B)  by setting a property value on the foreign key in the table which contains it. 
C)  by setting a property value on the primary key in the Relationships window. 
D)  by setting a property value on the foreign key in the Relationships window. 
E)  by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box. 
A)  by setting a property value on the primary key in the table which contains it. 
B)  by setting a property value on the foreign key in the table which contains it. 
C)  by setting a property value on the primary key in the Relationships window. 
D)  by setting a property value on the foreign key in the Relationships window. 
E)  by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box.

Question 12

Every table is a relation,but not every relation is a table.

Accepted Answer

A) True 
 B)False

Question 13

When the primary key of one relation is placed into a second relation,it is called a:

Accepted Answer

A)  field key. 
B)  referential integrity. 
C)  foreign key. 
D)  candidate key. 
E)  relocated key. 
A)  field key. 
B)  referential integrity. 
C)  foreign key. 
D)  candidate key. 
E)  relocated key.

Question 14

Which of the following functional dependency diagrams accurately represents the following situation: • A campus has many buildings.
• Each building has a unique name.
• Each building has many rooms.
• All rooms in any given building are numbered sequentially starting at "101."
• Each room has a certain capacity,although many rooms in the same building or different buildings may have the same capacity.
• Each room is assigned to a single department.
• A department may have many rooms in one or more buildings,each with the same or different capacities.

Accepted Answer

A)  BuildingName → (RoomNumber, Capacity, Department) 
B)  RoomNumber → (BuildingName, Department, Capacity) 
C)  (Department, Capacity) → (BuildingName, RoomNumber) 
D)  (BuildingName, Capacity) → (Department, RoomNumber) 
E)  (BuildingName, RoomNumber) → (Capacity, Department) 
A)  BuildingName → (RoomNumber, Capacity, Department) 
B)  RoomNumber → (BuildingName, Department, Capacity) 
C)  (Department, Capacity) → (BuildingName, RoomNumber) 
D)  (BuildingName, Capacity) → (Department, RoomNumber) 
E)  (BuildingName, RoomNumber) → (Capacity, Department)

Question 15

Explain the possible interpretations of a null value.

Accepted Answer

The problem with allowing null values in

Question 16

Which of the following terms is synonymous with "tuple"?

Accepted Answer

A)  Attribute 
B)  Table 
C)  Field 
D)  Row 
E)  Relation 
A)  Attribute 
B)  Table 
C)  Field 
D)  Row 
E)  Relation

Question 17

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

Accepted Answer

A) True 
 B)False

Question 18

A key that contains two or more attributes is called a(n)________ key.

Accepted Answer

The answer of A key that contains two or more...

Question 19

During the normalization process,the remedy for a relation that is not well formed is to:

Accepted Answer

A)  create a surrogate key. 
B)  create a functional dependency. 
C)  break it into two or more relations that are well formed. 
D)  combine it with another relation that is well formed. 
E)  convert it into a list. 
A)  create a surrogate key. 
B)  create a functional dependency. 
C)  break it into two or more relations that are well formed. 
D)  combine it with another relation that is well formed. 
E)  convert it into a list.

Question 20

In the normalization process,if you find a candidate key that is not a determinant then you should:

Accepted Answer

A)  place the columns of the functional dependency in a new relation. 
B)  make the determinant of the functional dependency the primary key of the new relation. 
C)  leave a copy of the determinant as a foreign key in the original relation. 
D)  All of the above 
E)  None of the above 
A)  place the columns of the functional dependency in a new relation. 
B)  make the determinant of the functional dependency the primary key of the new relation. 
C)  leave a copy of the determinant as a foreign key in the original relation. 
D)  All of the above 
E)  None of the above

A rule that requires every value in a foreign key to match values in the corresponding primary key is called a(n)________ constraint.

The primary key is used both to identify unique rows in a relation and to represent rows in relationships.

To be a well-formed relation,every ________ in the relation must be a candidate key.

Distinguish between the primary key and a candidate key.

The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.

Although Microsoft Access is a personal database,the database tables in Access are still subject to ________ if they are not well-formed.

In the normalization process,it is not necessary to:

Explain how to create a relationship in Microsoft Access.

In Microsoft Access,a relationship between two tables is created:

Null values can cause problems because they are ambiguous.

In Microsoft Access,referential integrity constraints are created:

Every table is a relation,but not every relation is a table.

When the primary key of one relation is placed into a second relation,it is called a:

Explain the possible interpretations of a null value.

Which of the following terms is synonymous with "tuple"?

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

A key that contains two or more attributes is called a(n)________ key.

During the normalization process,the remedy for a relation that is not well formed is to:

In the normalization process,if you find a candidate key that is not a determinant then you should:

Getting Started

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 2: The Relational Model

A rule that requires every value in a foreign key to match values in the corresponding primary key is called a(n)________ constraint.

The primary key is used both to identify unique rows in a relation and to represent rows in relationships.

To be a well-formed relation,every ________ in the relation must be a candidate key.

Distinguish between the primary key and a candidate key.

The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.

Although Microsoft Access is a personal database,the database tables in Access are still subject to ________ if they are not well-formed.

In the normalization process,it is not necessary to:

Explain how to create a relationship in Microsoft Access.

In Microsoft Access,a relationship between two tables is created:

Null values can cause problems because they are ambiguous.

In Microsoft Access,referential integrity constraints are created:

Every table is a relation,but not every relation is a table.

When the primary key of one relation is placed into a second relation,it is called a:

Explain the possible interpretations of a null value.

Which of the following terms is synonymous with "tuple"?

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

A key that contains two or more attributes is called a(n)________ key.

During the normalization process,the remedy for a relation that is not well formed is to:

In the normalization process,if you find a candidate key that is not a determinant then you should:

Getting Started

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters