Question: 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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!