Question 1

​Provide a definition for the term relation.

Accepted Answer

A relation is a two-dimensional table in which:
1.The entries in the table are single-valued; that is,each location in the table contains a single entry.
2.Each column has a distinct name
3.All values in a column are values of the same attributes
4.The order of columns is immaterial
5.Each row is distinct
6.The order of rows is immaterial

Question 2

​A query is a question represented in a way that the DBMS can recognize and process.

Accepted Answer

A) True 
 B)False  True

Question 3

The field on which records are sorted is called the ____________________.​

Accepted Answer

sort key

Question 4

​A(n)____________________ field is a field that is the result of a calculation using one or more existing fields.

Accepted Answer

The answer of ​A(n)____________________ field is a field that is...

Question 5

The product of two tables is also called the ____ product.​

Accepted Answer

A)   ​Cartesian
B)   ​aggregate
C)   ​Cathode
D)   ​exponential

Question 6

The comparison operators are +,*,%,and /.​

Accepted Answer

A) True 
 B)False

Question 7

Count,Sum,Avg,Max,and Min are a few of the built-in statistics or ____ functions that can be used in a query.​

Accepted Answer

A)   ​accumulated
B)   ​allowed
C)   ​primary
D)   ​aggregate

Question 8

If you are sorting records by more than one field,the more important field is called the ____.​

Accepted Answer

A)   ​primary sort key
B)   ​secondary sort key
C)   ​maximum sort key
D)   ​minor sort key

Question 9

An unnormalized relation is a table that has more than one row.​

Accepted Answer

A) True 
 B)False

Question 10

The ____ operation is performed by the SUBTRACT command in relational algebra.​

Accepted Answer

A)   ​union
B)   ​difference
C)   ​product
D)   ​intersection

Question 11

To list the records in a query's results in a particular order,you need to ____________________ the records.​

Accepted Answer

The answer of To list the records in a query's...

Question 12

A query that changes data is a(n)____ query.​

Accepted Answer

A)   ​addition
B)   ​update
C)   ​update
D)   ​select

Question 13

The ____ operator is used to concatenate every row in the first table with every row in the second table.​

Accepted Answer

A)   ​union
B)   ​difference
C)   ​product
D)   ​intersection

Question 14

____________________ is a theoretical way of manipulating a relational database.

Accepted Answer

The answer of ____________________ is a theoretical way of manipulating...

Question 15

The ____ command within relational algebra includes the word OVER followed by a list of the columns to be included.​

Accepted Answer

A)   ​DELETE
B)   ​PROJECT
C)   ​INTERSECT
D)   ​UNION

Question 16

​What is the difference between an AND criterion and an OR criterion? How is each criterion created in QBE?

Accepted Answer

The answer of ​What is the difference between an AND...

Question 17

The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.​

Accepted Answer

A)   ​primary
B)   ​secondary
C)   ​foreign
D)   ​minor

Question 18

List at least six of the aggregate functions available in Access.Explain how to use any of these functions in a query.​

Accepted Answer

The answer of List at least six of the aggregate...

Question 19

Access automatically adds double quotation marks around values in the design grid that are formatted as Short Text fields when you run the query or move the insertion point to another cell in the design grid.​

Accepted Answer

A) True 
 B)False

Question 20

Columns in a table are often called ____________________.​

Accepted Answer

The answer of Columns in a table are often called...

Exam 2: The Relational : Introduction, QBE, and Relational Algebra

Provide a definition for the term relation.

A query is a question represented in a way that the DBMS can recognize and process.

The field on which records are sorted is called the ____________________.

A(n)____________________ field is a field that is the result of a calculation using one or more existing fields.

The product of two tables is also called the ____ product.

The comparison operators are +,*,%,and /.

Count,Sum,Avg,Max,and Min are a few of the built-in statistics or ____ functions that can be used in a query.

If you are sorting records by more than one field,the more important field is called the ____.

An unnormalized relation is a table that has more than one row.

The ____ operation is performed by the SUBTRACT command in relational algebra.

To list the records in a query's results in a particular order,you need to ____________________ the records.

A query that changes data is a(n) ____ query.

The ____ operator is used to concatenate every row in the first table with every row in the second table.

____________________ is a theoretical way of manipulating a relational database.

The ____ command within relational algebra includes the word OVER followed by a list of the columns to be included.

What is the difference between an AND criterion and an OR criterion? How is each criterion created in QBE?

The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.

List at least six of the aggregate functions available in Access.Explain how to use any of these functions in a query.

Access automatically adds double quotation marks around values in the design grid that are formatted as Short Text fields when you run the query or move the insertion point to another cell in the design grid.

Columns in a table are often called ____________________.

Exam 2: The Relational : Introduction, QBE, and Relational Algebra

​Provide a definition for the term relation.

​A query is a question represented in a way that the DBMS can recognize and process.

The field on which records are sorted is called the ____________________.​

​A(n)____________________ field is a field that is the result of a calculation using one or more existing fields.

The product of two tables is also called the ____ product.​

The comparison operators are +,*,%,and /.​

Count,Sum,Avg,Max,and Min are a few of the built-in statistics or ____ functions that can be used in a query.​

If you are sorting records by more than one field,the more important field is called the ____.​

An unnormalized relation is a table that has more than one row.​

The ____ operation is performed by the SUBTRACT command in relational algebra.​

To list the records in a query's results in a particular order,you need to ____________________ the records.​

A query that changes data is a(n) ____ query.​

The ____ operator is used to concatenate every row in the first table with every row in the second table.​

____________________ is a theoretical way of manipulating a relational database.

The ____ command within relational algebra includes the word OVER followed by a list of the columns to be included.​

​What is the difference between an AND criterion and an OR criterion? How is each criterion created in QBE?

The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.​

List at least six of the aggregate functions available in Access.Explain how to use any of these functions in a query.​

Access automatically adds double quotation marks around values in the design grid that are formatted as Short Text fields when you run the query or move the insertion point to another cell in the design grid.​

Columns in a table are often called ____________________.​

Provide a definition for the term relation.

A query is a question represented in a way that the DBMS can recognize and process.

The field on which records are sorted is called the ____________________.

A(n)____________________ field is a field that is the result of a calculation using one or more existing fields.

The product of two tables is also called the ____ product.

The comparison operators are +,*,%,and /.

Count,Sum,Avg,Max,and Min are a few of the built-in statistics or ____ functions that can be used in a query.

If you are sorting records by more than one field,the more important field is called the ____.

An unnormalized relation is a table that has more than one row.

The ____ operation is performed by the SUBTRACT command in relational algebra.

To list the records in a query's results in a particular order,you need to ____________________ the records.

A query that changes data is a(n) ____ query.

The ____ operator is used to concatenate every row in the first table with every row in the second table.

The ____ command within relational algebra includes the word OVER followed by a list of the columns to be included.

What is the difference between an AND criterion and an OR criterion? How is each criterion created in QBE?

The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table.

List at least six of the aggregate functions available in Access.Explain how to use any of these functions in a query.

Access automatically adds double quotation marks around values in the design grid that are formatted as Short Text fields when you run the query or move the insertion point to another cell in the design grid.

Columns in a table are often called ____________________.