Need help making a ERD using Constraints, Entities, Relations, and Attributes for this problem.
A Bookstore has several branches throughout Champaign, 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.