“Designing a Database for Book and Author Relationships” a. Entities: 1. Book 2. Author b. Attributes: 1. Book: – ISBN (primary key) – Title – Publication Date – Genre – Publisher

Consider the relationships between Books and Authors. A book can have a number of authors
and an author can have many books to his/her name. Taking into account this particular 
example, you are required to carry out the below tasks to design a database: 
a. Identify all the ENTITIES. Give each ENTITY a suitable name. 
b. Identify all the ATTTRIBUTES associated with each ENTITY. Make sure that each
ENTITY has a      proper PRIMARY KEY which is underlined. A minimum of 3 attributes is
required for each 
ENTITY. 
c. Draw an ENTITY RELATIONSHIP DIAGRAM (ERD) clearly stating the relationships
between the      ENTITIES, the CARDINALITIES and ATTRIBUTES with correct notations. 
d. Convert the ERD (drawn in “c”) into a relational schema. The PRIMARY KEY and
FOREIGN KEY       must be clearly shown for each relation. 
e. Produce sample records (3 records at least per ENTITY) to represent the relational 
schema.
The records can be presented in the form of a table for each entity.