CREATE DATABASE campusland;

USE campusland;

CREATE TABLE pais(
  idPais INT(11) PRIMARY KEY AUTO_INCREMENT,
  nombrePais VARCHAR(50)
);

CREATE TABLE departamento(
  idDep INT(11) PRIMARY KEY AUTO_INCREMENT,
  nombreDep VARCHAR(50) NULL,
  idPais INT(11)
);

CREATE TABLE campers(
 idCamper VARCHAR(20) PRIMARY KEY NOT NULL,
 nombreCamper VARCHAR(50) NOT NULL,
 apellidoCamper VARCHAR(50) NOT NULL,
 fechaNac date NOT NULL,
 idReg INT(11)
);

CREATE TABLE region(
 idReg INT(11)  PRIMARY KEY AUTO_INCREMENT,
 nombreReg VARCHAR(60),
 idDep INT(11) 
);

ALTER TABLE departamento
ADD CONSTRAINT FK_departamento
FOREIGN KEY (idPais) REFERENCES pais(idPais);


ALTER TABLE region
ADD CONSTRAINT FK_region
FOREIGN KEY (idDep) REFERENCES departamento(idDep);


ALTER TABLE campers
ADD CONSTRAINT campers
FOREIGN KEY (idReg) REFERENCES region(idReg);