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.
- Spring '08
- Computer Science