samplemidterm

samplemidterm - Problem 1 (total 24 points) Assume the...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
(total 24 points) Assume the following ``real-world'' environment concerning a small supermarket, the Yappy Valley Culinary Boutique (YVCB). YVCB is organized into departments, each of which has some employees. Items are sold by departments, and are supplied by suppliers. Each supplier gives its own unique codes to the items it supplies. Also, each supplier has exactly one contact person who is an employee. Consider the relation schemas: 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. (8 points) 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. Depts Items Employees Suppliers 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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

samplemidterm - Problem 1 (total 24 points) Assume the...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online