Scrip
/*CREAR UNA BASE DE DATOS:*/
Create database Norkys_Excel
Go
Use Norkys_Excel
/*--------------------------CREAR TABLA PLANILLA
------------------------------*/
CREATE TABLE PLANILLA
(
COD_PLANILLA NVARCHAR (10) PRIMARY KEY NOT NULL,
COD_EMP NVARCHAR (10) FOREIGN KEY REFERENCES EMPLEADO(COD_EMP) NOT
NULL,
SUELDO NVARCHAR (10) NOT NULL,
COMISION NVARCHAR (10) NOT NULL,
DCTO NVARCHAR (10) NOT NULL,
TOTAL NVARCHAR (10) NOT NULL,
FECHA NVARCHAR (10) NOT NULL
);
GO
/*------------------------------CREAR TABLA EMPLEADO
------------------------*/
CREATE TABLE EMPLEADO
(
COD_EMP NVARCHAR (10) PRIMARY KEY NOT NULL,
NOMBRE NVARCHAR (8) NOT NULL,
APELLIDOS NVARCHAR (15) NOT NULL,
SEXO NVARCHAR (10) NOT NULL,
EDAD NVARCHAR (3) NOT NULL,
DNI NVARCHAR (8) NOT NULL,
DIRECCION NVARCHAR (20) NOT NULL,
TELEF NVARCHAR (12) NOT NULL,
CORREO NVARCHAR (30) NOT NULL,
);
GO
/*----------------------------CREAR TABLA REPARTO
-------------------------*/
CREATE TABLE REPARTO
(
COD_R NVARCHAR (10) PRIMARY KEY NOT NULL,
COD_EMP NVARCHAR (10) FOREIGN KEY REFERENCES EMPLEADO (COD_EMP) NOT
NULL
);
GO
/*------------------------CREAR TABLA EMPAQUE
---------------------------------*/
CREATE TABLE EMPAQUE
(
COD_E NVARCHAR (10) PRIMARY KEY NOT NULL,
COD_EMP NVARCHAR (10) FOREIGN KEY REFERENCES EMPLEADO (COD_EMP) NOT
NULL
);
GO
/*-------------------------------CREAR TABLA COCINA --------------------*/
CREATE TABLE COCINA
