Question

Make an ERD including all entities, attributes, relations, and constraints.

Please upload as a doc

based on everything listed below

University Bookstore

•University Bookstore has several branches throughout Bloomington, and

employees may be assigned to work at any of the branches.

•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.

•Employee 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 employee stockers. Each shelf has a location, a

capacity, and an 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

•University Bookstore has decided to implement an emergency

response training program at the request of their insurance company:

•All staff are required to take a series of training classes on emergency

procedures. Classes have an ID, a title, and a training level.

•Each class has an accompanying exam which must be passed. Each exam has

an ID, a title, a max score, and a passing score.

•The system must keep track of each time employees take a class or exam.

•University Bookstore has decided to start selling used books as well as

new ones.

•Each used book has a condition and both a purchase price and a sale

price

Note: This lab contains information that may not apply to the database

such as workflow or job information.

Answer 1