Assume you are creating a database for a library. The database needs to support the following business functions:

1. Allow customers to search the catalog, which includes books and DVDs. Customers may want to search by different properties e.g, by media type (e.g., book or DVD), title, author, publication date, and language (e.g., English, Spanish, French).
2. Record when a book/DVD is borrowed or returned. Each borrowing and returning event has a date (e.g., the day you go to library to borrow or return).

1. A customer can borrow or return more than one item in one transaction (e.g. borrow 2 books in one library visit). Different items may have different due dates (e.g., new books and old books have different due dates. The due dates for DVDs may be different from books). Thus it is necessary to record the due date and return date for each item.
2. In case some items are overdue, a notice will be sent to the customer and charge a fee for late items. The accumulated late fee in an account normally is paid when a customer goes to a library to borrow or return books.

There are TWO Problems in this assignment. Please use one of an ER drawing tool (e.g., draw.io) for this assignment and save the result in a pdf file (recommended).

Please draw an ER diagram for the librarys database project. Specific requirements for this ER diagram include:

1. Please identify the main entities that are essential to support the business functions described above. Please do not create too many entities.
2. For each entity, please identify the attributes each entity has. The grade will depend on whether you have selected those attributes that are necessary for the above business functions. For example, think of how you try to find a book/DVD to borrow.
3. For each attribute, please identify whether this attribute is optional or required, single valued or multi-valued, simple or composite, stored or derived.
4. Define an identifier/key for each entity. Note that a key can contain multiple attributes (composite key).
5. Please identify the main relationships between the entities you identified above that are essential to support the business functions listed above.
6. Please specify each relationship with min-max cardinality. For each relationship, please provide the justification for such cardinality constraints such as a customer (e.g., a student) may have a library account without borrowing any item from the library. Thats why the min cardinality is 0 since it is optional for a customer to borrow books.
7. Answer why you do not want to create relationships for customer search catalog

(Please add your ER diagram for problem 1 here)

(Please add your cardinality constraint justification in problem 1 here. Please use one paragraph for each relationship)