Question 1

Any column (or collection of columns)that determines another column is called a(n)____.

Accepted Answer

A) nonkey column 
B) ​primary key 
C) dependency 
D) ​determinant 
A) nonkey column 
B) ​primary key 
C) dependency 
D) ​determinant D

Question 2

In one style of entity-relationship (E-R)diagrams,diamonds are used to describe ____________________.

Accepted Answer

​relationships

Question 3

The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class,you can determine the pay rate.

Accepted Answer

A) True 
 B)False  True

Question 4

A secondary key is the unique identifier for a table.

Accepted Answer

A) True 
 B)False

Question 5

At TAL Distributors,there is a ____ relationship between sales reps and customers.

Accepted Answer

A) one-to-one 
B) ​one-to-two 
C) one-to-many 
D) ​many-to-many 
A) one-to-one 
B) ​one-to-two 
C) one-to-many 
D) ​many-to-many

Question 6

If the primary key of a table contains only a single column,the table is automatically in ____________________ normal form.

Accepted Answer

The answer of If the primary key of a table...

Question 7

In a relational database each ____ should be unique.

Accepted Answer

A) row 
B) ​record 
C) tuple 
D) ​All of the above 
A) row 
B) ​record 
C) tuple 
D) ​All of the above

Question 8

____ is one of the categories of update anomalies.

Accepted Answer

A) Functional dependence 
B) ​Functional splitting 
C) Inconsistent data 
D) ​Qualification 
A) Functional dependence 
B) ​Functional splitting 
C) Inconsistent data 
D) ​Qualification

Question 9

The concept of functional dependence is trivial to understanding database concepts.

Accepted Answer

A) True 
 B)False

Question 10

There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table,all the columns in the table are listed within a set of ____.

Accepted Answer

A) square brackets 
B) ​parentheses 
C) back slashes 
D) ​curly braces 
A) square brackets 
B) ​parentheses 
C) back slashes 
D) ​curly braces

Question 11

In an entity-relationship (E-R)diagram,one-to-many relationships between entities are drawn as ____.

Accepted Answer

A) ovals 
B) ​equal signs 
C) lines 
D) ​circles 
A) ovals 
B) ​equal signs 
C) lines 
D) ​circles

Question 12

In a relational database,column B is ____________________ on another column A,if at any point in time a value for A determines a single value for B.

Accepted Answer

​functiona

Question 13

Normalization is done before creating the database design.

Accepted Answer

A) True 
 B)False

Question 14

A programmer interviews users,examines existing and proposed documents,and examines organizational policies to determine exactly the type of data needs the database must support.

Accepted Answer

A) True 
 B)False

Question 15

A relation is essentially a three-dimensional table.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

The answer of In a relation,the ____________________ of the rows...

Question 17

In one style of entity-relationship (E-R)diagrams,the letter n is used to represent the ____________________ side of a relationship.

Accepted Answer

The answer of In one style of entity-relationship (E-R)diagrams,the letter...

Question 18

A determinant is any column (or collection of columns)that determines another table.

Accepted Answer

A) True 
 B)False

Question 19

It is possible for the computer to generate values that are used as the primary key column.

Accepted Answer

A) True 
 B)False

Question 20

In one style of entity-relationship (E-R)diagrams,a crow's foot is used to represent the ____________________ side of a relationship.

Accepted Answer

The answer of In one style of entity-relationship (E-R)diagrams,a crow's...

Any column (or collection of columns)that determines another column is called a(n)____.

In one style of entity-relationship (E-R)diagrams,diamonds are used to describe ____________________.

The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class,you can determine the pay rate.

A secondary key is the unique identifier for a table.

At TAL Distributors,there is a ____ relationship between sales reps and customers.

If the primary key of a table contains only a single column,the table is automatically in ____________________ normal form.

In a relational database each ____ should be unique.

____ is one of the categories of update anomalies.

The concept of functional dependence is trivial to understanding database concepts.

There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table,all the columns in the table are listed within a set of ____.

In an entity-relationship (E-R)diagram,one-to-many relationships between entities are drawn as ____.

In a relational database,column B is ____________________ on another column A,if at any point in time a value for A determines a single value for B.

Normalization is done before creating the database design.

A programmer interviews users,examines existing and proposed documents,and examines organizational policies to determine exactly the type of data needs the database must support.

A relation is essentially a three-dimensional table.

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

In one style of entity-relationship (E-R)diagrams,the letter n is used to represent the ____________________ side of a relationship.

A determinant is any column (or collection of columns)that determines another table.

It is possible for the computer to generate values that are used as the primary key column.

In one style of entity-relationship (E-R)diagrams,a crow's foot is used to represent the ____________________ side of a relationship.

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

Any column (or collection of columns)that determines another column is called a(n)____.

In one style of entity-relationship (E-R)diagrams,diamonds are used to describe ____________________.

The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class,you can determine the pay rate.

A secondary key is the unique identifier for a table.

At TAL Distributors,there is a ____ relationship between sales reps and customers.

If the primary key of a table contains only a single column,the table is automatically in ____________________ normal form.

In a relational database each ____ should be unique.

____ is one of the categories of update anomalies.

The concept of functional dependence is trivial to understanding database concepts.

There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table,all the columns in the table are listed within a set of ____.

In an entity-relationship (E-R)diagram,one-to-many relationships between entities are drawn as ____.

In a relational database,column B is ____________________ on another column A,if at any point in time a value for A determines a single value for B.

Normalization is done before creating the database design.

A programmer interviews users,examines existing and proposed documents,and examines organizational policies to determine exactly the type of data needs the database must support.

A relation is essentially a three-dimensional table.

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

In one style of entity-relationship (E-R)diagrams,the letter n is used to represent the ____________________ side of a relationship.

A determinant is any column (or collection of columns)that determines another table.

It is possible for the computer to generate values that are used as the primary key column.

In one style of entity-relationship (E-R)diagrams,a crow's foot is used to represent the ____________________ side of a relationship.

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