This is a Data Modeling exercise

I am assigned a project as a DBA to design a data model to support a library system. At a minimum, the database needs to support tracking the books in the library inventory, the book author(s), the book publisher, and any optionally associated book categories. You will need to make some assumptions as to what attributes are associated with each entity. For example, you may decide that the Author entity will require Author ID, FirstName and LastName attribute.

Note:

A book can have 1 or more authors

A book can only have 1 publisher

A book can have 0 or more category

I need to create the conceptual, logical and physical data models. Use the following guide on what to include in each model:

Conceptual, Logical, And Physical Data Models

Important: do not include more entities than required. Only design to meet the specified requirements.