A local bookstore wants to implement a database to manage its data efficiently. The database will contain the following information (entities)- employee, book, author, publisher, branch, and inventory. Use the following business rules to create a Crows Foot ERD. . If you discover while drawing the diagram that the scenario is incomplete, make up reasonable explanations to complete the story. Supply your explanations along with the diagram

local bookstore has branches in multiple states

Each employee works in multiple branches

Each branch has its own book inventory.

Multiple branches can have the same book in their inventory.

A book is supplied by only one publisher

A book is written by one or multiple authors

your ERD must show

o Entity: The proper number of entities and their names

All needed attributes of each entity: Even though the question doesnt describe them, you should add them based on common sense

o Primary key

Relationship: Max. and Min. cardinalities: If needed, you can put your justifications on your answer document about why you use the cardinality

Description (text) of relationship between entities (e.g., takes, advises, has, etc. in Figure 4.35)

The correct number of relationships between entities

In drawing the model, use Crows foot model (notation).

In drawing the diagram, you can use any (diagraming) software, such as Draw.io, Microsoft Visio, LucidChart, or even Microsoft Word