Posted on

What attributes would you have in a table to describe an entity called BOOK? What would you use as the primary key Answer

What attributes would you have in a table to describe an entity called BOOK? What would you use as the primary key? What would be the relationship between AUTHOR and BOOK? Assume that a book can only be written by one author. 

Answer:

 

Attributes:  Book_Id, Book_Name, Author_Name, Book_Year of Publication, Published_By, Book_Description

Primary Key – Book_Id

Relationship – Author can have many books written by him. so, there is one to many relationship between author and Book.

Leave a Reply

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