World Tables

 

1. Demog.txt

 

<PRE>

Drop table world_pop;

Create table world_pop (HDI_Rank Number, country Varchar2(25),

       pop_mil_70 Number, pop_mil_95 Number, pop_mil_15 Number,

       constraint hdi_pk primary key (hdi_rank));

insert into world_pop values (1,'Canada',21.3,29.4,34.2);

insert into world_pop values (2,'France',50.8,58.1,60.2);

insert into world_pop values (3,'Norway',3.9,4.3,4.6);

insert into world_pop values (4,'USA',210.1,267.1,310.8);

insert into world_pop values (5,'Iceland',0.2,0.3,0.3);

insert into world_pop values (6,'Finland',4.6,5.1,5.3);

insert into world_pop values (7,'Netherlands',13,15.5,16.2);

insert into world_pop values (8,'Japan',104.3,125.1,125.8);

insert into world_pop values (9,'New Zealand',2.8,3.6,4.4);

insert into world_pop values (10,'Sweden',8,8.8,9.2);

insert into world_pop values (11,'Spain',33.8,39.6,38.9);

insert into world_pop values (12,'Belgium',9.7,10.1,10.3);

insert into world_pop values (13,'Austria',7.5,8,8.4);

insert into world_pop values (14,'United Kingdom',55.6,58.1,59);

insert into world_pop values (15,'Australia',12.5,17.9,21.9);

insert into world_pop values (16,'Switzerland',6.2,7.2,7.6);

insert into world_pop values (17,'Ireland',3,3.5,3.7);

insert into world_pop values (18,'Denmark',4.9,5.2,5.3);

insert into world_pop values (19,'Germany',77.7,81.6,82.1);

insert into world_pop values (20,'Greece',8.8,10.5,10.4);

insert into world_pop values (21,'Italy',53.8,57.2,54.6);

insert into world_pop values (22,'Israel',3,5.5,7.3);

insert into world_pop values (23,'Cyprus',0.6,0.7,0.9);

insert into world_pop values (24,'Barbados',0.2,0.3,0.3);

insert into world_pop values (25,'Hong Kong, China',3.9,6.1,6.5);

insert into world_pop values (26,'Luxembourg',0.3,0.4,0.5);

insert into world_pop values (27,'Malta',0.3,0.4,0.4);

insert into world_pop values (28,'Singapore',2.1,3.3,4);

insert into world_pop values (29,'Antigua and Barbuda',0.1,0.1,0.1);

insert into world_pop values (30,'Korea, Rep. of',31.9,44.9,51.1);

insert into world_pop values (31,'Chile',9.5,14.2,17.9);

insert into world_pop values (32,'Bahamas',0.2,0.3,0.4);

insert into world_pop values (33,'Portugal',9,9.8,9.6);

insert into world_pop values (34,'Costa Rica',1.7,3.4,4.9);

insert into world_pop values (35,'Brunei Darussalam',0.1,0.3,0.4);

insert into world_pop values (36,'Argentina',24,34.8,43.5);

insert into world_pop values (37,'Slovenia',1.7,1.9,1.8);

insert into world_pop values (38,'Uruguay',2.8,3.2,3.5);

insert into world_pop values (39,'Czech Republic',9.8,10.3,9.9);

insert into world_pop values (40,'Trinidad and Tobago',1,1.3,1.6);

insert into world_pop values (41,'Dominica',0.1,0.1,0.1);

insert into world_pop values (42,'Slovakia',4.5,5.3,5.5);

insert into world_pop values (43,'Bahrain',0.2,0.6,0.8);

insert into world_pop values (44,'Fiji',0.5,0.8,1.1);

insert into world_pop values (45,'Panama',1.5,2.6,3.5);

insert into world_pop values (46,'Venezuela',10.7,21.8,30.9);

insert into world_pop values (47,'Hungary',10.3,10.1,9.1);

insert into world_pop values (48,'United Arab Emirates',0.2,2.2,3);

insert into world_pop values (49,'Mexico',50.6,91.1,119.2);

insert into world_pop values (50,'Saint Kitts and Nevis',0,0,0);

insert into world_pop values (51,'Grenada',0.1,0.1,0.1);

insert into world_pop values (52,'Poland',32.5,38.6,39.7);

insert into world_pop values (53,'Colombia',21.4,35.8,47.6);

insert into world_pop values (54,'Kuwait',0.7,1.7,2.6);

insert into world_pop values (55,'Saint Vincent',0.1,0.1,0.1);

insert into world_pop values (56,'Seychelles',0.1,0.1,0.1);

insert into world_pop values (57,'Qatar',0.1,0.5,0.7);

insert into world_pop values (58,'Saint. Lucia',0.1,0.1,0.2);

insert into world_pop values (59,'Thailand',35.7,58.2,66.3);

insert into world_pop values (60,'Malaysia',10.9,20.1,28);

insert into world_pop values (61,'Mauritius',0.8,1.1,1.4);

insert into world_pop values (62,'Brazil',96,159,199.6);

insert into world_pop values (63,'Belize',0.1,0.2,0.3);

insert into world_pop values (64,'Libyan Arab Jamahiriya',2,5.4,10.1);

insert into world_pop values (65,'Suriname',0.4,0.4,0.5);

insert into world_pop values (66,'Lebanon',2.5,3,4);

insert into world_pop values (67,'Bulgaria',8.5,8.5,7.8);

insert into world_pop values (68,'Belarus',9,10.4,9.9);

insert into world_pop values (69,'Turkey',35.3,60.8,78.6);

insert into world_pop values (70,'Saudi Arabia',5.7,18.3,33.5);

insert into world_pop values (71,'Oman',0.7,2.2,4.8);

insert into world_pop values (72,'Russian Federation',130.4,148.5,138.1);

insert into world_pop values (73,'Ecuador',6,11.5,15.9);

insert into world_pop values (74,'Romania',20.3,22.7,21.8);

insert into world_pop values (75,'DPR of Korea',14.3,22.1,27.7);

insert into world_pop values (76,'Croatia',4.2,4.5,4.4);

insert into world_pop values (77,'Estonia',1.4,1.5,1.3);

insert into world_pop values (78,'Islamic Rep of Iran',28.4,68.4,109.5);

insert into world_pop values (79,'Lithuania',3.1,3.7,3.6);

insert into world_pop values (80,'Macedonia, FYR',1.6,2.2,2.4);

insert into world_pop values (81,'Syrian Arab Republic',6.3,14.2,22.7);

insert into world_pop values (82,'Algeria',13.7,28.1,41.6);

insert into world_pop values (83,'Tunisia',5.1,9,12.1);

insert into world_pop values (84,'Jamaica',1.9,2.5,3);

insert into world_pop values (85,'Cuba',8.5,11,11.6);

insert into world_pop values (86,'Peru',13.2,23.5,31.9);

insert into world_pop values (87,'Jordan',2.3,5.4,9.6);

insert into world_pop values (88,'Dominican Republic',4.4,7.8,10.3);

insert into world_pop values (89,'South Africa',22.5,41.5,61.8);

insert into world_pop values (90,'Sri Lanka',12.5,17.9,22.1);

insert into world_pop values (91,'Paraguay',2.3,4.8,7.8);

insert into world_pop values (92,'Latvia',2.4,2.5,2.2);

insert into world_pop values (93,'Kazakhstan',13.1,16.8,18.7);

insert into world_pop values (94,'Western Samoa',0.1,0.2,0.2);

insert into world_pop values (95,'Maldives',0.1,0.3,0.5);

insert into world_pop values (96,'Indonesia',120.3,197.5,251.8);

insert into world_pop values (97,'Botswana',0.6,1.5,2.2);

insert into world_pop values (98,'Philippines',37.5,67.8,94.9);

insert into world_pop values (99,'Armenia',2.5,3.6,4);

insert into world_pop values (100,'Guyana',0.7,0.8,1);

insert into world_pop values (101,'Mongolia',1.3,2.5,3.6);

insert into world_pop values (102,'Ukraine',47.3,51.8,48.1);

insert into world_pop values (103,'Turkmenistan',2.2,4.1,5.7);

insert into world_pop values (104,'Uzbekistan',12,22.8,32.3);

insert into world_pop values (105,'Albania',2.1,3.4,3.9);

insert into world_pop values (106,'China',830.7,1220.2,1409.1);

insert into world_pop values (107,'Namibia',0.8,1.5,2.5);

insert into world_pop values (108,'Georgia',4.7,5.4,5.6);

insert into world_pop values (109,'Kyrgyzstan',3,4.5,5.3);

insert into world_pop values (110,'Azerbaijan',5.2,7.5,8.9);

insert into world_pop values (111,'Guatemala',5.2,10.6,17.8);

insert into world_pop values (112,'Egypt',35.3,62.1,85.4);

insert into world_pop values (113,'Moldova, Rep. of',3.6,4.4,4.7);

insert into world_pop values (114,'El Salvador',3.6,5.7,8.1);

insert into world_pop values (115,'Swaziland',0.4,0.9,1.4);

insert into world_pop values (116,'Bolivia',4.2,7.4,11.2);

insert into world_pop values (117,'Cape Verde',0.3,0.4,0.6);

insert into world_pop values (118,'Tajikistan',2.9,5.8,8.5);

insert into world_pop values (119,'Honduras',2.6,5.7,9);

insert into world_pop values (120,'Gabon',0.5,1.1,1.7);

insert into world_pop values (121,'Sâo Tomé and Principe',0.1,0.1,0.2);

insert into world_pop values (122,'Viet Nam',42.7,73.8,98.1);

insert into world_pop values (123,'Solomon Islands',0.2,0.4,0.7);

insert into world_pop values (124,'Vanuatu',0.1,0.2,0.3);

insert into world_pop values (125,'Morocco',15.3,26.5,35.6);

insert into world_pop values (126,'Nicaragua',2.1,4.1,6.5);

insert into world_pop values (127,'Iraq',9.4,20.1,34.2);

insert into world_pop values (128,'Congo',1.3,2.6,4.5);

insert into world_pop values (129,'Papua New Guinea',2.4,4.3,6.5);

insert into world_pop values (130,'Zimbabwe',5.3,11.2,16.8);

insert into world_pop values (131,'Myanmar',27.1,45.1,61.1);

insert into world_pop values (132,'Cameroon',6.6,13.2,22.5);

insert into world_pop values (133,'Ghana',8.6,17.3,29.4);

insert into world_pop values (134,'Lesotho',1.1,2,3.3);

insert into world_pop values (135,'Equatorial Guinea',0.3,0.4,0.6);

insert into world_pop values (136,'PDR Lao',2.7,4.9,8.4);

insert into world_pop values (137,'Kenya',11.5,27.1,43.2);

insert into world_pop values (138,'Pakistan',65.7,136.3,224.5);

insert into world_pop values (139,'India',554.9,929,1211.7);

insert into world_pop values (140,'Cambodia',6.9,10,14.7);

insert into world_pop values (141,'Comoros',0.3,0.6,1.1);

insert into world_pop values (142,'Nigeria',55.1,111.7,190.9);

insert into world_pop values (143,'DR of the Congo',20.3,45.5,80.9);

insert into world_pop values (144,'Togo',2,4.1,6.9);

insert into world_pop values (145,'Benin',2.7,5.4,9.6);

insert into world_pop values (146,'Zambia',4.2,8.1,13.2);

insert into world_pop values (147,'Bangladesh',66.7,118.2,162.7);

insert into world_pop values (148,'Côte d Ivoire',5.5,13.7,21);

insert into world_pop values (149,'Mauritania',1.2,2.3,3.7);

insert into world_pop values (150,'Tanzania, U. Rep. of',13.7,30,49.9);

insert into world_pop values (151,'Yemen',6.3,15,29.8);

insert into world_pop values (152,'Nepal',11.3,21.5,34.1);

insert into world_pop values (153,'Madagascar',6.9,14.9,27);

insert into world_pop values (154,'Central African Republic',1.8,3.3,5);

insert into world_pop values (155,'Bhutan',1,1.8,2.9);

insert into world_pop values (156,'Angola',5.6,10.8,19.8);

insert into world_pop values (157,'Sudan',13.9,26.7,40.4);

insert into world_pop values (158,'Senegal',4.2,8.3,13.8);

insert into world_pop values (159,'Haiti',4.5,7.1,10.4);

insert into world_pop values (160,'Uganda',9.8,19.7,34.8);

insert into world_pop values (161,'Malawi',4.5,9.7,16.1);

insert into world_pop values (162,'Djibouti',0.1,0.6,1);

insert into world_pop values (163,'Chad',3.7,6.3,10.3);

insert into world_pop values (164,'Guinea Bissau',0.5,1.1,1.6);

insert into world_pop values (165,'Gambia',0.5,1.1,1.7);

insert into world_pop values (166,'Mozambique',9.4,17.3,28.3);

insert into world_pop values (167,'Guinea',3.9,7.3,11.9);

insert into world_pop values (168,'Eritrea',1.8,3.2,5.4);

insert into world_pop values (169,'Ethiopia',28.8,56.4,103.6);

insert into world_pop values (170,'Burundi',3.5,6.1,10);

insert into world_pop values (171,'Mali',5.5,10.8,19.2);

insert into world_pop values (172,'Burkina Faso',5.4,10.5,18.3);

insert into world_pop values (173,'Niger',4.2,9.2,17.1);

insert into world_pop values (174,'Sierra Leone',2.7,4.2,6.7);

</PRE>

 

2. Econ.txt

 

<PRE>

Drop table world_econ;

Create table world_econ (HDI_rank Number, GDP number, Agri_pc number,

       Ind_pc number, Serv_pc number, Cons_priv_pc number, Cons_gov_pc number,

       Gov_expend_pc number, Exports_pc number, Imports_pc number,

       Constraint hdi_econ_pk primary key (HDI_rank),

       Constraint hdi_econ_fk foreign key (HDI_rank) references world_pop (HDI_Rank));

insert into world_econ values (1,568928,0,0,0,59.55,19.14,0,36.91,34.51);

insert into world_econ values (2,1536089,2,27,71,59.85,20.12,46.8,22.86,20.49);

insert into world_econ values (3,145954,0,0,0,50,20.88,39.1,38.31,32.43);

insert into world_econ values (4,6952020,2,26,72,0,16.26,22.9,11.33,13.03);

insert into world_econ values (5,0,0,0,0,60.39,20.97,0,36.42,33.15);

insert into world_econ values (6,125432,6,37,57,54.1,21.47,43.7,37.98,29.98);

insert into world_econ values (7,395900,3,27,70,57.12,14.15,50.8,52.97,46.29);

insert into world_econ values (8,5108540,2,38,60,59.71,9.75,0,9.46,7.92);

insert into world_econ values (9,57070,0,0,0,59.81,14.64,36.2,31.58,30.03);

insert into world_econ values (10,228679,2,32,66,55.27,26.19,45,40.61,36.43);

insert into world_econ values (11,558617,3,0,0,61.97,16.32,39.4,23.67,23.42);

insert into world_econ values (12,269081,2,0,0,61.53,14.92,53.4,74.38,68.71);

insert into world_econ values (13,233427,2,34,63,55.44,18.75,40.4,38.13,38.95);

insert into world_econ values (14,1105822,2,32,66,64,21.31,44,28.03,29.03);

insert into world_econ values (15,348782,3,28,70,60.37,17.46,29.1,19.79,20.33);

insert into world_econ values (16,300508,0,0,0,58.75,14.13,26.3,35.7,31.93);

insert into world_econ values (17,60780,0,0,0,57.15,15.46,42.5,75.48,60.88);

insert into world_econ values (18,172220,4,29,67,53.78,25.15,43.5,34.91,29.39);

insert into world_econ values (19,2415764,0,0,0,57.73,19.6,33.9,23.47,22.28);

insert into world_econ values (20,90550,21,36,43,74.47,18.59,43.2,22.41,34.15);

insert into world_econ values (21,1086932,3,31,66,62.29,15.98,49.9,26.35,23.12);

insert into world_econ values (22,91965,0,0,0,58.05,28.71,45.2,29.43,39.7);

insert into world_econ values (23,0,0,0,0,0,0,0,0,0);

insert into world_econ values (24,0,0,0,0,0,0,0,0,0);

insert into world_econ values (25,143669,0,17,83,58.82,8.57,0,147.13,149.4);

insert into world_econ values (26,0,0,0,0,0,12.78,0,96.3,87.55);

insert into world_econ values (27,0,0,0,0,0,0,0,0,0);

insert into world_econ values (28,83695,0,36,64,40,8.52,14.9,0,0);

insert into world_econ values (29,0,0,0,0,0,0,0,0,0);

insert into world_econ values (30,455476,7,43,50,53.55,10.36,17.8,33.19,34.22);

insert into world_econ values (31,67297,0,0,0,61.98,8.76,19.5,29.26,27.36);

insert into world_econ values (32,0,0,0,0,0,0,0,0,0);

insert into world_econ values (33,102337,0,0,0,65,17.38,37.7,28.34,37.51);

insert into world_econ values (34,9233,17,24,58,59.67,16.8,28.4,40.87,42.13);

insert into world_econ values (35,0,0,0,0,0,0,0,0,0);

insert into world_econ values (36,281060,6,31,63,0,0,0,8.52,8.47);

insert into world_econ values (37,18550,5,39,57,57.85,20.8,0,55.74,56.89);

insert into world_econ values (38,17847,9,26,65,74.04,12.76,31.8,19.1,19.98);

insert into world_econ values (39,44772,6,39,55,59.51,20.28,42,51.64,56.14);

insert into world_econ values (40,5327,3,42,54,61.99,13.07,0,39.49,28.76);

insert into world_econ values (41,0,0,0,0,0,0,0,0,0);

insert into world_econ values (42,17414,6,33,61,49.8,20.08,0,62.89,61.11);

insert into world_econ values (43,0,0,0,0,0,0,0,0,0);

insert into world_econ values (44,0,0,0,0,69.55,18.91,0,51.16,53.12);

insert into world_econ values (45,7413,11,15,74,63.55,14.74,28.3,38.55,40.34);

insert into world_econ values (46,75016,5,38,56,73.31,6.12,18.8,26.75,22.05);

insert into world_econ values (47,43712,8,33,59,67.98,11.45,0,34.95,37.17);

insert into world_econ values (48,39107,2,57,40,0,0,11.8,0,0);

insert into world_econ values (49,250038,8,26,67,71.2,10.28,14.3,25.47,22.23);

insert into world_econ values (50,0,0,0,0,0,0,0,0,0);

insert into world_econ values (51,0,0,0,0,58.49,16.32,0,19.96,26.97);

insert into world_econ values (52,117663,6,39,54,63.24,18.17,43.4,27.92,26.33);

insert into world_econ values (53,76112,14,32,54,75.4,8.84,14.4,15.36,19.62);

insert into world_econ values (54,26650,0,53,46,48.95,33.05,51.4,54.74,49.07);

insert into world_econ values (55,0,0,0,0,0,0,0,0,0);

insert into world_econ values (56,0,0,0,0,0,0,0,0,0);

insert into world_econ values (57,0,0,0,0,0,0,0,0,0);

insert into world_econ values (58,0,0,0,0,0,0,0,0,0);

insert into world_econ values (59,167056,11,40,49,54.03,9.74,10.5,41.51,48.4);

insert into world_econ values (60,85311,13,43,44,50.66,12.15,23.2,95.5,98.9);

insert into world_econ values (61,3919,9,33,58,65.45,12.3,23.3,58.38,61.5);

insert into world_econ values (62,688085,14,37,49,61.82,17.12,39,6.96,7.78);

insert into world_econ values (63,0,0,0,0,0,0,0,0,0);

insert into world_econ values (64,0,0,0,0,0,0,0,0,0);

insert into world_econ values (65,0,0,0,0,0,0,0,0,0);

insert into world_econ values (66,11143,7,24,69,0,0,25.8,0,0);

insert into world_econ values (67,12366,13,34,53,60.71,14.5,43,49.08,45.15);

insert into world_econ values (68,20561,13,35,52,57.67,21.9,0,42.73,47.47);

insert into world_econ values (69,164789,16,31,53,69.81,9.94,27,20.28,24.99);

insert into world_econ values (70,125501,0,0,0,0,0,0,0,0);

insert into world_econ values (71,12102,0,0,0,0,0,42.9,0,0);

insert into world_econ values (72,344711,7,38,55,58.43,15.95,27.1,22.33,21.71);

insert into world_econ values (73,17939,12,36,52,66.73,12.58,15.7,28.76,26.76);

insert into world_econ values (74,35533,21,40,39,66.49,12.29,32,27.56,32.07);

insert into world_econ values (75,0,0,0,0,0,0,0,0,0);

insert into world_econ values (76,18081,12,25,62,65.72,32.86,46.5,40.26,52.86);

insert into world_econ values (77,4007,8,28,64,58.42,23.38,0,75.48,84.14);

insert into world_econ values (78,0,0,0,0,53.28,12.66,0,20.57,15.82);

insert into world_econ values (79,7089,11,36,53,63.14,20.41,27.4,57.84,60.59);

insert into world_econ values (80,1975,0,0,0,82.25,13.78,0,37.28,48.7);

insert into world_econ values (81,16783,0,0,0,0,0,26.6,0,0);

insert into world_econ values (82,41435,13,47,41,55.52,15.68,0,26.7,29.91);

insert into world_econ values (83,18035,12,29,59,63.33,16.36,0,44.85,48.5);

insert into world_econ values (84,4406,9,38,53,80.08,9.46,0,68.89,75.85);

insert into world_econ values (85,0,0,0,0,0,0,0,0,0);

insert into world_econ values (86,57424,7,38,55,83.24,6.09,18.9,11.92,18.05);

insert into world_econ values (87,6105,8,27,65,0,0,30.8,0,0);

insert into world_econ values (88,11277,15,22,64,80.37,3.5,16.9,25.89,29.46);

insert into world_econ values (89,136035,5,31,64,60.8,20.98,33.2,22.05,22.11);

insert into world_econ values (90,12915,23,25,52,74.03,11.83,28.6,35.92,46.9);

insert into world_econ values (91,7743,24,22,54,0,0,13,0,0);

insert into world_econ values (92,6034,9,31,60,64.86,19.63,30.4,42.74,48.02);

insert into world_econ values (93,21413,12,30,57,65.12,15.47,0,34.5,37.09);

insert into world_econ values (94,0,0,0,0,0,0,0,0,0);

insert into world_econ values (95,0,0,0,0,0,0,0,0,0);

insert into world_econ values (96,198079,17,42,41,55.99,8.21,16.2,25.45,27.45);

insert into world_econ values (97,4318,5,46,48,45.41,31.94,38.3,49.39,51.58);

insert into world_econ values (98,74180,22,32,46,74.04,11.22,18.4,36.28,44.03);

insert into world_econ values (99,2058,44,35,20,116.38,13.08,0,23.67,61.93);

insert into world_econ values (100,0,0,0,0,0,0,0,72.96,86.34);

insert into world_econ values (101,861,0,0,0,0,0,21.4,0,0);

insert into world_econ values (102,80127,18,42,41,0,0,0,0,0);

insert into world_econ values (103,0,0,0,0,0,0,0,0,0);

insert into world_econ values (104,21590,33,34,34,0,0,0,0,0);

insert into world_econ values (105,2192,56,21,23,92.57,15.27,34.1,13.79,38.13);

insert into world_econ values (106,697647,21,48,31,45.74,12.23,0,20.95,19.4);

insert into world_econ values (107,3033,14,29,56,0,0,40.7,0,0);

insert into world_econ values (108,2325,67,22,11,102.52,6.55,0,16.84,29.39);

insert into world_econ values (109,3028,44,24,32,67.44,22.59,0,26.34,32.07);

insert into world_econ values (110,3475,27,32,41,0,0,0,26.99,39.19);

insert into world_econ values (111,14489,25,19,56,0,0,9.2,0,0);

insert into world_econ values (112,47349,20,21,59,80.61,13.44,42.8,21.29,32.26);

insert into world_econ values (113,3518,50,28,22,81.07,19.67,0,35.17,42.62);

insert into world_econ values (114,9471,14,22,65,85.94,7.88,14.9,20.98,34.24);

insert into world_econ values (115,0,0,0,0,64.28,26.63,0,83.21,91.21);

insert into world_econ values (116,6131,0,0,0,0,0,24.1,0,0);

insert into world_econ values (117,0,0,0,0,0,0,0,0,0);

insert into world_econ values (118,0,0,0,0,71.1,10.8,0,114.31,113.62);

insert into world_econ values (119,3937,21,33,46,72.73,13.57,0,35.54,44.7);

insert into world_econ values (120,4691,0,0,0,41.91,10.16,0,61.09,39.47);

insert into world_econ values (121,0,0,0,0,0,0,0,0,0);

insert into world_econ values (122,20351,28,30,42,76.77,6.92,0,35.9,46.7);

insert into world_econ values (123,0,0,0,0,0,0,0,0,0);

insert into world_econ values (124,0,0,0,0,0,0,0,0,0);

insert into world_econ values (125,32412,14,33,53,71.16,15.47,0,27.28,34.91);

insert into world_econ values (126,1911,33,20,46,0,0,30.4,0,0);

insert into world_econ values (127,0,0,0,0,0,0,0,0,0);

insert into world_econ values (128,2163,10,38,51,64.44,12.36,0,61.81,65.76);

insert into world_econ values (129,4901,26,38,34,48.16,12.44,29.4,60.5,45.23);

insert into world_econ values (130,6522,15,36,48,0,0,0,0,0);

insert into world_econ values (131,0,0,0,0,0,0,0,0,0);

insert into world_econ values (132,7931,39,23,38,70.75,8.62,15.5,25.86,19.73);

insert into world_econ values (133,6315,46,16,38,77.46,12.42,20.6,25.05,33.53);

insert into world_econ values (134,1029,10,56,34,85.46,23.43,33.3,20.85,117.08);

insert into world_econ values (135,0,0,0,0,0,0,0,0,0);

insert into world_econ values (136,1760,52,18,30,0,0,0,0,0);

insert into world_econ values (137,9095,29,17,54,72.3,14.78,27.4,32.62,38.91);

insert into world_econ values (138,60649,26,24,50,72.55,11.74,23.2,16.41,19.4);

insert into world_econ values (139,324082,29,29,41,67.87,10.34,16,12.24,14.98);

insert into world_econ values (140,2771,51,14,34,0,0,0,0,0);

insert into world_econ values (141,0,0,0,0,86.69,21.2,0,19.34,44.37);

insert into world_econ values (142,26817,28,53,18,0,9.62,0,0,0);

insert into world_econ values (143,0,0,0,0,0,0,0,0,0);

insert into world_econ values (144,981,38,21,41,80.07,11.42,0,30.79,0);

insert into world_econ values (145,1522,34,12,53,0,0,0,0,0);

insert into world_econ values (146,4073,22,40,37,87.82,8.87,16.8,31.49,39.91);

insert into world_econ values (147,29110,31,18,52,77.92,13.74,0,14.19,22.48);

insert into world_econ values (148,10069,31,20,50,67.43,12.43,0,41.43,34.49);

insert into world_econ values (149,1068,27,30,43,79.55,9.31,0,50.42,53.78);

insert into world_econ values (150,3602,58,17,24,96.79,10.29,0,29.81,67.89);

insert into world_econ values (151,4790,22,27,51,0,0,38.5,0,0);

insert into world_econ values (152,4232,42,22,36,79.42,8.22,0,24.29,35.38);

insert into world_econ values (153,3198,34,13,53,90.63,6.63,18.8,23.34,31.42);

insert into world_econ values (154,1128,44,13,43,80.34,13.41,0,18.47,27.34);

insert into world_econ values (155,0,0,0,0,0,0,0,0,0);

insert into world_econ values (156,3722,12,59,28,9.38,47.43,0,73.92,58.04);

insert into world_econ values (157,0,0,0,0,0,0,0,0,0);

insert into world_econ values (158,4867,20,18,62,78.5,11.16,0,31.63,36.92);

insert into world_econ values (159,2043,44,12,44,0,0,0,0,0);

insert into world_econ values (160,5655,50,14,36,83.04,9.56,0,11.97,20.96);

insert into world_econ values (161,1465,42,27,31,75.86,20.44,0,28.79,39.81);

insert into world_econ values (162,0,0,0,0,71.12,34.22,0,41.67,59.01);

insert into world_econ values (163,1138,44,22,35,0,0,0,0,0);

insert into world_econ values (164,257,46,24,30,97.63,7.52,0,13.03,34.56);

insert into world_econ values (165,384,28,15,58,0,19.18,20.4,53.44,72.28);

insert into world_econ values (166,1469,33,12,55,0,0,0,0,0);

insert into world_econ values (167,3686,24,31,45,80.87,8.47,0,20.98,25.08);

insert into world_econ values (168,0,0,0,0,95.02,32.27,0,29.64,77.44);

insert into world_econ values (169,5287,57,10,33,80.84,12.27,0,14.72,25.04);

insert into world_econ values (170,1062,56,18,26,95.16,11.95,0,12.45,30.55);

insert into world_econ values (171,2431,46,17,37,78.84,11.03,0,22.27,38.14);

insert into world_econ values (172,2325,34,27,39,0,0,0,0,0);

insert into world_econ values (173,1860,39,18,44,0,0,0,0,0);

insert into world_econ values (174,824,42,27,31,97.66,11.33,19.8,12.7,27.38);

</PRE>

 

3. Electr.txt

 

<PRE>

Drop table world_el;

Create table world_el (HDI_rank number, Radio number, TV number,

       phone_line number, Fax number, Cell_phone number, Internet_users number,

       computers number, constraint HDI_el_pk primary key (HDI_rank),

       constraint hdi_el_fk foreign key (HDI_Rank) references world_pop (HDI_Rank));

insert into world_el values (1,1053,647,589.7,0,87.47,41.2,192.53);

insert into world_el values (2,895,579,558,32.72,23.75,8.6,134.34);

insert into world_el values (3,808,561,556.4,0,224.45,64.1,273);

insert into world_el values (4,2093,776,625.7,0,128.4,38,327.99);

insert into world_el values (5,799,447,554.8,0,115.24,111.9,205.22);

insert into world_el values (6,1008,519,550.1,25.84,199.22,139,182.07);

insert into world_el values (7,937,495,525.2,32.34,33.18,38.8,200.52);

insert into world_el values (8,916,619,488,63.89,81.49,7.2,152.54);

insert into world_el values (9,997,506,478.5,18.09,108.01,50.1,222.69);

insert into world_el values (10,882,476,681.1,0,229.36,51,192.55);

insert into world_el values (11,314,490,385,0,24.63,3.8,81.61);

insert into world_el values (12,790,464,457.5,0,23.21,9.9,138.27);

insert into world_el values (13,620,497,465.5,35.35,47.62,18.6,124.16);

insert into world_el values (14,1433,612,502.5,30.75,97.99,25.6,186.22);

insert into world_el values (15,1304,641,509.7,26.32,127.71,55.4,275.86);

insert into world_el values (16,851,461,613.4,27.98,63.52,35.5,348.01);

insert into world_el values (17,649,382,365.3,0,44.06,11.2,145.01);

insert into world_el values (18,1034,536,612.6,47.61,156.59,38.3,269.28);

insert into world_el values (19,944,550,493.5,0,45.8,18.3,164.9);

insert into world_el values (20,430,442,493.2,0,26.08,7.6,33.44);

insert into world_el values (21,822,436,433.5,0,67.38,5.2,83.72);

insert into world_el values (22,489,303,417.7,24.96,53.49,53.5,99.84);

insert into world_el values (23,309,143,473.9,0,60.65,4.1,40.93);

insert into world_el values (24,900,287,345.3,6.82,17.68,0.1,57.47);

insert into world_el values (25,668,359,532.5,46.28,129.69,48.5,129.95);

insert into world_el values (26,639,593,565,19.61,65.78,15.9,0);

insert into world_el values (27,545,448,458.9,0,29.01,2.3,80.65);

insert into world_el values (28,601,362,478.5,0,102.46,30.1,180.81);

insert into world_el values (29,439,409,0,0,0,22.7,0);

insert into world_el values (30,1024,321,414.7,0,36.59,6.5,108.29);

insert into world_el values (31,348,280,132,0,13.82,7.05,37.83);

insert into world_el values (32,735,233,0,0,0,9.7,0);

insert into world_el values (33,245,333,361.5,0,34.36,9.1,60.48);

insert into world_el values (34,263,220,163.6,0,5.49,4.3,0);

insert into world_el values (35,273,609,239.9,7.04,126.34,2.9,0);

insert into world_el values (36,676,347,159.9,1.45,9.85,1.4,24.57);

insert into world_el values (37,384,374,308.8,7.81,13.56,28.6,47.71);

insert into world_el values (38,609,305,195.6,3.46,12.58,2.5,22.01);

insert into world_el values (39,638,406,236.5,7.12,4.73,21.3,53.21);

insert into world_el values (40,505,318,160.4,1.55,4.3,1.5,19.16);

insert into world_el values (41,634,141,250.7,0,0,5.3,0);

insert into world_el values (42,570,216,208.4,8.33,2.29,5.2,40.99);

insert into world_el values (43,575,439,242.3,10.84,47.48,1.7,50.32);

insert into world_el values (44,612,89,82.6,3.83,2.81,0.1,0);

insert into world_el values (45,228,229,114.2,0,0,0.6,0);

insert into world_el values (46,458,180,110.9,0,18.01,0.5,16.66);

insert into world_el values (47,643,444,185.3,4.41,25.94,10.8,39.16);

insert into world_el values (48,271,263,282.8,10.51,54.25,1.1,48.42);

insert into world_el values (49,263,192,95.8,0,6.99,1.5,26.13);

insert into world_el values (50,668,0,351.2,0,0,0,0);

insert into world_el values (51,598,158,254.9,0,4.4,0,0);

insert into world_el values (52,454,408,148.4,1.42,1.94,6.5,28.49);

insert into world_el values (53,564,188,99.8,2.58,7.07,0.7,16.23);

insert into world_el values (54,473,373,226.1,20.7,69.55,2.1,56.18);

insert into world_el values (55,670,234,164.3,6.64,0,1.3,0);

insert into world_el values (56,548,184,178,0,4.29,0,0);

insert into world_el values (57,438,457,222.7,17.06,33.52,1.8,0);

insert into world_el values (58,765,301,184.2,0,6.02,2.7,0);

insert into world_el values (59,189,227,58.6,0,18.31,0.7,13.64);

insert into world_el values (60,432,231,165.6,0,49.94,2,37.27);

insert into world_el values (61,367,192,131.1,17.7,10.38,0,31.86);

insert into world_el values (62,399,278,74.8,0,7.95,1.2,12.99);

insert into world_el values (63,587,167,134,0,5.73,0,27.78);

insert into world_el values (64,231,138,58.8,0,0,0,0);

insert into world_el values (65,679,195,129.7,1.71,8.95,1.2,0);

insert into world_el values (66,891,268,82.4,0,29.96,0.6,12.48);

insert into world_el values (67,471,359,305.7,1.79,2.5,1.2,21.47);

insert into world_el values (68,285,265,190.4,0.87,0.57,0,0);

insert into world_el values (69,164,240,211.6,1.59,6.99,0.8,12.47);

insert into world_el values (70,291,269,96.2,0,0.9,0.1,0);

insert into world_el values (71,580,61,78.7,0,3.73,0,12.74);

insert into world_el values (72,340,379,169.9,0.21,0.6,1.5,17.66);

insert into world_el values (73,332,148,65.2,0,4.34,0.4,3.92);

insert into world_el values (74,211,201,130.8,0.91,0.4,0.7,5.29);

insert into world_el values (75,136,115,46.1,0,0,0,0);

insert into world_el values (76,266,230,269.4,8.01,7.05,5,20.93);

insert into world_el values (77,491,411,277.4,8.76,20.52,27,6.74);

insert into world_el values (78,228,134,75.7,0,0.39,0,0);

insert into world_el values (79,401,364,253.5,1.03,3.99,0,6.47);

insert into world_el values (80,183,169,164.6,0.84,0,0.4,0);

insert into world_el values (81,264,89,63.4,0.34,0,0,0.07);

insert into world_el values (82,238,71,42.1,0.19,0,0,3.04);

insert into world_el values (83,200,156,58.2,2.79,0.36,0.1,6.7);

insert into world_el values (84,438,306,115.6,0,17.89,0.6,0);

insert into world_el values (85,351,200,32.1,0,0.18,0,0);

insert into world_el values (86,259,100,47.1,0.64,3.13,0.3,5.95);

insert into world_el values (87,251,175,72.9,7.35,2.64,0.2,8.03);

insert into world_el values (88,176,87,72.8,0,4.22,0.2,0);

insert into world_el values (89,316,101,94.5,0,12.9,11.1,26.53);

insert into world_el values (90,206,66,11.1,0,2.89,0,1.09);

insert into world_el values (91,180,144,33.8,0,3.2,0,0);

insert into world_el values (92,678,470,280,0.35,5.96,0,7.95);

insert into world_el values (93,384,275,118,0.18,0.28,0.1,0);

insert into world_el values (94,485,38,0,0,0,0,0);

insert into world_el values (95,118,40,56.7,14.31,0,0,12.26);

insert into world_el values (96,149,147,16.9,0.44,1.12,0.1,3.75);

insert into world_el values (97,131,24,40.8,2.16,0,0,0);

insert into world_el values (98,147,126,20.9,0,7.31,0.3,8.59);

insert into world_el values (99,5,241,154.5,0,0,0.5,0);

insert into world_el values (100,494,42,53,0,1.48,0,0);

insert into world_el values (101,134,59,33.2,0.89,0,0,0);

insert into world_el values (102,856,233,161.2,0,0.27,0.4,5.63);

insert into world_el values (103,81,217,70.9,0,0,0,0);

insert into world_el values (104,81,183,75.8,0,0.16,0,0);

insert into world_el values (105,207,89,11.5,0,0,0.1,0);

insert into world_el values (106,185,247,33.5,0.22,2.99,0,2.14);

insert into world_el values (107,140,29,50.6,0,2.26,0.1,0);

insert into world_el values (108,551,220,103,0,0.03,0,0);

insert into world_el values (109,114,238,76.5,0,0,0,0);

insert into world_el values (110,20,212,84.8,0,0.8,0,0);

insert into world_el values (111,71,122,27.2,0,2.82,0,2.82);

insert into world_el values (112,312,126,46.3,0,0.13,0.3,0);

insert into world_el values (113,699,300,130.7,0.15,0,0,2.14);

insert into world_el values (114,459,241,52.8,0,2.5,0,0);

insert into world_el values (115,163,96,21,0,0,0,0);

insert into world_el values (116,672,202,46.8,0,0.97,0.1,0);

insert into world_el values (117,179,3,54.9,1.28,0,0,0);

insert into world_el values (118,0,258,45.2,0.22,0,0,0);

insert into world_el values (119,409,80,28.7,0,0,0,0);

insert into world_el values (120,181,76,24.2,0.27,3.02,0,4.53);

insert into world_el values (121,271,0,19.1,1.3,0,0,0);

insert into world_el values (122,106,163,10.5,0.2,0.32,0,0.41);

insert into world_el values (123,122,16,17.3,2.1,0.74,0.2,0);

insert into world_el values (124,296,10,24.9,3.25,0.72,0,0);

insert into world_el values (125,226,145,43.3,0,1.1,0.1,1.68);

insert into world_el values (126,280,170,23.4,0,1.07,0.3,0);

insert into world_el values (127,224,74,33,0,0,0,0);

insert into world_el values (128,116,17,8.1,0,0,0,0);

insert into world_el values (129,77,166,10.1,0,0,0,0);

insert into world_el values (130,89,27,14,0,0,0.1,3);

insert into world_el values (131,89,76,3.5,0.03,0.04,0,0);

insert into world_el values (132,152,75,4.5,0,0.21,0,0);

insert into world_el values (133,231,16,3.5,0,0.36,0,1.17);

insert into world_el values (134,37,7,9,0.29,0,0,0);

insert into world_el values (135,425,92,6.3,0.25,0,0,0);

insert into world_el values (136,129,7,4.4,0,0.33,0,0);

insert into world_el values (137,96,18,9,0.14,0.09,0,0.67);

insert into world_el values (138,92,22,16.4,1.23,0.33,0,1.2);

insert into world_el values (139,81,61,12.9,0,0.08,0,1.18);

insert into world_el values (140,112,8,0.5,0.06,1.46,0,0);

insert into world_el values (141,137,5,9,0,0,0,0);

insert into world_el values (142,197,38,3.6,0,0.12,0,0);

insert into world_el values (143,98,41,0.8,0.11,0.23,0,0);

insert into world_el values (144,215,12,5.2,2.42,0,0,0.04);

insert into world_el values (145,92,73,5.2,0.15,0.19,0,0);

insert into world_el values (146,99,64,8.2,0.06,0.16,0.1,0);

insert into world_el values (147,47,7,2.4,0.03,0.02,0,0);

insert into world_el values (148,153,59,8.1,0,0,0,0);

insert into world_el values (149,150,58,4.1,0.13,0,0,0);

insert into world_el values (150,276,16,3,0,0.12,0,0);

insert into world_el values (151,43,267,12.4,0.13,0.55,0,0);

insert into world_el values (152,36,3,3.8,0,0,0,0);

insert into world_el values (153,192,24,2.4,0,0,0,0);

insert into world_el values (154,75,5,2.3,0.05,0.02,0,0);

insert into world_el values (155,17,0,9,0,0,0,0);

insert into world_el values (156,34,51,5.6,0,0.19,0,0);

insert into world_el values (157,270,86,2.7,0.21,0,0,0);

insert into world_el values (158,120,37,9.8,0,0.01,0,7.19);

insert into world_el values (159,53,5,8.4,0,0,0,0);

insert into world_el values (160,117,26,2.3,0.13,0.09,0,0.53);

insert into world_el values (161,256,0,3.5,0.11,0.04,0,0);

insert into world_el values (162,80,73,13.1,0.16,0,0.2,0);

insert into world_el values (163,248,2,0.8,0.03,0,0,0);

insert into world_el values (164,42,0,8.8,0.47,0,0,0);

insert into world_el values (165,164,0,17.3,0.93,1.3,0,0);

insert into world_el values (166,38,3,3.4,0,0,0,0);

insert into world_el values (167,44,76,1.6,0.02,0.14,0,0.15);

insert into world_el values (168,98,6,4.8,0.22,0,0,0);

insert into world_el values (169,193,4,2.5,0.03,0,0,0);

insert into world_el values (170,68,7,2.7,0,0,0,0);

insert into world_el values (171,46,12,1.7,0,0,0,0);

insert into world_el values (172,28,6,2.9,0,0,0,0.01);

insert into world_el values (173,68,23,1.5,0.04,0,0,0);

insert into world_el values (174,250,16,3.7,0.22,0,0,0);

</PRE>