Question

Name: 3. Entity-Relationship Model and Relational Model (40pts) 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 reports to exactly one other employee. • Each employee works in at least one factory. • Each part is manufactured in exactly one factory. Draw an ER diagram for the airport database. Be sure to indicate the various attributes of each entity and relationship set; also specify the required constraints.

          Name:
3. Entity-Relationship Model and Relational Model (40pts)
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 reports to exactly one other employee.
• Each employee works in at least one factory.
• Each part is manufactured in exactly one factory.
Draw an ER diagram for the airport database. Be sure to indicate the various attributes of
each entity and relationship set; also specify the required constraints.

Name:
3. Entity-Relationship Model and Relational Model (40pts)
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 reports to exactly one other employee.
• Each employee works in at least one factory.
• Each part is manufactured in exactly one factory.
Draw an ER diagram for the airport database. Be sure to indicate the various attributes of
each entity and relationship set; also specify the required constraints.

Added by Christina J.

Question

Please give Ace some feedback