Question 1

The unique keys that are not chosen to be the primary key are called ________ keys.

Accepted Answer

The answer of The unique keys that are not chosen...

Question 2

Explain the terms relation,tuple,and attribute.

Accepted Answer

The terms relation,tuple,and attribute a...

Question 3

Explain the concept of a foreign key.

Accepted Answer

To implement a relationship within a rel...

Question 4

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

Accepted Answer

functional...

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is not true of surrogate keys?

Accepted Answer

A)   They are meaningful to the users.
B)   They are numeric.
C)   They are usually generated by the DBMS.
D)   They are unique.
E)   They are usually hidden on forms and reports.F) C) and D)
G) A) and B)

Question 7

A candidate key is ________.

Accepted Answer

A)   never a primary key
B)   a combination of two or more attributes
C)   is always automatically generated by the DBMS
D)   a candidate to be the primary key
E)   None of the aboveF) A) and B)
G) A) and C)

Question 8

What is normalization?

Accepted Answer

Normalization is a process whereby relat...

Question 9

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) .F) A) and C)
G) None of the above

Question 10

________ was the developer of the relational model for databases.

Accepted Answer

The answer of ________ was the developer of the relational...

Question 11

A key must be unique.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

In the normalization process,it is not necessary to ________.

Accepted Answer

A)   identify all the candidate keys of a relation
B)   identify all the foreign keys of a relation
C)   identify all the functional dependencies of a relation
D)   identify all the determinants of a relation
E)   determine if every determinant is a candidate keyF) A) and B)
G) D) and E)

Question 14

Explain the concept of a surrogate key.

Accepted Answer

A surrogate key is an artificial key tha...

Question 15

Explain the possible interpretations of a null value.

Accepted Answer

The problem with allowing null values in...

Question 16

Any table that meets the requirements of a(n)________ is in first normal form.

Accepted Answer

The answer of Any table that meets the requirements of...

Question 17

A table that meets the requirements of a relation is said to be in which normal form?

Accepted Answer

A)   Relational normal form (RNF) 
B)   First normal form
C)   Second normal form
D)   Boyce-Codd normal form
E)   Domain/key normal formF) All of the above
G) C) and D)

Question 18

One important relational design principle is that ________.

Accepted Answer

A)   every determinant must be a candidate key
B)   every candidate key must not be a determinant
C)   every primary key must be a surrogate key
D)   every determinant must be functionally dependent on the primary key
E)   every primary key must be functionally dependent on every determinantF) D) and E)
G) None of the above

Question 19

In the normalization process,if you find that every determinant in a relation is a candidate key,then you have determined that the relation is well formed.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following functional dependency diagrams accurately represents the following situation:
•A campus has many buildings.
•Each building has a unique name.
•Each building has many rooms.
•All rooms in any given building are numbered sequentially starting at "101."
•Each room has a certain capacity,although many rooms in the same building or different buildings may have the same capacity.
•Each room is assigned to a single department.
•A department may have many rooms in one or more buildings,each with the same or different capacities.

Accepted Answer

A)   BuildingName → (RoomNumber, Capacity, Department) 
B)   RoomNumber → (BuildingName, Department, Capacity) 
C)   (Department, Capacity)  → (BuildingName, RoomNumber) 
D)   (BuildingName, Capacity)  → (Department, RoomNumber) 
E)   (BuildingName, RoomNumber)  → (Capacity, Department) F) None of the above
G) B) and C)

Exam 2: The Relational Model

A table that meets the requirements of a relation is said to be in which normal form?

Correct Answer
verified

The unique keys that are not chosen to be the primary key are called ________ keys.

Correct Answer
verified

One important relational design principle is that ________.

Correct Answer
verified

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

Correct Answer
verified
functional...
View Answer

Explain the concept of a foreign key.

Correct Answer
verified
To implement a relationship within a rel...
View Answer

Explain the terms relation,tuple,and attribute.

Correct Answer
verified
The terms relation,tuple,and attribute a...
View Answer

Explain the possible interpretations of a null value.

Correct Answer
verified
The problem with allowing null values in...
View Answer

What is normalization?

Correct Answer
verified
Normalization is a process whereby relat...
View Answer

________ was the developer of the relational model for databases.

Correct Answer
verified

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

Correct Answer
verified

A key must be unique.

Correct Answer
verified

Any table that meets the requirements of a(n)________ is in first normal form.

Correct Answer
verified

In the normalization process,if you find that every determinant in a relation is a candidate key,then you have determined that the relation is well formed.

Correct Answer
verified

A candidate key is ________.

Correct Answer
verified

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

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

In the normalization process,it is not necessary to ________.

Correct Answer
verified

Correct Answer
verified

Explain the concept of a surrogate key.

Correct Answer
verified
A surrogate key is an artificial key tha...
View Answer

Which of the following is not true of surrogate keys?

Correct Answer
verified

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

Correct Answer
verified

Exam 2: The Relational Model

A table that meets the requirements of a relation is said to be in which normal form?

Correct AnswerverifiedShow Answer

The unique keys that are not chosen to be the primary key are called ________ keys.

Correct AnswerverifiedShow Answer

One important relational design principle is that ________.

Correct AnswerverifiedShow Answer

The relationship between two attributes that denotes that if the value of the first attribute is known,then the value of the second attribute can be determined,is called a(n)________.

Correct Answerverifiedfunctional...View AnswerShow Answer

Explain the concept of a foreign key.

Correct AnswerverifiedTo implement a relationship within a rel...View AnswerShow Answer

Explain the terms relation,tuple,and attribute.

Correct AnswerverifiedThe terms relation,tuple,and attribute a...View AnswerShow Answer

Explain the possible interpretations of a null value.

Correct AnswerverifiedThe problem with allowing null values in...View AnswerShow Answer

What is normalization?

Correct AnswerverifiedNormalization is a process whereby relat...View AnswerShow Answer

________ was the developer of the relational model for databases.

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

A key must be unique.

Correct AnswerverifiedShow Answer

Any table that meets the requirements of a(n)________ is in first normal form.

Correct AnswerverifiedShow Answer

In the normalization process,if you find that every determinant in a relation is a candidate key,then you have determined that the relation is well formed.

Correct AnswerverifiedShow Answer

A candidate key is ________.

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

In the normalization process,it is not necessary to ________.

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

Explain the concept of a surrogate key.

Correct AnswerverifiedA surrogate key is an artificial key tha...View AnswerShow Answer

Which of the following is not true of surrogate keys?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
functional...
View Answer

Correct Answer
verified
To implement a relationship within a rel...
View Answer

Correct Answer
verified
The terms relation,tuple,and attribute a...
View Answer

Correct Answer
verified
The problem with allowing null values in...
View Answer

Correct Answer
verified
Normalization is a process whereby relat...
View Answer

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

Correct Answer
verified

Correct Answer
verified
A surrogate key is an artificial key tha...
View Answer

Correct Answer
verified

Correct Answer
verified