Need to make a conversion and a ERD using Constraints, Entities, Relations, and Attributes for this problem.

University Bookstore has several branches throughout Bloomington, and employees may be assigned to work at any of the branches at different times.

Employees are identified by an ID and have a full name, date of birth, SSN, address, multiple phone numbers, a gender, and a hire date.

A manager runs a branch and is responsible for all operations at that branch.

Cashiers sell books to customers. All purchases should have a date/time and receipt number recorded.

Books are identified by an ISBN number and have a title, one or more authors, a published date, a publisher, a price, and an edition number. Books are stocked on shelves by stockers. Each shelf has a location, a capacity, and ID. The manager orders stock books from suppliers. The system must capture the date and invoice number of all orders. Suppliers have an ID, a name, a contact person, a website, an address, and a phone number. Employees have exactly one mentor who helps them with any issues they may face. An employee may mentor more than one employee.