menu
bartleby
search
close search
Hit Return to see all results

Draw an EER diagram for the following situation using the traditional EER notation. A technology company provides offerings to its customers. 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 described 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 product; 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 keep track of when the offering was purchased and the contact person for that offering with the customer. Unfortunately, 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 performed, that service is billed to some customer. Because some customers purchase offerings for their clients, a customer may be billed for services he or she did not purchase, 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 track of the date the service was performed, the date the bill is due, and the amount due.

Question

Draw an EER diagram for the following situation using the traditional EER notation. A technology company provides offerings to its customers. 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 described 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 product; 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 keep track of when the offering was purchased and the contact person for that offering with the customer. Unfortunately, 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 performed, that service is billed to some customer. Because some customers purchase offerings for their clients, a customer may be billed for services he or she did not purchase, 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 track of the date the service was performed, the date the bill is due, and the amount due.

check_circleAnswer
Step 1

EER diagram is stand for enhanced entity relationship diagram. EER is used for designed high- level database models.

A technology company provides products and services, two types of offering to customers. Products offering have attributes like product name, product price and date. Service offering is three type repair, maintenance and other type. Repair service has a cost and maintenance has hourly rate. Customer have an ID, name, address and contact number.

Step 2

EER diagram of the offe...

Offering ID
Description
Customer offering
offering date
offering iD
Customer
Customer iD
Offering
customer name
contact person
customer address
Customer 1D
phone number
Purchase
Products
Services
offering io
Product name
Standard price
Company's service
providing unit
conditions of service
offering type
customer iD
oate of first release
date
Types of services
виl
Record
ofering iD
Type of offering
Service performance date
sill due date
date
Amount due
customer iD
amount
other
Repair
Maintenance
Cost
Hourly rate
help_outline

Image Transcriptionclose

Offering ID Description Customer offering offering date offering iD Customer Customer iD Offering customer name contact person customer address Customer 1D phone number Purchase Products Services offering io Product name Standard price Company's service providing unit conditions of service offering type customer iD oate of first release date Types of services виl Record ofering iD Type of offering Service performance date sill due date date Amount due customer iD amount other Repair Maintenance Cost Hourly rate

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Our solutions are written by experts, many with advanced degrees, and available 24/7

See Solution
Tagged in

Engineering

Computer Science

Relational Databases

Related Computer Science Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: ________ analyze the business situation and identify the need for information and information servic...

A: DescriptionSystem AnalystsSystem Analysts are those who basically works with the users as well as th...

question_answer

Q: In C++ Create an array of 100 random numbers between 1 and 1000. Ask the user for a number. Search t...

A: A C++ program to search the user’s number in an array containing 100 random numbers between "1" and ...

question_answer

Q: use java Develop a program which allows the user to enter numbers into an array. Input will be as fo...

A: Program plan:Import the required packages.Define a class named “ArraySort”.Define a “main()” method....

question_answer

Q: What sensors are compatible with MIT App Inventor? Does MIT App Inventor have the ability to interac...

A: MIT App InventorIt basically lets the developer to develop the applications for Android phones using...

question_answer

Q: Consider the following procedure: procedure mystery (x, y, z); integer x, y, z;beginz =2; y = z + x;...

A: Call by reference The arguments passed to a function will copy the address of an argument into the f...

question_answer

Q: please help me solve this problem  the language is C++

A: Program Instructions:Ask the user the name of each friend one by one.Calculate the 20% tip, total bi...

question_answer

Q: Construct an npda corresponding to the grammar S→aABB|aAA,A→aBB|b,B→bBB|A.

A: Firstly, we will convert the given grammar into GNFS → aABB|aAAA → aBB|bB → bBB|aBB|a

question_answer

Q: Part 1: Stack As mentioned in class, Python 3 provides the LifoQueue class as part of the Queue libr...

A: Import the given class in another file.Create the function postfix() which takes a string as its arg...

question_answer

Q: Develop the ‘Shape’ application such that: ‘Rectangle’, ‘Ellipse’, and ‘Triangle’ classes inherit f...

A: Program plan:Define a class named “Shape”.Define a default constructor to print constructor invoked ...

Sorry about that. What wasn’t helpful?