cs186_sp08_mt1 - • The database contains information...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Class Account: ___________________________ UNIVERSITY OF CALIFORNIA Department of EECS, Computer Science Division CS186 Bohannon/Cooper Spring 2008 First Exam: Introduction to Database Systems February 26, 2008 Instructions: 1. Write your name on each page. 2. Turn in your notes page with your test. 3. There are 100 points total. 4. Please read over the test and plan your time. Best to skip and go back if you are stuck on a question. Entity Relationship Graphs (14 pts) You have just been hired as a consultant for a big airplane manufacturer. Impressed by your background in databases, they want you to completely redesign their database system. Talking with the people in the company, you get the following information.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: • The database contains information about employees, factories and parts. • Each employee has a social security number (SSN), name and salary. An employee is uniquely identified by his or her SSN. • Each factory has an id, name and a budget. The id uniquely identifies a project. • Each part has an id and a name. The id uniquely identifies a part. • Each employee reports to at most one other employee. • Each employee works in at least one factory. • Each part is manufactured in exactly one factory. Each part is a component of zero or more other parts. A partial Entity-Relationship diagram for the above application is shown on the next page. • add attributes of parts...
View Full Document

This note was uploaded on 08/26/2009 for the course CS 186 taught by Professor Staff during the Spring '08 term at Berkeley.

Ask a homework question - tutors are online