ConsultasSql



---------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------CREACION DE TABLAS----------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------

------------TABLATAXONOMIA-------------------

CREATE TABLE taxonomia
(
taxo_id INT NOT NULL PRIMARY KEY,
taxo_nomCientifico CHAR(30) NOT NULL,
taxo_familia CHAR(30) NOT NULL,
taxo_filo CHAR(30) NOT NULL,
taxo_clase CHAR(30) NOT NULL
);
----------------------------------------------
------------TABLA ARMADILLO-------------------

CREATE TABLE armadillo
(
arma_id INT NOT NULL PRIMARY KEY,arma_nombre CHAR(20) NOT NULL,
arma_peso CHAR(6) NOT NULL,
arma_sexo CHAR(1) NOT NULL

);
---------------------------------------------
------------TABLA ESPECIE--------------------

CREATE TABLE especie
(
espe_id INT NOT NULL PRIMARY KEY,
espe_especie CHAR(40) NOT NULL,
espe_imagen TEXT NULL,
taxo_id INT NOT NULL,
FOREIGN KEY(taxo_id)
REFERENCES taxonomia(taxo_id)
);---------------------------------------------
------------TABLA MADRIGERA------------------

CREATE TABLE madrigera
(
madr_id INT NOT NULL PRIMARY KEY,
madr_sector CHAR(40) NOT NULL,
madr_cant INT NOT NULL,
espe_id INT NOT NULL,
FOREIGN KEY (espe_id)
REFERENCES especie(espe_id)
);
-------------------------------------------
------------TABLA CAMADA-------------------

CREATE TABLEcamada
(
cama_id INT NOT NULL PRIMARY KEY,
cama_cantCrias INT NOT NULL ,
madr_id INT NOT NULL,
FOREIGN KEY(madr_id)
REFERENCES madrigera(madr_id)

);
-------------------------------------------
------------TABLA CARGO--------------------

CREATE TABLE cargo(
carg_id INT NOT NULL PRIMARY KEY,
carg_cargo CHAR(20) NOT NULL,
carg_sueldo DECIMAL NOT NULL
);-------------------------------------------
------------TABLA EMPLEADO-----------------

CREATE TABLE empleado
(
empe_id INT NOT NULL PRIMARY KEY,
empe_nombre CHAR(20) NOT NULL,
empe_apellido CHAR(20) NOT NULL,
empe_fechaNacimiento DATE NOT NULL,
empe_sexo CHAR(1) NOT NULL,
empe_no_Cc BIGINT NOT NULL,
carg_id INT NOT NULL,
FOREIGN KEY (carg_id)
REFERENCES cargo(carg_id)

);-------------------------------------------
------------TABLA ubicación_emp-----------------
CREATE TABLE ubicaciOn_emp
(
empe_id INT NOT NULL ,
ubic_ciudad CHAR(20) NOT NULL,
ubic_direccion varchar(20) NOT NULL,
ubic_telefono BIGINT NOT NULL,
FOREIGN KEY(empe_id)
REFERENCES empleado(empe_id)
);

-------------------------------------------
------------TABLA LIMPIEZA-----------------

CREATETABLE limpieza
(
limp_id INT NOT NULL PRIMARY KEY,
limp_descripcion TEXT NOT NULL,
madr_id INT NOT NULL,
empe_id INT NOT NULL,
FOREIGN KEY(empe_id)
REFERENCES empleado(empe_id),
FOREIGN KEY(madr_id)
REFERENCES madrigera(madr_id)
);
-------------------------------------------
-------------TABLA CRIADERO----------------

CREATE TABLE criadero(
cria_id INT NOT NULL PRIMARY KEY,cria_nombre CHAR(20) NOT NULL,
cria_ciudad CHAR(15) NOT NULL,
cria_telefono BIGINT NOT NULL

);
----------------------------------------------
------------TABLA INGRESOS--------------------


CREATE TABLE ingreso
(
ing_id INT NOT NULL PRIMARY KEY,
ing_procedencia CHAR(20) NOT NULL,
ing_fechaIngreso DATE NOT NULL,
cria_id INT NOT NULL,
FOREIGN KEY (cria_id)
REFERENCEScriadero(cria_id)

);

----------------------------------------------
------------TABLA REVICION--------------------

CREATE TABLE revicion
(
revi_id INT NOT NULL PRIMARY KEY,
revi_descripcion TEXT NOT NULL,
arma_id INT NOT NULL,
empe_id INT NOT NULL,
ingr_id INT NOT NULL

);

---------------------------------------------
------------TABLA ENFERMEDAD-----------------...