ISDS 3003 MODULE 2&3 QUESTIONS & ANSWERS
(BuildingName, RoomNumber) --> (Capacity, Department) - Answer -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 a single department.
A department may have many rooms in one or more buildings, each with the same or
different capacities.
AdvisorID is a foreign key - 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?
A. SID is both a primary key and foreign key
B. AdvisorID is a foreign key
C. AdvisorName is a determinant
D. Major is a candidate key
E. Phone is a candidate key
MedicineName is a determinant - Answer -Given the below functional dependencies:
MedicineCode --> (MedicineName, ShelfLife, Manufacturer, Dosage)
Which of the following statements is NOT known to be true?
A. MedicineCode is a candidate key of the relation MEDICINE (MedicineName,
ShelfLife, Manufacturer, Dosage).
B. MedicineCode is a determinant.
C. ShelfLife is functionally dependent on MedicineCode.
D. MedicineName is a determinant.
E. Manufactuer is functionally dependent on MedicineCode
a referential integrity constraint - Answer -A rule that requires that the values in a
foreign key must have a matching value in the primary key to which the foreign key
corresponds is called _____________.
Break it into 2 or more relations that are well formed - Answer -Due to the normalization
process, the remedy for a relation that is not well formed is to
_______________________
(BuildingName, RoomNumber) --> (Capacity, Department) - Answer -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 a single department.
A department may have many rooms in one or more buildings, each with the same or
different capacities.
AdvisorID is a foreign key - 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?
A. SID is both a primary key and foreign key
B. AdvisorID is a foreign key
C. AdvisorName is a determinant
D. Major is a candidate key
E. Phone is a candidate key
MedicineName is a determinant - Answer -Given the below functional dependencies:
MedicineCode --> (MedicineName, ShelfLife, Manufacturer, Dosage)
Which of the following statements is NOT known to be true?
A. MedicineCode is a candidate key of the relation MEDICINE (MedicineName,
ShelfLife, Manufacturer, Dosage).
B. MedicineCode is a determinant.
C. ShelfLife is functionally dependent on MedicineCode.
D. MedicineName is a determinant.
E. Manufactuer is functionally dependent on MedicineCode
a referential integrity constraint - Answer -A rule that requires that the values in a
foreign key must have a matching value in the primary key to which the foreign key
corresponds is called _____________.
Break it into 2 or more relations that are well formed - Answer -Due to the normalization
process, the remedy for a relation that is not well formed is to
_______________________
