ISRO Computer Science (CSE) 2013 - Question 25

All ISRO Computer Science (CSE) papers | ISRO Computer Science (CSE) 2013

Consider the following dependencies and the BOOK table... ISBN -> Title, ISBN -> Publisher, Publisher -> Address. Determine the normal form.

  • A. First Normal Form
  • B. Second Normal Form
  • C. Third Normal Form
  • D. BCNF

Answer: B. Second Normal Form

Explanation: Candidate key is ISBN. Publisher -> Address is a transitive dependency (non-prime attribute depending on another non-prime attribute). Thus it is in 2NF but not 3NF.

| | All questions of ISRO Computer Science (CSE) 2013