Question 1

In Microsoft Access,relationships between tables are created:

Accepted Answer

A)  by the Relationships button on the Create command tab. 
B)  by the Relationships button on the Home command tab. 
C)  in the Relationships window. 
D)  in the Table window of the table containing the primary key. 
E)  in the Table window of the table containing the foreign key. 
A)  by the Relationships button on the Create command tab. 
B)  by the Relationships button on the Home command tab. 
C)  in the Relationships window. 
D)  in the Table window of the table containing the primary key. 
E)  in the Table window of the table containing the foreign key. C

Question 2

A(n)________ is a unique,numeric value that is appended to the relation to serve as the primary key.

Accepted Answer

surrogate key

Question 3

Given the functional dependency for the attributes of ENTITY1,X → (A,B,C),X is a candidate key for the relation ENTITY1 (A,B,C,X).

Accepted Answer

A) True 
 B)False  True

Question 4

In the normalization process,if you find a candidate key that is not a primary key 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

Question 5

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

Accepted Answer

A)  Attribute 
B)  Table 
C)  Record 
D)  Row 
E)  Tuple 
A)  Attribute 
B)  Table 
C)  Record 
D)  Row 
E)  Tuple

Question 6

Explain the concept of a functional dependency.

Accepted Answer

A functional dependency is a relationshi

Question 7

In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.

Accepted Answer

A) True 
 B)False

Question 8

Although Microsoft Access is a personal database,it is still subject to the following modification problem(s):

Accepted Answer

A)  problems adding data. 
B)  problems changing data. 
C)  problems deleting data. 
D)  All of the above 
E)  None of the above 
A)  problems adding data. 
B)  problems changing data. 
C)  problems deleting data. 
D)  All of the above 
E)  None of the above

Question 9

Since surrogate keys are used to uniquely identify rows,their values are normally displayed prominently on all forms and reports for the users to see.

Accepted Answer

A) True 
 B)False

Question 10

Microsoft Access forms can only contain data from one table.

Accepted Answer

A) True 
 B)False

Question 11

In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.

Accepted Answer

The answer of In Microsoft Access,the Relationships window is accessed...

Question 12

Which of the following is not true about a relation?

Accepted Answer

A)  A relation is a two-dimensional table. 
B)  The cells of a relation must hold a single value. 
C)  A relation may have duplicate column names. 
D)  A relation may not have duplicate rows. 
E)  The order of the rows of a relation is insignificant. 
A)  A relation is a two-dimensional table. 
B)  The cells of a relation must hold a single value. 
C)  A relation may have duplicate column names. 
D)  A relation may not have duplicate rows. 
E)  The order of the rows of a relation is insignificant.

Question 13

Any table that meets the requirements of a(n)________ is in first normal form.

Accepted Answer

The answer of Any table that meets the requirements of...

Question 14

The unique keys that are not chosen to be the primary key are called ________ keys.

Accepted Answer

The answer of The unique keys that are not chosen...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

In Microsoft Access,referential integrity constraints are created in the ________.

Accepted Answer

Edit Relat

Question 17

Explain the concept of a foreign key.

Accepted Answer

To implement a relationship within a rel

Question 18

In the normalization process,it is necessary to identify all the determinants in a relation.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not true of surrogate keys?

Accepted Answer

A)  They are meaningful to the users. 
B)  They are numeric. 
C)  They are usually generated by the DBMS. 
D)  They are unique. 
E)  They are usually hidden on forms and reports. 
A)  They are meaningful to the users. 
B)  They are numeric. 
C)  They are usually generated by the DBMS. 
D)  They are unique. 
E)  They are usually hidden on forms and reports.

Question 20

Explain the concept of a surrogate key.

Accepted Answer

A surrogate key is an artificial key tha

In Microsoft Access,relationships between tables are created:

A(n)________ is a unique,numeric value that is appended to the relation to serve as the primary key.

Given the functional dependency for the attributes of ENTITY1,X → (A,B,C),X is a candidate key for the relation ENTITY1 (A,B,C,X).

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

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

Explain the concept of a functional dependency.

In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.

Although Microsoft Access is a personal database,it is still subject to the following modification problem(s):

Since surrogate keys are used to uniquely identify rows,their values are normally displayed prominently on all forms and reports for the users to see.

Microsoft Access forms can only contain data from one table.

In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.

Which of the following is not true about a relation?

Any table that meets the requirements of a(n)________ is in first normal form.

The unique keys that are not chosen to be the primary key are called ________ keys.

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

In Microsoft Access,referential integrity constraints are created in the ________.

Explain the concept of a foreign key.

In the normalization process,it is necessary to identify all the determinants in a relation.

Which of the following is not true of surrogate keys?

Explain the concept of a surrogate key.

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

In Microsoft Access,relationships between tables are created:

A(n)________ is a unique,numeric value that is appended to the relation to serve as the primary key.

Given the functional dependency for the attributes of ENTITY1,X → (A,B,C),X is a candidate key for the relation ENTITY1 (A,B,C,X).

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

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

Explain the concept of a functional dependency.

In Microsoft Access,foreign keys are designated by using the Foreign Key button in the toolbar.

Although Microsoft Access is a personal database,it is still subject to the following modification problem(s):

Since surrogate keys are used to uniquely identify rows,their values are normally displayed prominently on all forms and reports for the users to see.

Microsoft Access forms can only contain data from one table.

In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.

Which of the following is not true about a relation?

Any table that meets the requirements of a(n)________ is in first normal form.

The unique keys that are not chosen to be the primary key are called ________ keys.

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

In Microsoft Access,referential integrity constraints are created in the ________.

Explain the concept of a foreign key.

In the normalization process,it is necessary to identify all the determinants in a relation.

Which of the following is not true of surrogate keys?

Explain the concept of a surrogate key.

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