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.