Question 1

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

Accepted Answer

A) True 
 B)False

Question 2

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

Accepted Answer

A) True 
 B)False

Question 3

The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.

Accepted Answer

The answer of The key that has been designated the...

Question 4

Which of the following is true about a key?

Accepted Answer

A)   It may be unique.
B)   It may be non-unique.
C)   In may identify more than one row.
D)   Both A and B
E)   All of the above

Question 5

Any table that meets the definition of a relation is said to be in second normal form.

Accepted Answer

A) True 
 B)False

Question 6

To be considered a composite key,a key must contain at least two attributes.

Accepted Answer

A) True 
 B)False

Question 7

In practice,why would tables that have duplicate rows be allowed?

Accepted Answer

It is not uncommon for a table that is r...

Question 8

Given the below functional dependency, MedicineCode → (MedicineName,ShelfLife,Manufacturer,Dosage) 
Which of the following statements is not known to be true?

Accepted Answer

A)   MedicineCode is a determinant.
B)   MedicineName is a determinant.
C)   Manufacturer is functionally dependent on MedicineCode.
D)   ShelfLife is functionally dependent on MedicineCode.
E)   MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage, MedicineCode) .

Question 9

In SQL Server,the starting value of a surrogate key is called the:

Accepted Answer

A)   Identity.
B)   Identity Increment.
C)   Identity Start.
D)   Identity Seed.
E)   Identity Property.

Question 10

The first step of the normalization process is to identify all the candidate keys of a relation.

Accepted Answer

A) True 
 B)False

Question 11

To create a relationship in Microsoft Access,we drag and drop the ________ of a table.

Accepted Answer

The answer of To create a relationship in Microsoft Access,we...

Question 12

Which of the following is not true about null values?

Accepted Answer

A)   A null value can mean that the value is unknown.
B)   A null value is ambiguous.
C)   A null value can mean that the value is known to be blank.
D)   A null value can mean that no value for the field is appropriate.
E)   Null values cannot be avoided.

Question 13

In the relational model,each row of a table contains data that represents an attribute of the entity.

Accepted Answer

A) True 
 B)False

Question 14

To create a well-formed relation through normalization,every determinant must be a candidate key.

Accepted Answer

A) True 
 B)False

Question 15

Given the relations: STUDENT (SID,StudentName,Major,AdvisorID) 
ADVISOR (AdvisorID,AdvisorName,Office,Phone) 
Such that each student is assigned to one advisor,which of the following is true?

Accepted Answer

A)   SID is both a primary key and a foreign key.
B)   AdvisorName is a determinant.
C)   AdvisorID is a foreign key.
D)   Phone is a candidate key.
E)   Major is a candidate key.

Question 16

A key that contains more than one attribute is called a(n) :

Accepted Answer

A)   composite key.
B)   complex key.
C)   multi-key.
D)   n-key.
E)   candidate key.

Question 17

In Microsoft Access,relationships between tables are created in the Relationships window.

Accepted Answer

A) True 
 B)False

Question 18

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

Accepted Answer

A) True 
 B)False

Question 19

A surrogate key may be appropriate under which of the following circumstances?

Accepted Answer

A)   The available candidate keys would produce a lot of data duplication when representing relationships.
B)   The primary key is numeric.
C)   The available candidate keys would be prone to typographical errors.
D)   The available candidate keys have little meaning to the users.
E)   Both A and C

Question 20

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

Accepted Answer

A) True 
 B)False

Exam 2: The Relational Model

In Microsoft Access,relationships between tables are created in the Relationships window.

Correct AnswerverifiedShow Answer

To be considered a composite key,a key must contain at least two attributes.

Correct AnswerverifiedShow Answer

To create a relationship in Microsoft Access,we drag and drop the ________ of a table.

Correct AnswerverifiedShow Answer

To create a well-formed relation through normalization,every determinant must be a candidate key.

Correct AnswerverifiedShow Answer

A key that contains more than one attribute is called a(n) :

Correct AnswerverifiedShow Answer

The first step of the normalization process is to identify all the candidate keys of a relation.

Correct AnswerverifiedShow Answer

In the relational model,each row of a table contains data that represents an attribute of the entity.

Correct AnswerverifiedShow Answer

In the normalization process,it is not necessary to identify all the functional dependencies in a relation.

Correct AnswerverifiedShow Answer

Any table that meets the definition of a relation is said to be in second normal form.

Correct AnswerverifiedShow Answer

Given the relations: STUDENT (SID,StudentName,Major,AdvisorID) ADVISOR (AdvisorID,AdvisorName,Office,Phone) Such that each student is assigned to one advisor,which of the following is true?

Correct AnswerverifiedShow Answer

The key that has been designated the ________ key of a relation functionally determines all the other attributes in the relation.

Correct AnswerverifiedShow Answer

If the condition exists such that knowing the value of attribute X determines the value of attribute Y,then attribute Y is functionally dependent on attribute X.

Correct AnswerverifiedShow Answer

A surrogate key may be appropriate under which of the following circumstances?

Correct AnswerverifiedShow Answer

In SQL Server,the starting value of a surrogate key is called the:

Correct AnswerverifiedShow Answer

In Microsoft Access,a relationship is created by dragging a foreign key column and dropping it on top of the corresponding primary key.

Correct AnswerverifiedShow Answer

In the normalization process,if you find a candidate key that is not a primary key,then you have determined that the relation needs to be broken into two or more other relations.

Correct AnswerverifiedShow Answer

Given the below functional dependency, MedicineCode → (MedicineName,ShelfLife,Manufacturer,Dosage) Which of the following statements is not known to be true?

Correct AnswerverifiedShow Answer

Which of the following is true about a key?

Correct AnswerverifiedShow Answer

In practice,why would tables that have duplicate rows be allowed?

Correct AnswerverifiedIt is not uncommon for a table that is r...View AnswerShow Answer

Which of the following is not true about null values?

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
It is not uncommon for a table that is r...
View Answer

Correct Answer
verified