Question 1

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 2

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

Accepted Answer

A) True 
 B)False

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)  remove the determinant from the original relation 
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)  remove the determinant from the original relation 
E)  None of the above

Question 4

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 5

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

Accepted Answer

The answer of A(n)________ is a unique,numeric value that is...

Question 6

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 7

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 8

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 9

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 10

The first step of the normalization process is to identify all the candidate keys of a relation.

Accepted Answer

A) True 
 B)False

Question 11

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 12

In SQL Server,the starting value of a surrogate key is called the ________.

Accepted Answer

A)  identity 
B)  identity increment 
C)  identity Start 
D)  identity Seed 
E)  identity property 
A)  identity 
B)  identity increment 
C)  identity Start 
D)  identity Seed 
E)  identity property

Question 13

The first step of the normalization process is 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)  split the relation into two or more new relations 
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)  split the relation into two or more new relations

Question 14

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 15

Briefly describe the various tasks of the primary key.

Accepted Answer

The primary key is used for four primary

Question 16

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

Accepted Answer

Edit Relat

Question 17

Explain how to create a relationship in Microsoft Access.

Accepted Answer

In Microsoft Access,relationships are cr

Question 18

Null values can cause problems because they are ambiguous.

Accepted Answer

A) True 
 B)False

Question 19

In Microsoft Access,relationships between tables are created in the Relationships window.

Accepted Answer

A) True 
 B)False

Question 20

What are the basic steps of the normalization process?

Accepted Answer

Before starting the normalization proces

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

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

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

In Microsoft Access,a relationship between two tables is created ________.

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

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

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

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

Which of the following is not true about a relation?

The first step of the normalization process is to identify all the candidate keys of a relation.

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

In SQL Server,the starting value of a surrogate key is called the ________.

The first step of the normalization process is to ________.

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.

Briefly describe the various tasks of the primary key.

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

Explain how to create a relationship in Microsoft Access.

Null values can cause problems because they are ambiguous.

In Microsoft Access,relationships between tables are created in the Relationships window.

What are the basic steps of the normalization process?

Getting Started

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 2: The Relational Model

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

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

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

In Microsoft Access,a relationship between two tables is created ________.

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

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

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

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

Which of the following is not true about a relation?

The first step of the normalization process is to identify all the candidate keys of a relation.

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

In SQL Server,the starting value of a surrogate key is called the ________.

The first step of the normalization process is to ________.

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.

Briefly describe the various tasks of the primary key.

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

Explain how to create a relationship in Microsoft Access.

Null values can cause problems because they are ambiguous.

In Microsoft Access,relationships between tables are created in the Relationships window.

What are the basic steps of the normalization process?

Getting Started

Structured Query Language

Data Modeling and the Entity Relationship Model

Database Design

Database Administration

Database Processing Applications

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in Oracle Database XE 11g Release 2

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters