Question
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
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:
- 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 factory.
- Each part has an id and a name. The id uniquely identifies a part.
- Each employee works in only one factory, a factory can employ many employees.
- Each part is manufactured in at least one factory. A factory can produce many different parts.
Identify all relationships in the ERD that you created. For each relationship, write a business rule to describe the relationship. E.g. Student has one advisor, but an advisor may have multiple students.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started