samplemidterm

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

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

(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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 01/20/2010 for the course CS 614 taught by Professor Jessica during the Fall '09 term at George Mason.

### 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
Ask a homework question - tutors are online