Question 1

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 2

A primary key always comprises a single column.

Accepted Answer

A) True 
 B)False

Question 3

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 formE) A) and B)
F) A) and C)

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 formE) All of the above
F) B) and C)

Question 7

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

Accepted Answer

A)  period (.) 
B)  ​comma (,) 
C)  backslash (/) 
D)  ​pound sign (#) E) All of the above
F) A) and D)

Question 8

A(n) ____ is the association between entities.

Accepted Answer

A)  qualification
B)  ​functional dependency
C)  relationship
D)  ​joinE) C) and D)
F) B) and D)

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  tuple
B)  ​row
C)  column
D)  ​entityE) All of the above
F) A) and B)

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Define a relation.

Accepted Answer

A relation is a two-dimensional table in...

Question 15

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...

Exam 2: Database Design Fundamentals

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.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Define a relation.

Correct Answer
verified
A relation is a two-dimensional table in...
View Answer

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

Correct Answer
verified

A(n) ____ is the association between entities.

Correct Answer
verified

A primary key always comprises a single column.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 2: Database Design Fundamentals

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Define a relation.

Correct AnswerverifiedA relation is a two-dimensional table in...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

A(n) ____ is the association between entities.

Correct AnswerverifiedShow Answer

A primary key always comprises a single column.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A relation is a two-dimensional table in...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified