Question: Draw the ER model (Crow's Foot model) for the following situations: Note: 1. Show the connectivity. 2. Show the attributes; identify the primary key and
Draw the ER model (Crow's Foot model) for the following situations: Note: 1. Show the connectivity. 2. Show the attributes; identify the primary key and the foreign key. 3. Show the cardinality. 1. A company has many factories. Each factory manufactures between two and four products. A product can be manufactured in more than one factory. Each factory has between two and five warehouses. Two supervisors are assigned to each warehouse. Ten to fifteen workers work in each factory. One manager is assigned to each factory. Note: Add the following fields to the appropriate tables: mumber_of_manufactured products, employee no_of_working_hours, 2. A construction company has many divisions. A division operates between two to five deparments. Each department has at least 10 employees. An employee may work on many projects or he may not be assigned to any project. A project contains up to 7 employees and no less than 3 employees. 3. Pick and Shovel Construction Company is a multi-state building contractor specializing in medrum-priced villas. A customer can hire the company for several projects (villas). An employee can sometimes work on two projects at the same time. A project must have a minimum of ten employees. Each project has one manager who can be assigned between 2 and 5 projects
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
