Reference no: EM132077766

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.