Answered step by step
Verified Expert Solution
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? thx
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 exampleStep 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