Depts(dID, dName, budget)
d stands for department. Gives the departments, their ID, name and budget.
Employees(eID, dID, eName, eSalary)
e stands for employee Gives the employees, their IDs, where they work, their names and salaries.
Suppliers(sID, sName, sCity, sState, eID)
s stands for supplier. Gives the suppliers, their IDs, their names, and where they are located (city and state). Also tells which employees are contact persons for the suppliers.
Items(sID, siCode, dID, iName, MSRP)
i stands for item, siCode stands for supplier-assigned item code. Gives the items and the departments that sell the items. MSRP=manufacturer suggested retail price.
Primary keys are underlined. Each relation schema has one candidate key (therefore, it's the primary key), it may be missing candidate (unique) keys and foreign keys.
Do the following (3 steps):
1. Complete (i.e., reverse engineering) the ER diagram below such that the 4 relation schemas above are exactly the result of a translation from the ERD to the relational model. You are NOT allowed to add any additional entity set.