Question: 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 example
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
