Question 1

The definition for a primary key really defines a candidate key as well.

Accepted Answer

A) True 
 B)False

Question 2

A(n)____________________ is another name for a record or a row.

Accepted Answer

The answer of A(n)____________________ is another name for a record...

Question 3

Define a relation.

Accepted Answer

A relation is a two-dimensional table in

Question 4

The ____________________ key of a table (relation)is the column or collection of columns that uniquely identifies a given row in that table.

Accepted Answer

The answer of The ____________________ key of a table (relation)is...

Question 5

A primary key always comprises a single column.

Accepted Answer

A) True 
 B)False

Question 6

In this text,Boyce-Codd normal form is the same as ____.

Accepted Answer

A) unnormalized 
B) ​first normal form 
C) second normal form 
D) ​third normal form 
A) unnormalized 
B) ​first normal form 
C) second normal form 
D) ​third normal form

Question 7

A(n)____ is the association between entities.

Accepted Answer

A) qualification 
B) ​functional dependency 
C) relationship 
D) ​join 
A) qualification 
B) ​functional dependency 
C) relationship 
D) ​join

Question 8

A field is another term for a(n)____.

Accepted Answer

A) tuple 
B) ​row 
C) column 
D) ​entity 
A) tuple 
B) ​row 
C) column 
D) ​entity

Question 9

You can indicate a table's primary key by underlining the column or collection of columns that comprises the primary key for each table in the database.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following symbols is used to qualify column names?

Accepted Answer

A) period (.) 
B) ​comma (,) 
C) backslash (/) 
D) ​pound sign (#) 
A) period (.) 
B) ​comma (,) 
C) backslash (/) 
D) ​pound sign (#)

Question 11

A relation is in ____ if it does not contain any repeating groups.

Accepted Answer

A) first normal form 
B) ​second normal form 
C) third normal form 
D) ​Boyce-Codd normal form 
A) first normal form 
B) ​second normal form 
C) third normal form 
D) ​Boyce-Codd normal form

Question 12

When you combine a column name with a table name,you are said to ____________________ the column name.

Accepted Answer

The answer of When you combine a column name with...

Question 13

In the one-to-many type of relationship,the word many always indicates a large number.

Accepted Answer

A) True 
 B)False

Question 14

An unnormalized relation is a relation that may contain repeating groups.

Accepted Answer

A) True 
 B)False

Question 15

In a relation,the order of the rows and columns is immaterial.

Accepted Answer

A) True 
 B)False

The definition for a primary key really defines a candidate key as well.

A(n)____________________ is another name for a record or a row.

Define a relation.

The ____________________ key of a table (relation)is the column or collection of columns that uniquely identifies a given row in that table.

A primary key always comprises a single column.

In this text,Boyce-Codd normal form is the same as ____.

A(n)____ is the association between entities.

A field is another term for a(n)____.

You can indicate a table's primary key by underlining the column or collection of columns that comprises the primary key for each table in the database.

Which of the following symbols is used to qualify column names?

A relation is in ____ if it does not contain any repeating groups.

When you combine a column name with a table name,you are said to ____________________ the column name.

In the one-to-many type of relationship,the word many always indicates a large number.

An unnormalized relation is a relation that may contain repeating groups.

In a relation,the order of the rows and columns is immaterial.

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters

Exam 2: Database Design Fundamentals

The definition for a primary key really defines a candidate key as well.

A(n)____________________ is another name for a record or a row.

Define a relation.

The ____________________ key of a table (relation)is the column or collection of columns that uniquely identifies a given row in that table.

A primary key always comprises a single column.

In this text,Boyce-Codd normal form is the same as ____.

A(n)____ is the association between entities.

A field is another term for a(n)____.

You can indicate a table's primary key by underlining the column or collection of columns that comprises the primary key for each table in the database.

Which of the following symbols is used to qualify column names?

A relation is in ____ if it does not contain any repeating groups.

When you combine a column name with a table name,you are said to ____________________ the column name.

In the one-to-many type of relationship,the word many always indicates a large number.

An unnormalized relation is a relation that may contain repeating groups.

In a relation,the order of the rows and columns is immaterial.

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

Database Administration

SQL Functions and Procedures

Filters