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.
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.