Question 1 10 pts

What do you do if a table has no candidate keys? Pick the best answer.

Group of answer choices

Use any column as primary key

Cannot create primary key for this kind of table

Add a new colum with Unique value

Define the primary key as the collection of all of the columns in the table.

Flag this Question

Question 2 10 pts

Can composite keys be unique?

Group of answer choices

Composite keys can either be unique or non-unique.

Composite keys are unique.

Composite keys only use one column

Composite keys are non-unique.

Flag this Question

Question 3 10 pts

Explain three possible interpretations of a null value.

Group of answer choices

The correct value is unknown

The value is known to be blank at this time

It is just the word NULL and means nothing more

No appropriate value exists

Flag this Question

Question 4 10 pts

Please list three type of constraints to ensure database integrity.

Group of answer choices

The value integrity constraint

The entity integrity constraint

The referential integrity constraint

The domain integrity constraint

Flag this Question

Question 5 10 pts

Functional dependencies is: If I tell you one specific fact, you can respond with a unique associated fact.

Group of answer choices

True

False

Flag this Question

Question 6 10 pts

Any relation that is not well formed should be broken into two or more relations that are well formed.

Group of answer choices

True

False

Flag this Question

Question 7 10 pts

A ___________ of a relation can be defined as one or more attributes that functionally determine all the other attributes of the relation.

Group of answer choices

primary key

foreign key

normalization

referential integrity

Flag this Question

Question 8 10 pts

Which step is NOT part of the steps to normalize a relationship?

Group of answer choices

Do not repeat any steps, there are only three

Examine the determinants of the functional dependencies

Identify all the functional dependencies in the relation

Identify all candidate keys of the relation

Flag this Question

Question 9 10 pts

A __________ is a column with a unique, DBMS-assigned identifier that has been added to a table to be the primary key.

Group of answer choices

surrogate key

alternate key

composite key

entity integrity contraint

Flag this Question

Question 10 10 pts

When a value from one relation is placed into a second relation to represent a relationship, the value in the second relation is called a _________.

Group of answer choices

alternate key

foreign key

candidate key

primary key

Question 1 10 pts

What do you do if a table has no candidate keys? Pick the best answer.

Group of answer choices

Use any column as primary key

Cannot create primary key for this kind of table

Add a new colum with Unique value

Define the primary key as the collection of all of the columns in the table.

Flag this Question

Question 2 10 pts

Can composite keys be unique?

Group of answer choices

Composite keys can either be unique or non-unique.

Composite keys are unique.

Composite keys only use one column

Composite keys are non-unique.

Flag this Question

Question 3 10 pts

Explain three possible interpretations of a null value.

Group of answer choices

The correct value is unknown

The value is known to be blank at this time

It is just the word NULL and means nothing more

No appropriate value exists

Flag this Question

Question 4 10 pts

Please list three type of constraints to ensure database integrity.

Group of answer choices

The value integrity constraint

The entity integrity constraint

The referential integrity constraint

The domain integrity constraint

Flag this Question

Question 5 10 pts

Functional dependencies is: If I tell you one specific fact, you can respond with a unique associated fact.

Group of answer choices

True

False

Flag this Question

Question 6 10 pts

Any relation that is not well formed should be broken into two or more relations that are well formed.

Group of answer choices

True

False

Flag this Question

Question 7 10 pts

A ___________ of a relation can be defined as one or more attributes that functionally determine all the other attributes of the relation.

Group of answer choices

primary key

foreign key

normalization

referential integrity

Flag this Question

Question 8 10 pts

Which step is NOT part of the steps to normalize a relationship?

Group of answer choices

Do not repeat any steps, there are only three

Examine the determinants of the functional dependencies

Identify all the functional dependencies in the relation

Identify all candidate keys of the relation

Flag this Question

Question 9 10 pts

A __________ is a column with a unique, DBMS-assigned identifier that has been added to a table to be the primary key.

Group of answer choices

surrogate key

alternate key

composite key

entity integrity contraint

Flag this Question

Question 10 10 pts

When a value from one relation is placed into a second relation to represent a relationship, the value in the second relation is called a _________.

Group of answer choices

alternate key

foreign key

candidate key

primary key