Question 1

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

Question 2

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 3

What requirements must a two-dimensional table satisfy in order to be a relation?

Accepted Answer

For a table to be considered a relation,

Question 4

In the relational model,each row of a table contains data that represents an attribute of the entity.

Accepted Answer

A) True 
 B)False

Question 5

A table that meets the requirements of a relation is said to be in which normal form?

Accepted Answer

A) Relational normal form (RNF) 
B) First normal form 
C) Second normal form 
D) Boyce-Codd normal form 
E) Domain/key normal form 
A) Relational normal form (RNF) 
B) First normal form 
C) Second normal form 
D) Boyce-Codd normal form 
E) Domain/key normal form

Question 6

Microsoft Access forms can only contain data from one table.

Accepted Answer

A) True 
 B)False

Question 7

Explain how to create a relationship in Microsoft Access.

Accepted Answer

In Microsoft Access,relationships are cr

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

Normalization is the process of removing all functional dependencies from a relation.

Accepted Answer

A) True 
 B)False

Question 10

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 11

To create a well-formed relation through normalization,every determinant must be a candidate key.

Accepted Answer

A) True 
 B)False

Question 12

A primary key is:

Accepted Answer

A) required to be unique. 
B) used to represent rows in relationships. 
C) a candidate key. 
D) used to identify unique rows. 
E) All of the above 
A) required to be unique. 
B) used to represent rows in relationships. 
C) a candidate key. 
D) used to identify unique rows. 
E) All of the above

Question 13

Surrogate key values have no meaning to the users.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Given the relations: 
$\text { STUDENT (\underline{SID}, StudentName, Major, AdvisorID) }$
$\text { ADVISOR (\underline{AdvisorID}, AdvisorName, Office, Phone) }$
Such that each student is assigned to one advisor,which of the following is true?

Accepted Answer

A) SID is both a primary key and a foreign key. 
B) AdvisorName is a determinant. 
C) AdvisorID is a foreign key. 
D) Phone is a candidate key. 
E) Major is a candidate key. 
A) SID is both a primary key and a foreign key. 
B) AdvisorName is a determinant. 
C) AdvisorID is a foreign key. 
D) Phone is a candidate key. 
E) Major is a candidate key.

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Since Microsoft Access is a personal database,it is not subject to the modification problems that occur in other relational databases.

Accepted Answer

A) True 
 B)False

Question 18

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

Accepted Answer

functional

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

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

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).

Which of the following is not true of surrogate keys?

What requirements must a two-dimensional table satisfy in order to be a relation?

In the relational model,each row of a table contains data that represents an attribute of the entity.

A table that meets the requirements of a relation is said to be in which normal form?

Microsoft Access forms can only contain data from one table.

Explain how to create a relationship in Microsoft Access.

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

Normalization is the process of removing all functional dependencies from a relation.

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

To create a well-formed relation through normalization,every determinant must be a candidate key.

A primary key is:

Surrogate key values have no meaning to the users.

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

Given the relations: $\text { STUDENT (\underline{SID}, StudentName, Major, AdvisorID) }$ $\text { ADVISOR (\underline{AdvisorID}, AdvisorName, Office, Phone) }$ Such that each student is assigned to one advisor,which of the following is true?

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

Since Microsoft Access is a personal database,it is not subject to the modification problems that occur in other relational databases.

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

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

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

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

Exam 2: The Relational Model

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).

Which of the following is not true of surrogate keys?

What requirements must a two-dimensional table satisfy in order to be a relation?

In the relational model,each row of a table contains data that represents an attribute of the entity.

A table that meets the requirements of a relation is said to be in which normal form?

Microsoft Access forms can only contain data from one table.

Explain how to create a relationship in Microsoft Access.

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

Normalization is the process of removing all functional dependencies from a relation.

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

To create a well-formed relation through normalization,every determinant must be a candidate key.

A primary key is:

Surrogate key values have no meaning to the users.

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

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

Since Microsoft Access is a personal database,it is not subject to the modification problems that occur in other relational databases.

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

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

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

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 2014 Express Edition

Getting Started With Oracle Database Express Edition 11g Release 2

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters