Upload the PDF file of your ER models by the due date and time

Notice: Hints only offer tips and clues. They may or may not contain the full

information regarding the solution, regardless they should help you. If you have

any doubts regarding the question, the hints or your solution please ask me$.$ For a

better explanation please try your best to ask me in person either during my office

hours or after class.

Stellar is an auditing firm. Your database is required to keep track of all

employees, projects, departments and suppliers $($hint: this statement should give

you an idea about the entities you are working with$)$

$$ Every Employee has a unique number $($Employee ID$)$ assigned by the firm

and must also store their Name, Date of Birth and Job Title.

o Some employees act as supervisors. A supervisor must supervise at

least one employee; however, they usually supervise more. If an

employee is a supervisor, you must store their Supervisor ID$.($hint:

does this statement tell you anything about type of relation and the

cardinalities? $($Check CH $2$ slide #$4,$ #$25,$ #$26$ and #$29)$

$$ Every employee is assigned to work at least one Project. However, there

may be projects not worked on by any employee. And a Project must store

the Project ID and Estimated Cost.

$$ Every employee must belong to only one Department. A Department can

have one or more employees. Each Department has a Department$\_$ID and

Phone Number.

$$ A Supplier usually supplies each department with their necessary work

items. You must store a Suppliers$$ Vendor ID and Address.

o A department may not rely on any supplier or multiple suppliers for

their items; however, a supplier must supply items to at least one

department.

o If a supplier provides items to a department, you must store the date

the transaction took place