5

CUST_ID	CUST_NAME	ANNUAL_REVENUE	CUST_TYPE
100	Revathi	500000	manufacturer
101	Richa	1800000	wholesaler
102	Rishi	1000000	retailer
103	Rajesh	4000000	wholesaler
104	Kalyan	24800000	wholesaler

Data for TRUCK table

 

TRUCK_NO	DRIVER_NAME
100	Jensen
101	Sasi
102	Jake Stinson
103	Alex

Data for CITY table

 

CITY_NAME	POPULATION
London	100000000
Paris	120000000
Rome	200000000
Panama City	1230000000
San Francisco	20000000

Data for SHIPMENT table

 

SHIPMENT_NO	CUST_ID	WEIGHT	TRUCK_NO	DESTINATION
100	101	500	101	Rome
101	101	100	102	London
102	103	300	101	London
103	103	10	101	Paris
104	101	20	103	Paris
105	101	200	101	San Francisco
106	100	50	101	Rome
107	102	500	101	Rome
108	101	50	102	San Francisco
109	101	25	100	Paris
110	101	25	101	Panama City