CS 6400 Exam 4 Review – Questions and Answers | 2026 Updated | 100% Correct – GT.

CS 6400 Exam 4 Review – Questions and Answers | 2026 Updated | 100% Correct – GT.




✅ EXTRACTED FULL QUESTIONS &
ANSWERS

Question 3
Which of the following may be considered as general guidelines for relational schema
design?
Answer: Reduce redundant information in tuples




Question 4
Which of the following is the key for PatientVisit?
Answer: DoctorID, PatientID, Date




Question 5
True or False: In the relation corresponding to the relational schema PatientVisit and the
functional dependencies F, there could exist two rows with the same value for Diagnosis,
but different values for Procedure.
Answer: True




Question 6
Consider the given set of FDs, F.
Inferring the functional dependency:
DoctorID, PatientID, Date → Charge from F involves using which inference rule(s)?
Answer: The transitive rule

, Question 7
True or False: F is a minimal cover.
Answer: True




Question 8
Which of the following are nonprime attributes for PatientVisit?
Answer:

 PatientName
 Procedure
 Diagnosis




Question 9
The FDs that violate 2NF in the PatientVisit schema is/are:
Answer:

 Procedure → Charge, BillingCode
 PatientID → PatientName




Question 10
The FDs that violate 3NF in the PatientVisit schema is/are:
Answer:

 PatientID → PatientName
 Procedure → Charge, BillingCode




Question 11
The relation schema PatientVisit is in the highest normal form indicated below:
Answer: 1NF