OMIS 452 Ch 2 Questions with Correct Answers (Grade A+)
Question 1: The first step of the normalization process is to identify all the candidate keys of a
relation. T/F?
Answer: True
Question 2: Given the below functional dependency, MedicineCode -> (MedicineName, ShelfLife,
Manufacturer, Dosage) ,which of the following statements is not known to be true? a. Manufacturer
is functionally dependent on MedicineCode. b. MedicineCode is a determinant. c. MedicineCode is a
candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage). d.
MedicineName is a determinant. e. ShelfLife is functionally dependent on MedicineCode.
Answer: MedicineName is a determinant
Question 3: In the normalization process, it is not necessary to identify all the functional
dependencies in a relation. T/F?
Answer: False
Question 4: In Microsoft Access, referential integrity constraints are created ________. a.) by setting
a property value on the primary key in the Relationships window b.) by setting a property value on
the primary key in the table which contains it c.) by setting a property value on the foreign key in the
Relationships window d.) by setting a property value on the foreign key in the table which contains it
e.) by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box
Answer: by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box
Question 5: A surrogate key may be appropriate under which of the following circumstances? a. The
primary key is numeric. b. The available candidate keys would be prone to typographical errors. c.
The primary key is not unique d. the relation only has one attribute e. The available candidate keys
have little meaning to the users
Answer: The available candidate keys would be prone to typographical errors.
Question 6: In SQL Server, the starting value of a surrogate key is called the ________. a. identity
seed b. identity c. identity start d. identity increment e. identity property
Answer: identity seed
Question 7: 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. T/F?
Page 1
Question 1: The first step of the normalization process is to identify all the candidate keys of a
relation. T/F?
Answer: True
Question 2: Given the below functional dependency, MedicineCode -> (MedicineName, ShelfLife,
Manufacturer, Dosage) ,which of the following statements is not known to be true? a. Manufacturer
is functionally dependent on MedicineCode. b. MedicineCode is a determinant. c. MedicineCode is a
candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage). d.
MedicineName is a determinant. e. ShelfLife is functionally dependent on MedicineCode.
Answer: MedicineName is a determinant
Question 3: In the normalization process, it is not necessary to identify all the functional
dependencies in a relation. T/F?
Answer: False
Question 4: In Microsoft Access, referential integrity constraints are created ________. a.) by setting
a property value on the primary key in the Relationships window b.) by setting a property value on
the primary key in the table which contains it c.) by setting a property value on the foreign key in the
Relationships window d.) by setting a property value on the foreign key in the table which contains it
e.) by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box
Answer: by checking the Enforce Referential Integrity check box in the Edit Relationships dialog box
Question 5: A surrogate key may be appropriate under which of the following circumstances? a. The
primary key is numeric. b. The available candidate keys would be prone to typographical errors. c.
The primary key is not unique d. the relation only has one attribute e. The available candidate keys
have little meaning to the users
Answer: The available candidate keys would be prone to typographical errors.
Question 6: In SQL Server, the starting value of a surrogate key is called the ________. a. identity
seed b. identity c. identity start d. identity increment e. identity property
Answer: identity seed
Question 7: 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. T/F?
Page 1
