GCCCD Create an EER Diagram

User Generated

sbbqvrsvgarff

Computer Science

Grossmont-Cuyamaca Community College District

Question Description

I’m stuck on a Algorithms & Data Structures question and need an explanation.

Draw an ER (EER) diagram for the following problem. You can use any software or online tools (including Visio and erdplus.com) or draw it by hand using textbook EER notation, the Visio notation, Chen notation (as in erdplus.com).

Customers receive services from a technological business. There are two sorts of offerings: products and services. An offering ID and a description attribute are used to identify it. Furthermore, products are specified by their name, standard price, and date of initial release; services are described by the name of the company's unit responsible for the service, as well as the conditions of service. Repair, maintenance, and other services are available. A repair service charges a fee for repairing a product, whereas a maintenance service charges an hourly fee. Some goods, fortunately, never need to be repaired. A product, on the other hand, may be repaired in a variety of ways. A customer may purchase an offering, and the company must maintain record of when the offering was purchased as well as the customer's contact person for that offering. Regrettably, not all of the items are purchased. Customers are recognized by their customer ID and are provided with descriptive information such as their name, address, and phone number. When a service is rendered, it is billed to a specific customer. Because some customers purchase offerings for their clients, they may be billed for services they did not acquire as well as services they did. The company must maintain track of the date the service was done, the date the bill is due, and the amount due when a client is billed for a service (although some customers may never require any sort of service at all).

Helpful Hints:

  • Customers (Entity Type) receive services from a technological business.
  • There are two sorts of offerings (Entity Type): products (Entity Type) and services (Entity Type). Hint: use supertype/subtype
  • An offering ID and a description attribute are used to identify it. Hint: Attributes of OFFERING
  • Furthermore, products are specified by their name, standard price, and date of initial release; Hint: Attributes of PRODUCT
  • services are described by the name of the company's unit responsible for the service, as well as the conditions of service. Hint: Attributes of SERVICE
  • Repair (Entity Type), maintenance (Entity Type), and other services are available. Hint: supertype/subtype
  • A repair service charges a fee for repairing a product, Hint: Attributes
  • whereas a maintenance service charges an hourly fee. Hint: Attributes
  • Fortunately, some products never require repair. However, there are many potential repair services for a product. Hint: identify the cardinality of the relationship
  • A customer (Entity Type) may purchase an offering, and the company must maintain a record of when the offering was purchased as well as the customer's contact person for that offering. Hint: (Attributes of the relationship) (or similarly attributes of associative entity)
  • Unfortunately, not all offerings are purchased. Hint: Identify the minimum in the cardinality of the relationship
  • Customers are recognized by their customer ID and are provided with descriptive information such as their name, address, and phone number. Hint: Attributes of CUSTOMER
  • When a service is performed, it is billed to some customer. Because some customers purchase offerings for their clients, they may be billed for services he or she did not purchase, as well as for ones that were purchased. Hint: identifies the cardinality in the relationship
  • The company must maintain track of the date the service was done, the date the bill is due, and the amount due when a client is billed for a service (although some customers may never require any sort of service at all). Hint: identifies the cardinality in the relationship


Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Explanation & Answer

Please view ...

Cebs_Nevry (1402)
Rice University

Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags