Proyecto Sobre Programacion De Mantenimientos De It

Universidad Don Bosco
Facultad de ingenieria
Escuela de Computacion

“Avance de proyecto de catedra: Desarrollo de sistema PMC para programacion de mantenimientos a equipos en el departamento de soporte IT de La UDB”

Catedratico: Lic. Mauricio Flores Aviles.
Integrantes:
Luis Rafael Henriquez Serrano.
Xavier Ernesto Vazquez Zelada.

San salvador, 3 de agosto de 2012.

Diagrama deentidad de relacion

Scrips de la BD

USE [PMC]
GO
/****** Object: Table [dbo].[Tipo_Mantenimiento] Script Date: 08/03/2012 22:53:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tipo_Mantenimiento](
[Id_Tipo] [numeric](18, 0) NOT NULL,
[Nombre] [nvarchar](200) NULL,
[Descripcion] [nvarchar](500) NULL,
CONSTRAINT [PK_Tipo_Mantenimiento] PRIMARYKEY CLUSTERED
(
[Id_Tipo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Tipo_Equipos] Script Date: 08/03/2012 22:53:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tipo_Equipos](
[Id_Tipo_Equipo][numeric](18, 0) NOT NULL,
[Nombre_Tipo] [nvarchar](200) NULL,
[Especificacion_Tecnica] [nvarchar](500) NULL,
CONSTRAINT [PK_Tipo_Equipos] PRIMARY KEY CLUSTERED
(
[Id_Tipo_Equipo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Fabricantes] ScriptDate: 08/03/2012 22:53:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Fabricantes](
[Id_Fabricante] [numeric](18, 0) NOT NULL,
[Nombre] [nvarchar](200) NULL,
[Descripcion] [nvarchar](200) NULL,
[Pais] [nvarchar](50) NULL,
CONSTRAINT [PK_Fabricantes] PRIMARY KEY CLUSTERED
(
[Id_Fabricante] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Departamentos] Script Date: 08/03/2012 22:53:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Departamentos](
[Id_Departamento] [numeric](18, 0) NOT NULL,
[Nombre_Departamento] [nvarchar](100) NULL,
[Descripcion][nvarchar](500) NULL,
CONSTRAINT [PK_Departamentos] PRIMARY KEY CLUSTERED
(
[Id_Departamento] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Usuarios] Script Date: 08/03/2012 22:53:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATETABLE [dbo].[Usuarios](
[Id_User] [numeric](18, 0) NOT NULL,
[Nombres] [nvarchar](100) NULL,
[Apellidos] [nvarchar](100) NULL,
[Id_Departamento] [numeric](18, 0) NULL,
[Cargo] [nvarchar](50) NULL,
[Password] [nvarchar](10) NULL,
[Pregunta_Secreta] [nvarchar](100) NULL,
[Resp_Secreta] [nvarchar](200) NULL,
CONSTRAINT [PK_Usuarios] PRIMARY KEY CLUSTERED
(
[Id_User] ASC
)WITH(PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Catalogo_Mantenimientos] Script Date: 08/03/2012 22:53:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Catalogo_Mantenimientos](
[Id_Cat_Tipo_Mant] [numeric](18, 0) NOT NULL,[Id_Tipo] [numeric](18, 0) NULL,
[Nombre] [nvarchar](200) NULL,
[Descripcion] [nvarchar](500) NULL,
CONSTRAINT [PK_Catalogo_Mantenimientos] PRIMARY KEY CLUSTERED
(
[Id_Cat_Tipo_Mant] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Edificios]...