Metricas del Software Hogar de Fe

---------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------

Entidad-Relacion de las tablas del Hogar de Fe

 

DIAGRAMA ENTIDAD-RELACION

 

 

Tablas de Asociacion Hogar de Fe

TABLAS

 

 

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'