5

来源:互联网 发布:网络系统拓扑图 编辑:程序博客网 时间:2024/04/27 13:24

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