am to simple text that anyone understand it without entities , attributes or relationshops word.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Can you convert this ER diagram to simple text that anyone understand it without entities , attributes or relationshops word. 

Personal Vehicle
Color
Name
Manufacturer
Year
Address
Tag
Agent
Serial#
Phone#s
Vehicle
1
Drivetrain
Number
AgentID
Model
1
with
Doors
insure
Engine
Net Cost
1
Price
service
Liability
TotalCost 1
Deductible
Insura nce
Туре
Discount
Description
Expiry
Service Event
Term
Occurr ence
Date
Start
-----------------
1
Time
itemized
(Labor
Name
Fax
Pick Up
at
StationlD
Time
(Date
Address
Service Item
Station
Phone
Drop Off
M
Item#
Time
Date
Description
sells
Quantity
includes
PartType
Part
TotaLOCost )
PartCost
PartID
1
compose
Transcribed Image Text:Personal Vehicle Color Name Manufacturer Year Address Tag Agent Serial# Phone#s Vehicle 1 Drivetrain Number AgentID Model 1 with Doors insure Engine Net Cost 1 Price service Liability TotalCost 1 Deductible Insura nce Туре Discount Description Expiry Service Event Term Occurr ence Date Start ----------------- 1 Time itemized (Labor Name Fax Pick Up at StationlD Time (Date Address Service Item Station Phone Drop Off M Item# Time Date Description sells Quantity includes PartType Part TotaLOCost ) PartCost PartID 1 compose
Expert Solution
Step 1

The above ERD shows the personal vehicle features and activities if we are having a personal for example if we have a personal car then the bunch of activities which we perform in our car are shown by this ERD in the above figure.

Our car itself has some qualities like it has some color, model , total doors, engine, year of manufacture, serial number, and manufacturer. 

Our car must insure some insurance policy which has term i.e. some start and end time, net cost, pricing, some discount applicable, liability.

That insurance policy is with some agent who have qualities like he has some name, a agent id, address, and phone number.

Your car has several service event in which car used to get its service done means at a fixed interval or the time when it needs service the service events or service has a type means what type of service it wants means whole or a particular part, description of service, occurrence of service means it must be having some start time and some date given, and total cost.

 

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY