08:54ll 4Gelearn20.miun.sePart 1)Given the ER-diagrams shown below, describe (in anorganized way) as much as you can about the real worldthat the diagram represents. Be sure to identify what eachentity are relationship are and to describe all constraintsrelated to them.Personal VehicleColorNameManufacturerYearAddressТagAgentSerial#Phone#sVehicle1DrivetrainNumberAgentIDModelwithDoorsinsureEngineNet CostPriceserviceLiability(TotalCostMDeductibleInsuranceТуреDiscountDescriptionExpiryService EventOccurrenceDateTermStart1(TimeitemizedCaborNameFaxPick UpatStationIDTime DateAddressServicettemStationPhoneDropOffMItem#Time DateDescriptionsellsQuantity 2includesMPartType(TotaLCost )PartCostPartPartIDcompose

This is the ER diagram of Personal Vehicle.We have to explain each relationship and each constraints…

Part 1) Given the ER-diagrams shown below, describe (in an organized way) as much as you can about the real world that the diagram represents. Be sure to identify what each entity are relationship are and to describe all constraints related to them. Personal Vehicle Color Name Manufacturer Year Address Tag Agent Serial# Phone#s Vehicle 1 Drivetrain Number AgentID Model 1 with Doors insure Engine 1 NetCost Price service Liability (TotalCost ) Deductible Insurance Туре Discount Description (Expiry Service Event Term Start Date (Time Occurrence itemized Labor Name Fax Pick Up at StationID Time) Date Address ServiceJtem Station Phone DropOff M Item# (Time) Date Description sells N Quantity2 includes > PartType TotalCost ) PartCost Part - - -- PartID compose

Part 1) Given the ER-diagrams shown below, describe (in an organized way) as much as you can about the real world that the diagram represents. Be sure to identify what each entity are relationship are and to describe all constraints related to them. Personal Vehicle Color Name Manufacturer Year Address Tag Agent Serial# Phone#s Vehicle 1 Drivetrain Number AgentID Model 1 with Doors insure Engine 1 NetCost Price service Liability (TotalCost ) Deductible Insurance Туре Discount Description (Expiry Service Event Term Start Date (Time Occurrence itemized Labor Name Fax Pick Up at StationID Time) Date Address ServiceJtem Station Phone DropOff M Item# (Time) Date Description sells N Quantity2 includes > PartType TotalCost ) PartCost Part - - -- PartID compose

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...

See similar textbooks

Related questions

Q: An instructor has several phone numbers. When reducing the ER diagram down to a schema this must be…

A: Actually, ER is describes the structure of database with help of diagram.

Q: Using this completed instance diagram fill in the cardinality symbols for the ERD below. You will…

Q: Given the ER-diagrams shown below, describe (in an organized way) as much as you can about the real…

A: ER diagram: ER Model is used to model the logical view of the system from data perspective which…