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.
Question: Show the relational schema that corresponds to the above ER diagram. Make sure to clearly indicate primary keys and foreign keys. These would be the DDL needed to create the tables to support your ERD.
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