Question 1

In the normalization process,it isnotnecessary 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. B

Question 2

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 B

Question 3

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 E

Question 4

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Which of the following isnot true about null values?

Accepted Answer

A) A null value can mean that the value is unknown. 
B) A null value is ambiguous. 
C) A null value can mean that the value is known to be blank. 
D) A null value can mean that no value for the field is appropriate. 
E) Null values cannot be avoided. 
A) A null value can mean that the value is unknown. 
B) A null value is ambiguous. 
C) A null value can mean that the value is known to be blank. 
D) A null value can mean that no value for the field is appropriate. 
E) Null values cannot be avoided.

Question 7

Explain the concept of a foreign key.

Accepted Answer

To implement a relationship within a rel

Question 8

The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.

Accepted Answer

The answer of The key that has been designated the...

Question 9

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

Accepted Answer

A) True 
 B)False

Question 10

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.

Question 11

When the primary key of one relation is placed in a second relation to represent a relationship,the attribute in the second relation is called a(n)________ key.

Accepted Answer

The answer of When the primary key of one relation...

Question 12

To represent a relationship in the relational model,the primary key of one relation is placed into a second relation.

Accepted Answer

A) True 
 B)False

Question 13

A(n)________ is one or more columns of a relation that is used to identify a row.

Accepted Answer

The answer of A(n)________ is one or more columns of...

Question 14

Which of the following is true about a key?

Accepted Answer

A) It may be unique. 
B) It may be non-unique. 
C) In may identify more than one row. 
D) Both A and B 
E) All of the above 
A) It may be unique. 
B) It may be non-unique. 
C) In may identify more than one row. 
D) Both A and B 
E) All of the above

Question 15

In the normalization process,if you find that every determinant in a relation is a candidate key then you have determined that:

Accepted Answer

A) the relation is well formed. 
B) the relation needs to be broken into two or more new relations. 
C) surrogate keys in the relation may not be correctly linked to other relations. 
D) the relation needs to have foreign keys added in order to be correctly linked to other relations. 
E) referential integrity constraints concerning the relation need to be established. 
A) the relation is well formed. 
B) the relation needs to be broken into two or more new relations. 
C) surrogate keys in the relation may not be correctly linked to other relations. 
D) the relation needs to have foreign keys added in order to be correctly linked to other relations. 
E) referential integrity constraints concerning the relation need to be established.

Question 16

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 17

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

Accepted Answer

A) True 
 B)False

Question 18

While the relational model for databases appears to hold much promise,few commercial databases have implemented it.

Accepted Answer

A) True 
 B)False

Question 19

One important relational design principle is that:

Accepted Answer

A) every determinant must be a candidate key. 
B) every candidate key must not be a determinant. 
C) every primary key must be a surrogate key. 
D) every determinant must be functionally dependent on the primary key. 
E) every primary key must be functionally dependent on every determinant. 
A) every determinant must be a candidate key. 
B) every candidate key must not be a determinant. 
C) every primary key must be a surrogate key. 
D) every determinant must be functionally dependent on the primary key. 
E) every primary key must be functionally dependent on every determinant.

Question 20

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.

In the normalization process,it isnotnecessary to:

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

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

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

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

Which of the following isnot true about null values?

Explain the concept of a foreign key.

The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

In Microsoft Access,relationships between tables are created:

When the primary key of one relation is placed in a second relation to represent a relationship,the attribute in the second relation is called a(n)________ key.

To represent a relationship in the relational model,the primary key of one relation is placed into a second relation.

A(n)________ is one or more columns of a relation that is used to identify a row.

Which of the following is true about a key?

In the normalization process,if you find that every determinant in a relation is a candidate key then you have determined that:

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

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

While the relational model for databases appears to hold much promise,few commercial databases have implemented it.

One important relational design principle is that:

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

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

In the normalization process,it isnotnecessary to:

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

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

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

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

Which of the following isnot true about null values?

Explain the concept of a foreign key.

The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

In Microsoft Access,relationships between tables are created:

When the primary key of one relation is placed in a second relation to represent a relationship,the attribute in the second relation is called a(n)________ key.

To represent a relationship in the relational model,the primary key of one relation is placed into a second relation.

A(n)________ is one or more columns of a relation that is used to identify a row.

Which of the following is true about a key?

In the normalization process,if you find that every determinant in a relation is a candidate key then you have determined that:

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

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

While the relational model for databases appears to hold much promise,few commercial databases have implemented it.

One important relational design principle is that:

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

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