Arboles

CREATE TABLE EMPLEADO(
CODEM VARCHAR(4) NOT NULL PRIMARY KEY,
NOMBRE VARCHAR(30) NOT NULL,
CI INT NOT NULL,
DIRECCION VARCHAR(30) NOT NULL,
CARGO VARCHAR(30) NOT NULL,
)

CREATE TABLE TEL_EMPL(
CODET INT NOT NULL PRIMARY KEY,
CODEM VARCHAR(4) NOT NULL,
TELEFONO INT,
FOREIGN KEY(CODEM) REFERENCES EMPLEADO(CODEM)
ON DELETE CASCADE
ON UPDATE CASCADE
)

CREATETABLE CONDUCTOR(
CODCOND VARCHAR(4) NOT NULL PRIMARY KEY,
NOMBRE VARCHAR(30) NOT NULL,
CI INT NOT NULL,
DIRECCION VARCHAR(30)
)

CREATE TABLE TEL_COND(
CODCT INT NOT NULL PRIMARY KEY,
CODCOND VARCHAR(4) NOT NULL,
TELEFONO INT,
FOREIGN KEY(CODCOND) REFERENCES CONDUCTOR(CODCOND)
ON DELETE CASCADE
ON UPDATE CASCADE
)

CREATE TABLE CLIENTE(
CODCL VARCHAR(4) NOT NULLPRIMARY KEY,
CiNIT INT NOT NULL,
NOMBRE VARCHAR(30) NOT NULL,
DIRECCION VARCHAR(30) NOT NULL,
EMAIL VARCHAR(30),
)

CREATE TABLE TEL_CLIENTE(
CODCT INT NOT NULL PRIMARY KEY,
CODCL VARCHAR(4) NOT NULL,
TELEFONO INT,
FOREIGN KEY(CODCL) REFERENCES CLIENTE(CODCL)
ON DELETE CASCADE
ON UPDATE CASCADE
)

CREATE TABLE PROVEEDOR(
CODPROV VARCHAR(4) NOT NULL PRIMARY KEY,CiNIT INT NOT NULL,
NOMBRE VARCHAR(30) NOT NULL,
DIRECCION VARCHAR(30) NOT NULL,
EMAIL VARCHAR(30),
)

CREATE TABLE TEL_PROV(
CODPT INT NOT NULL PRIMARY KEY,
CODPROV VARCHAR(4) NOT NULL,
TELEFONO INT,
FOREIGN KEY(CODPROV) REFERENCES PROVEEDOR(CODPROV)
ON DELETE CASCADE
ON UPDATE CASCADE
)

CREATE TABLE UNIDAD_DE_MEDIDA(
CODU VARCHAR(4) NOT NULL PRIMARY KEY,DESCRIPCION VARCHAR(30) NOT NULL,
ABREVIATURA VARCHAR(10) NOT NULL
)

CREATE TABLE MONEDA(
CODM VARCHAR(4) NOT NULL PRIMARY KEY,
DESCRIPCION VARCHAR(10) NOT NULL,
ABREVIATURA VARCHAR(10) NOT NULL,
TC VARCHAR(2) NOT NULL
)

CREATE TABLE PRODUCTO(
CODPRO VARCHAR(4) NOT NULL,
NOMBRE VARCHAR(15) NOT NULL,
PRECIOC MONEY NOT NULL,
PRECIOV MONEY NOT NULL,
CODM INT NOT NULL,CODU INT NOT NULL,
PRIMARY KEY (CODPRO),
FOREIGN KEY(CODM) REFERENCES MONEDA(CODM)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY(COD) REFERENCES UNIDAD_DE_MEDIDA(CODU)
ON DELETE CASCADE
ON UPDATE CASCADE
)

CREATE TABLE RECIBO(
CODREC VARCHAR(4) NOT NULL PRIMARY KEY,
TIPO VARCHAR(20) NOT NULL
)

CREATE TABLE CONTROL_ALMACEN(
CODIN VARCHAR(4) NOT NULL PRIMARY KEY,FECHA DATE NOT NULL,
HORA TIME NOT NULL,
CODNR VARCHAR(4) NOT NULL,
CODNE VARCHAR(4) NOT NULL,
CODAL VARCHAR(4) NOT NULL,
FOREIGN KEY(CODNR) REFERENCES NOTARECEPCION(CODNR)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY(CODNE) REFERENCES NOTAENTREGA(CODNE)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY(CODAL) REFERENCES ALMACEN(CODAL)
ONDELETE CASCADE
ON UPDATE CASCADE
)

CREATE TABLE BOLETA_PESAJE(
CODBO INT NOT NULL PRIMARY KEY,
HORAENTRADA DATE NOT NULL,
HORASALIDA DATE NOT NULL,
PESOTARA INT NOT NULL,
PESOBRUTO INT NOT NULL,
PESONETO INT NOT NULL,
FECHA DATE,
CODPRO VARCHAR(4)NOT NULL,
FOREIGN KEY(CODPRO) REFERENCES PRODUCTO(CODPRO)
ON DELETE CASCADE
ON UPDATE CASCADE
)

CREATE TABLECAMION(
PLACA VARCHAR(7) NOT NULL,
COLOR VARCHAR(10) NOT NULL,
MODELO VARCHAR(10) NOT NULL,
CODCOND VARCHAR(4), NOT NULL
PRIMARY KEY (PLACA),
FOREIGN KEY(CODCOND) REFERENCES CONDUCTOR(CODCOND)
ON DELETE CASCADE
ON UPDATE CASCADE,
)

CREATE TABLE FLETE(
CODFL VARCHAR(4) NOT NULL PRIMARY KEY,
PRECIO MONEY NOT NULL
)

CREATE TABLE FLETECAMION(
CODFL INT NOT NULL,
PLACAVARCHAR(7) NOT NULL,
PRIMARY KEY(CODFL,PLACA),
FOREIGN KEY(CODFL) REFERENCES FLETE(CODFL)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY(PLACA) REFERENCES CAMION(PLACA)
ON DELETE CASCADE
ON UPDATE CASCADE,
)


CREATE TABLE ALMACEN(
CODAL VARCHAR(4) NOT NULL PRIMARY KEY,
DESCRIPCION VARCHAR(30) NOT NULL,
CODIN VARCHAR(4) NOT NULL,
FOREIGN KEY(CODIN) REFERENCES...