[Snayder187]

Esta es mi base de datos ya terminada...

Código SQL [-]
CREATE DATABASE EVENTOS
GO

USE EVENTOS
GO


create TABLE CATEGORIA
(
  idcategoria int identity(1,1) primary key,
  nom_categoria varchar(100) not null
)

create TABLE TIPO_ITEM
(
  idtipoitem int identity(1,1) primary key,
  idcategoria int foreign key references CATEGORIA(idcategoria),
  nom_tipoitem varchar(100) not null
)

create TABLE ITEM
(
  iditem int identity(1,1) primary key,
  idtipoitem int foreign key references TIPO_ITEM(idtipoitem),
  des_item varchar(100) not null,    
  con_item varchar(20) not null,    
  sto_item int not null        
)

create TABLE DETALLE_ITEM
(
  iddetalleitem int identity(1,1) primary key,
  idtipoitem int foreign key references TIPO_ITEM(idtipoitem),
  med_detalleitem varchar(50) not null,    
  cap_detalleitem int not null,        
  dir_detalleitem varchar(100) not null
)

create TABLE PROVEEDOR
(
  idproveedor int identity(1,1) primary key,
  ruc_proveedor char(11) not null,
  rzo_proveedor varchar(100) not null,
  con_proovedor varchar(100) not null,
  cel_proovedor varchar(12) not null,
  dir_proovedor varchar(100) not null,
  tel_proovedor varchar(11) null,
  ema_proovedor varchar(80) null,
  est_proovedor varchar(1) not null
)

create TABLE PERSONAL
(
  idpersonal int identity(1,1) primary key,
  nom_personal varchar(80) not null,
  ape_personal varchar(100) not null,
  dni_personal varchar(8) not null,
  fna_personal date not null,
  dir_personal varchar(100) not null,
  tel_personal varchar(11) null,
  cel_personal varchar(13) not null,
  esc_personal varchar(25) not null,
  ema_personal varchar(100) not null,
  car_personal varchar(30) not null,
  est_personal varchar(1) not null
)

create TABLE PRECIOS
(
  idprecio int identity(1,1) primary key,
  iditem int foreign key references ITEM(iditem),
  idproveedor int foreign key references PROVEEDOR(idproveedor),
  fec_precios date not null,
  pco_precios double(6,2) not null,    
  pve_precios double(6,2) not null,    
  uti_precios double(6,2) not null     
)

create TABLE COTIZACION
(
  idcotizacion int identity(1,1) primary key,
  sol_cotizacion varchar(150) not null,
  tel_cotizacion varchar(13) not null,
  des_cotizacion varchar(100) not null,
  inv_cotizacion varchar(8) not null,
  fec_cotizacion date not null,
  idproveedor int foreign key references PROVEEDOR(idproveedor)
)

create TABLE EVENTO
(
  idevento int identity(1,1) primary key,
  idcotizacion int foreign key references COTIZACION(idcotizacion),
  hin_evento date not null,      
  hfi_evento date not null,      
  est_evento varchar(15) not null,
  dir_evento varchar(150) not null,
  idpersonal int foreign key references PERSONAL(idpersonal),
  tev_evento varchar(70) not null,    
  fec_evento date not null
)

create TABLE MENAJE
(
idmaneja int identity(1,1) primary key,
idcotizacion int foreign key references COTIZACION(idcotizacion),
iditem int foreign key references ITEM(iditem)
)

create TABLE CLIENTE
(
  idcliente int identity(1,1) primary key,
  tip_cliente char(1) not null,      
  tdo_cliente varchar(20) not null,    
  ndo_cliente varchar(11) not null,    
  nom_cliente varchar(150) not null,
  dir_cliente varchar(150) not null,    
  tel_cliente varchar(13) not null,    
  ema_cliente varchar(100) null      
)
  
create TABLE CONTRATO
(
  idcontrato int identity(1,1) primary key,
  idcliente int foreign key references CLIENTE(idcliente),
  fec_contrato date not null,
  est_contrato varchar(50) not null,    
  idevento int foreign key references EVENTO(idevento),
  cuo_contrato int not null,    
  imp_contrato double not null,      
  ima_contrato image not null      
)

create TABLE COMPRA
(
  idcompra int identity(1,1) primary key,
  idproovedor int foreign key references PROVEEDOR(idproveedor),
  iditem int foreign key references ITEM(iditem),
  ser_compra varchar(6) not null,    
  nco_compra varchar(8) not null
)  

create TABLE ALQUILER
(
idalquiler int identity(1,1) primary key,
idproovedor int foreign key references PROVEEDOR(idproveedor),
iditem int foreign key references ITEM(iditem),
idcontrato int foreign key references CONTRATO(idcontrato)
)