Question: Can someone help? 3-31. Develop an EER model for the following situation, using the traditional EER notation, the Visio notation, or the subtypes inside supertypes

Can someone help?

Can someone help? 3-31. Develop an EER model for

3-31. Develop an EER model for the following situation, using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: A technology company provides offerings to its custom- ers. Offerings are of two separate types: products and services. Offerings are identified by an offering ID and an attribute of description. In addition, products are de- scribed by product name, standard price, and date of first release; services are described by name of the company's unit responsible for the service and conditions of service. There are repair, maintenance, and other types of services. A repair service has a cost and is the repair of some prod- uct; a maintenance service has an hourly rate. Fortunately, some products never require repair. However, there are many potential repair services for a product. A customer may purchase an offering, and the company needs to in keep track of when the offering was purchased and the contact person for that offering with the customer. Unfor- tunately, not all offerings are purchased. Customers are identified by customer ID and have descriptive data of name, address, and phone number. When a service is per- formed, that service is billed to some customer. Because some customers purchase offerings for their clients, a cus- tomer may be billed for services he or she did not pur- chase, as well as for ones that were purchased. When a customer is billed for a service (although some may never require a service of any type), the company needs to keep y track of the date the service was performed, the date the bill is due, and the amount due

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!