This preview shows page 1. Sign up to view the full content.
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
- Spring '08
- Computer Science