Lorenzo

Database Diagram for Lorenzo Transit Company

City City.city_id City.city_name City.state City.population City.area Customer Customer.cust_id Customer.cust_name Customer.annual_revenue Customer.cust_type Customer.address Customer.city Customer.state Customer.zip Customer.phone Shipment Shipment.ship_id Shipment.cust_id Shipment.weight Shipment.truck_id Shipment.driver_id Shipment.city_id Shipment.ship_date Driver Driver.driver_id Driver.first_name Driver.last_name Driver.address Driver.city Driver.state Driver.zip_code Driver.phone Customer JOIN Shipment ON Customer.cust_id = Shipment.cust_id Shipment JOIN Truck ON Shipment.truck_id = Truck.truck_id Shipment JOIN Driver ON Shipment.driver_id = Driver.driver_id Shipment JOIN City ON Shipment.city_id = City.city_id