Question
Making a Er Diagram for a Transportation Company that moves Cars, Trucks, Motorcycle across the country. Clients consist of member of a Dispatch vehicle website
Making a Er Diagram for a Transportation Company that moves Cars, Trucks, Motorcycle across the country. Clients consist of member of a Dispatch vehicle website named Central Dispatch and also outside sources.
Store Expenses (Damages, Diesel, Food, Truck repair or Maintenance, tires, etc.)
Store all vehicles transported from Pickup to delivery and type
Store Customer information, Account Receivable
Each 18 wheeler holds 8-10 motor vehicles. I need to make a er model thats make a order to pick up vehicle then deliver than track expenses. I uploaded a picture of what i have so far probably mostly wrong, if you can add any entities i'm missing and fix my relationships and attributes
Central Disptach Faxed In Dispatched transportation accepted Driver Customer Order Phone Company Name Fname Lname Address City Zip Acct Receivable Model Make Color Year Run/Drives Vin number Condition Delivery Locatior PickUp Locaiton SSN Drive Fname Driver Lname Truck Number Class A License Phone Emergency Cont Home Location Relationshipg Trip Expenses Trip Number Diesel Expense Damage to Cargo Truck Repair Truck Maintennc Tires Road Service Central Disptach Faxed In Dispatched transportation accepted Driver Customer Order Phone Company Name Fname Lname Address City Zip Acct Receivable Model Make Color Year Run/Drives Vin number Condition Delivery Locatior PickUp Locaiton SSN Drive Fname Driver Lname Truck Number Class A License Phone Emergency Cont Home Location Relationshipg Trip Expenses Trip Number Diesel Expense Damage to Cargo Truck Repair Truck Maintennc Tires Road ServiceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started