Create an ER Diagram. Be sure to include all necessary entities, attributes, and correct cardinality in relationships between entities. Dont forget foreign keys and any specializations.

Specifications

A local library needs your help designing a database to keep track of their operations. The library has books that are checked out by customers that it needs to track. Each book has a unique ISBN, as well as a title and genre to store. The library keeps track of each customers first and last name and email address.

The library adds a customer to the database after they check out a book, and they can check out multiple books at a time. A book can be checked out by multiple customers (there are multiple copies available). When a book is checked out, the checkout date and return date are also stored.

In addition, the library keeps track of book publishers and authors, including the name and address of each publisher and authors first and last names. The library also tracks two specific types of several available publishers: nonfiction and fiction. Each nonfiction publisher has a topic to store, and each fiction publisher has a target audience to track as well.

When a book is added to the database, its author and publisher are added as well. Each book may be written by multiple authors and each author may have written many books. A single publisher may have published many books, but each book has only one publisher.

The library also tracks its employees, including their first and last names and email addresses. Additionally, employees can be classified as either staff, which have an hourly wage to track, or librarians, which have a degree and salary to track.

Librarians may also be hired as staff members if they choose to work at library events.

The library is home to several events, the names of which are stored in the database. When a staff member joins the library team, they are associated with one and only one event that they serve. An event may be worked by several staff members.

Events bring in many customers and customers may attend many different events, although events and customers can be stored independently of one another. When a customer attends an event, an event date and event time are also stored.

The library also keeps track of its rooms, which are classified as either classrooms or offices. The capacity of each room is kept track of, in addition to the name of each classroom and the layout of each office. Classrooms may be used to hold events, which take place in one room.

Each librarian is assigned to an office, which is not a shared space, but may be vacant if the library is hiring. Each room may be equipped with computers, depending on its purpose. Each computers unique serial number is recorded, as well as its manufacturer. Every computer at the library is assigned one room.

Please show a screen shot of what your diagram looks like. I don't want text.