...
Computer-Networks
October 22, 2023
2013 June UGC NET Paper 1
October 23, 2023
Computer-Networks
October 22, 2023
2013 June UGC NET Paper 1
October 23, 2023

Database-Management-System

Question 16

Consider the following database relations containing the attributes

Book_id 
Subject_Category_of_book
Name_of_Author
Nationality_of_Author 
with Book_id as the Primary Key. 

(a) What is the highest normal form satisfied by this relation?

(b) Suppose the attributes Book_title and Author_address are added to the relation, and the primary key is changed to (Name_of_Author, Book_Title), what will be the highest normal form satisfied by the relation?

A
Theory Explanation.
Correct Answer: A

Leave a Reply

Your email address will not be published. Required fields are marked *