Consider the following database relation containing the attributes Book_id,…

PYQ GATE 1998Modified — slightly modified from the official paper; see the solution

Consider the following database relation containing the attributes Book_id, Subject_Category_of_book, Name_of_Author and Nationality_of_Author, with Book_id as the primary key. Assume each author has one nationality and one address, so Name_of_Author functionally determines Nationality_of_Author and Author_address. (a) What is the highest normal form satisfied by this relation? (b) Suppose Book_title and Author_address are added to the relation, and the primary key is changed to {Name_of_Author, Book_title}. What is the highest normal form satisfied by the relation?

Attempted by 2 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…