jueves, 18 de octubre de 2012
Metricas del Software Hogar de Fe
---------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------
Pseudocodigo
use Hogar_de_Fe
create table Huerfano--------
(
[id_Huerfano] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Tutor] int foreign key references Tutor(id_Tutor) not null,
[id_FormularioAdmision] int
foreign key references FormularioAdmision(id_formularioAdmision) not null,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[edad] [int]
not NULl
)
GO
--------------------------------------------------------------------------
create table Tutor-----
(
[id_Tutor] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[direccion] [nvarchar](100) not NULl,
[NumTelefono] [nvarchar](10) not NULl,
[cedula] [nvarchar](45) not NULl,
[relacion] [nvarchar](100) not NULl,
)
GO
---------------------------------------------------------------------------
create table Administrador
(
[id_Administrador] [int]
IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Areas] int foreign key references Areas(id_Areas) not null,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[direccion] [nvarchar](100) not NULl,
[NumTelefono] [nvarchar](10) not NULl,
[especificacion] [nvarchar](100) not NULl,
)
GO
--------------------------------------------------------------------------
create table JuntaDirectiva
(
[id_Junta] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Areas] int foreign key references Areas(id_Areas) not null,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[direccion]
[nvarchar](100) not NULl,
[NumTelefono]
[nvarchar](10) not NULl,
[cargo] [nvarchar](50) not NULl,
)
GO
--------------------------------------------------------------------------
create
table Nutricionista
(
[id_Nutricionista]
[int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Areas] int foreign key references Areas(id_Areas) not null,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[direccion]
[nvarchar](100) not NULl,
[NumTelefono]
[nvarchar](10) not NULl,
[tipoNutricionista]
[nvarchar](50) not NULl,
[planAlimentacon]
[nvarchar](300) not NULl,
)
GO
--------------------------------------------------------------------------
create
table Medico
(
[id_Medico] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Areas] int foreign key references Areas(id_Areas) not null,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[direccion] [nvarchar](100) not NULl,
[NumTelefono] [nvarchar](10) not NULl,
[Especialidad] [nvarchar](50) not NULl,
)
GO
--------------------------------------------------------------------------
create table EducadorSocial
(
[id_Educador] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Areas] int foreign key references Areas(id_Areas) not null,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[direccion] [nvarchar](100) not NULl,
[NumTelefono] [nvarchar](10) not NULl,
[NumNiños] [int] not NULl,
)
GO
---------------------------------------------------------------------------
create table Maestro------------
(
[id_Maestro] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Areas] int foreign key references Areas(id_Areas) not null,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[direccion] [nvarchar](100) not NULl,
[NumTelefono] [nvarchar](10) not NULl,
)
GO
---------------------------------------------------------------------------
create table Psicologo
(
[id_Psicologo] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Areas] int foreign key references Areas(id_Areas) not null,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[direccion] [nvarchar](100) not NULl,
[NumTelefono] [nvarchar](10) not NULl,
[tipoPsicologia] [nvarchar](50) not NULl,
)
GO
----------------------------------------------------------------------------
create table Alumnos----
(
[id_Alumno] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Huerfano] int foreign key references Huerfano(id_Huerfano) not null,
[AñoEstudio] [int] not NULl,
)
GO
----------------------------------------------------------------------------
create table Notas----
(
[id_Notas] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Huerfano] int foreign key references Huerfano(id_Huerfano) not null,
[id_Alumno] int foreign key references Alumnos(id_Alumno) not null,
[Nota1] [int] not NULl,
[Nota2] [int] not NULl,
[Nota3] [int] not NULl,
[Nota4] [int]not NULl,
[Nota5] [int] not NULl,
[Nota6] [int] not NULl,
[Nota7] [int] not NULl,
)
GO
-----------------------------------------------------------------------------
create table Asignaturas-----
(
[id_Asignaturas] [int]
IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Maestro] int foreign key references Maestro(id_Maestro) not null,
[id_Alumno] int foreign key references Alumnos(id_Alumno) not null,
[Nombre] [nvarchar](40) not NULL,
)
GO
-----------------------------------------------------------------------------
create table FormularioAdmision----
(
[id_FormularioAdmision] [int]
IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Tutor] int foreign key references Tutor(id_Tutor) not null,
[PrimerNombrePa] [nvarchar](30) not NULL,
[SegundoNombrePa]
[nvarchar](30) not NULL,
[PrimerApellidoPa]
[nvarchar](30) not NULL,
[SegundoApellidoPa]
[nvarchar](30) not NULL,
[PrimerNombreMa]
[nvarchar](30) not NULL,
[SegundoNombreMa]
[nvarchar](30) not NULL,
[PrimerApellidoMa]
[nvarchar](30) not NULL,
[SegundoApellidoMa]
[nvarchar](30) not NULL,
)
GO
-----------------------------------------------------------------------------
create table GrupoAtencion
(
[id_Grupo] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Areas] int foreign key references Areas(id_Areas) not null,
[TipoGrupo] [nvarchar](50) not NULL,
[NombreGrupo]
[nvarchar](70) not NULL,
[NumIntegrantes] [int] not NULL,
)
GO
-----------------------------------------------------------------------------
create table Areas
(
[id_Areas] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[NombreArea] [nvarchar](70) not NULL,
[NumPersonal] [int] not NULL,
[Funcion] [nvarchar](50) not NULL,
)
GO
-----------------------------------------------------------------------------
create table RequisitosAdmision--------
(
[id_Requisitos] [int]
IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Tutor] int foreign key references Tutor(id_Tutor) not null,
[id_FormularioAdmision] int
foreign key references FormularioAdmision(id_FormularioAdmision) not null,
[TipoGrupo] [nvarchar](50) not NULL,
[NombreGrupo]
[nvarchar](70) not NULL,
[NumIntegrantes] [int] not NULL,
)
GO
-----------------------------------------------------------------------------
create table RegistroConsultas--------
(
[id_Registros] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Medico] int foreign key references Medico(id_Medico) not null,
[id_Areas] int foreign key references Areas(id_Areas) not null,
[Hora] [nvarchar](30) not NULL,
[Fecha] [nvarchar](30) not NULL,
)
GO
-----------------------------------------------------------------------------
create table Curso-----
(
[id_Curso] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[id_Alumno] int foreign key references Alumnos(id_Alumno) not null,
[id_Maestro] int foreign key references Maestro(id_Maestro) not null,
[Modalidad] [nvarchar](50) not NULL,
[Semestre] [nvarchar](70) not NULL,
[Nivel] [int] not NULL,
)
GO
-----------------------------------------------------------------------------
create table Donantes
(
[id_Donantes] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[PrimerNombre] [nvarchar](30) not NULL,
[SegundoNombre]
[nvarchar](30) not NULL,
[PrimerApellido]
[nvarchar](30) not NULL,
[SegundoApellido]
[nvarchar](30) not NULL,
[direccion]
[nvarchar](100) not NULl,
[NumTelefono]
[nvarchar](10) not NULl,
[NombreInstitucion]
[nvarchar](50) not NULl,
[TipoDonacion]
[nvarchar](100) not NULl,
)
GO
-----------------------------------------------------------------------------
/*Procedimiento para registrar*/
create
procedure Registrar1
@idT
int,
@idF
int,
@pnombre
nvarchar(30),
@snombre
nvarchar(30),
@papellido
nvarchar(30),
@sapellido
nvarchar(30),
@edad int
as begin
insert into Huerfano values(@idT,@idF,@pnombre,@snombre,@papellido,
@sapellido,@edad)
end
go
select * from Huerfano
-------------------------------------------------------------------------------
create procedure Registrar2
@pnombre nvarchar(30),
@snombre
nvarchar(30),
@papellido
nvarchar(30),
@sapellido
nvarchar(30),
@direccion
nvarchar(100),
@NumT
nvarchar(10),
@cedula
nvarchar(30),
@relacion nvarchar(100)
as begin
insert into Tutor values(@pnombre,@snombre,@papellido,
@sapellido,@direccion,@NumT,@cedula,@relacion)
end
go
select * from Tutor
--------------------------------------------------------------------------------
create procedure Registrar3
@idA int,
@pnombre
nvarchar(30),
@snombre
nvarchar(30),
@papellido
nvarchar(30),
@sapellido
nvarchar(30),
@direccion
nvarchar(100),
@NumT
nvarchar(10),
@especificacion nvarchar(30)
as begin
insert into Administrador values(@idA,@pnombre,@snombre,@papellido,
@sapellido,@direccion,@NumT,@especificacion)
end
go
select * from Administrador
--------------------------------------------------------------------------------
create procedure Registrar4
@idA
int,
@pnombre
nvarchar(30),
@snombre
nvarchar(30),
@papellido
nvarchar(30),
@sapellido
nvarchar(30),
@direccion
nvarchar(100),
@NumT nvarchar(10),
@cargo nvarchar(50)
as begin
insert into JuntaDirectiva values(@idA,@pnombre,@snombre,@papellido,
@sapellido,@direccion,@NumT,@cargo)
end
go
select * from JuntaDirectiva
--------------------------------------------------------------------------------
create procedure Registrar5
@idA int,
@pnombre
nvarchar(30),
@snombre
nvarchar(30),
@papellido
nvarchar(30),
@sapellido
nvarchar(30),
@direccion
nvarchar(100),
@NumT
nvarchar(10),
@TipoN nvarchar(50),
@PlanA nvarchar(300)
as begin
insert into Nutricionista values(@idA,@pnombre,@snombre,@papellido,
@sapellido,@direccion,@NumT,@TipoN,@PlanA)
end
go
select * from Nutricionista
--------------------------------------------------------------------------------
create procedure Registrar6
@idA
int,
@pnombre
nvarchar(30),
@snombre
nvarchar(30),
@papellido
nvarchar(30),
@sapellido
nvarchar(30),
@direccion
nvarchar(100),
@NumT nvarchar(10),
@Especialidad nvarchar(50)
as begin
insert into Medico values(@idA,@pnombre,@snombre,@papellido,
@sapellido,@direccion,@NumT,@Especialidad)
end
go
select * from Medico
--------------------------------------------------------------------------------
create procedure Registrar7
@idA
int,
@pnombre
nvarchar(30),
@snombre
nvarchar(30),
@papellido
nvarchar(30),
@sapellido
nvarchar(30),
@direccion
nvarchar(100),
@NumT nvarchar(10),
@NumNiños int
as begin
insert into EducadorSocial values(@idA,@pnombre,@snombre,@papellido,
@sapellido,@direccion,@NumT,@NumNiños)
end
go
select * from EducadorSocial
--------------------------------------------------------------------------------
create procedure Registrar8
@idA
int,
@pnombre
nvarchar(30),
@snombre
nvarchar(30),
@papellido
nvarchar(30),
@sapellido
nvarchar(30),
@direccion
nvarchar(100),
@NumT nvarchar(10)
as begin
insert into Maestro values(@idA,@pnombre,@snombre,@papellido,
@sapellido,@direccion,@NumT)
end
go
select * from Maestro
--------------------------------------------------------------------------------
create procedure Registrar9
@idA int,
@pnombre
nvarchar(30),
@snombre
nvarchar(30),
@papellido
nvarchar(30),
@sapellido
nvarchar(30),
@direccion
nvarchar(100),
@NumT
nvarchar(10),
@TipoPsico nvarchar(50)
as begin
insert into Psicologo values(@idA,@pnombre,@snombre,@papellido,
@sapellido,@direccion,@NumT,@TipoPsico)
end
go
select * from Psicologo
--------------------------------------------------------------------------------
create procedure Registrar10
@idH int,
@año int
as begin
insert
into Alumnos values(@idH,@año)
end
go
select
* from Alumnos
--------------------------------------------------------------------------------
create procedure Registrar11
@idH int,
@idA int,
@n1 int,
@n2 int,
@n3 int,
@n4 int,
@n5 int,
@n6 int,
@n7 int
as begin
insert into Notas values(@idH,@idA,@n1,@n2,
@n3,@n4,@n5,@n6,@n7)
end
go
select * from Notas
--------------------------------------------------------------------------------
create procedure Registrar12
@idM int,
@idA int,
@nombre nvarchar(40)
as begin
insert into Asignaturas values(@idH,@idA,@nombre)
end
go
select * from Asignaturas
--------------------------------------------------------------------------------
/*Procedimiento para buscar*/
create
procedure Consulta1
as begin
select * from Huerfano
end
go
create
procedure Consulta2
as begin
select * from Donantes
end
go
create procedure [dbo].[respaldo]
@dir
nvarchar (90)
as
backup
database Hogar_de_Fe
to disk=@dir
GO
backup
database Hogar_de_Fe
to disk='H:\Hogar_de_Fe.bak'
Suscribirse a:
Entradas (Atom)