Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want the drawing to be in the form of a table crosswise, please Draw the ER model (Crow's Foot model) for the following situations:

I want the drawing to be in the form of a table crosswise, please
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions