Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problems 3.6/3.12 and 3.7/3.13; how do you create an EE-R, and E-R diagram for these two problems? thx An interior design firm would like to

Problems 3.6/3.12 and 3.7/3.13; how do you create an EE-R, and E-R diagram for these two problems? thximage text in transcribedimage text in transcribedimage text in transcribed

An interior design firm would like to have a database to represent its operations. A client (customer requests that the firm perform a job such as decorating a new home, redecorating rooms, locating and purchasing furniture, and so forth. One of the firm's decorators is placed in charge of each job. For each job, the firm provides an estimate of the amount of time and money required for the entire job. some of the work for a job, such as planning furniture placement, is done by the decoratorin charge ofthe job. In addition, the firm might hire contractors to work on a daily or hourly basis on a particular job. Ajob might also include several activities, such as painting, installing floor covering, fabricating draperies, wallpapering, constructing, installing cabinets, and so on.Theseactivities aredonebycontractors hired by the firm. The contractor provides an estimate for each activity. An activity or job might also require materials such paint or lumber, and the firm has to keep track of the cost of materials for each activity or job in order to bill the client. The database should store the estimated costs and actual costs of all activities and all jobs. Draw a complete E-R diagram for this example

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

Databases A Beginners Guide

Authors: Andy Oppel

1st Edition

007160846X, 978-0071608466

More Books

Students also viewed these Databases questions