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 freeLoading lesson…

