A publisher needs to create a database based on thefollowing requirements:
The publisher publishes different books. Each book hasan ISBN, name, author(s) name, edition number, category, and price.Each book has a unique ISBN.
The publisher deal with many authors, each has a name,unique number.
For every book, each author will have differentpercentage of revenue.
They also hire editors, who edit books beforepublishing. Each has name, unique number, SSN, salary, bookcategory and list of books they edited.
Draw a complete ER diagram. Write the (min,max),total/partial and the cardinality ratio.
