Create database empresa

Create database empresa;

use empresa;

CREATE TABLE

REGION(

REG_ID int,

REG_NOM varchar(100),

PRIMARY KEY(REG_ID)

);

CREATE TABLE

PROVINCIA(

PRO_ID int,

PRO_NOM varchar(100),

PRO_REG_ID int,

PRIMARY KEY(PRO_ID)

);

CREATE TABLE

COMUNA(

COM_ID int,

COM_NOM varchar(100),

COM_PRO_ID int,

PRIMARY KEY(COM_ID)

);

Script poblamiento de tablas:

INSERT INTO REGION VALUES

(1000,'Region de Tarapaca'),

(2000,'Region de Antofagasta'),

(3000,'Region de Atacama'),

(4000,'Region de Coquimbo'),

(5000,'Region de Valparaiso'),

(6000,'Region del libertador General Bernardo O´higgins'),

(7000,'Region del Maule'),

(8000,'Region del Bio-Bio'),

(9000,'Region de la Araucania'),

(10000,'Region de los Lagos'),

(11000,'Region de Aysen del General Carlos Ibañez del Campo'),

(12000,'Region de Magallanes y la Antartica Chilena'),

(13000,'Region Metropolitana de Santiago'),

(14000,'Region de los Rios'),

(15000,'Region de Arica y Parinacota');

INSERT INTO PROVINCIA VALUES

(1100,'Iquique',1000),

(2100,'Antofagasta',2000),

(2200,'El Loa',2000),

(2300,'Tocopilla',2000),

(3100,'Copiapó',3000),

(3200,'Chañaral',3000),

(3300,'Huasco',3000),

(4100,'Elqui',4000),

(4200,'Choapa',4000),

(4300,'Limarí',4000),

(5100,'Valparaíso',5000),

(5200,'Isla de Pascua',5000),

(5300,'Los Andes',5000),

(5400,'Petorca',5000),

(5500,'Quillota',5000),

(5600,'San Antonio',5000),

(5700,'San Felipe de Aconcagua',5000),

(6100,'Cachapoal',6000),

(6200,'Cardenal Caro',6000),

(6300,'Colchagua',6000),

(7100,'Talca',7000),

(7200,'Cauquenes',7000),

(7300,'Curicó',7000),

(7400,'Linares',7000),

(8100,'Concepción',8000),

(8200,'Arauco',8000),

(8300,'Biobío',8000),

(8400,'Ñuble',8000),

(9100,'Cautín',9000),

(9200,'Malleco',9000),

(10100,'Llanquihue',10000),

(10200,'Chiloé',10000),

(10300,'Osorno',10000),

(10400,'Palena',10000),

(11100,'Coihaique',11000),

(11200,'Aisén',11000),

(11300,'Capitán Prat',11000),

(11400,'General Carrera',11000),

(12100,'Magallanes',12000),

(12200,'Antártica Chilena',12000),

(12300,'Tierra del Fuego',12000),

(12400,'Última Esperanza',12000),

(13100,'Santiago',13000),

(13200,'Cordillera',13000),

(13300,'Chacabuco',13000),

(13400,'Maipo',13000),

(13500,'Melipilla',13000),

(13600,'Talagante',13000),

(14100,'Valdivia',14000),

(14200,'Ranco',14000),

(15100,'Arica',15000),

(15200,'Parinacota',15000);

INSERT INTO COMUNA VALUES

(1101,'Iquique',1100),

(1102,'Camiña',1100),

(1103,'Colchane',1100),

(1104,'Huara',1100),

(1105,'Pica',1100),

(1106,'Pozo Almonte',1100),

(2101,'Antofagasta',2100),

(2102,'Mejillones',2100),

...