In: Computer Science
A publisher needs to create a database based on the following requirements:
The publisher publishes different books. Each book has an 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 different percentage of revenue.
They also hire editors, who edit books before publishing. Each has name, unique number, SSN, salary, book category and list of books they edited.
Draw a complete ER diagram. Write the (min,max), total/partial and the cardinality ratio.
Min Cardinality:The minimum number of occurrence of an entity that participates in a relationship.
Max Cardinality: The maximum number of occurrence of and entity that participates in a relationship.
Cardinality Ratio: Cardinality Ratio is the ratio of participation between two entities. Types : one to one,one to many, many to one, many to many.
Total participation: In Total participation, every entity of the entity set must participate in the relationship. e.g every student in the student entity must enroll in a course, student will have total participation.
Partial participation :In partial participation , not every entity in the entity set is required to participate in the relationship.