Descripción: ejemplo de caso de estudio para implementacio de una base de datos
Listado de ND EmpresasDescripción completa
Descripción completa
Descripción completa
Ejercicios Base de DatosDescripción completa
Documentación del Desarrollo de un proyecto de Base de datos para un Zoológico local. Incluye todos los requisitos que se tomaron en cuenta para su elaboración al igual que la problemática q…Descripción completa
Descripción completa
Descripción: Base de Datos
Descripción completa
Replicacion Base de DatosDescripción completa
base de datos de un acuerio ejemplo
Base de Datos RelacionalDescripción completa
Descripción completa
Descripción completa
Descripción completa
Descripción completa
Fundamentos de base datos, contenido de conceptos basicos, en el curso de base de datos, para posteriormente utilizar microsoft Access 2010. Ojo: Material BasicoDescripción completa
Descripción: documentacion de proyecto base de datos
purinaDescripción completa
UNIVERSIDAD PRIVADA DE TACNA FACULTAD DE CIENCIAS EMPRESARIALES Escuela Profesional de Cs. Contables Financieras
CUESTIONARIO PARA AUDITORÍA DE BASE DE DATOS A continuación se presenta un checklist resumido para que usted y su grupo de trabajo puedan analizar el estado en que se encuentra la base de datos que posea su sistema de información de una organización. Una vez que concluya con el llenado del checklist, deberá de elaborar tres conclusiones y tres recomendaciones por todo el presente documento
!" %" &" '" ("
/" !.
1) Datos de los Integrantes Integrant es del Grupo de Trabajo: Trabajo: Apellidos y #ombres $$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$ Apellidos y #ombres $$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$ Apellidos y #ombres $$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$ Apellidos y #ombres $$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$ Apellidos y #ombres $$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$ 2) Datos Generales de la Organización: Organiza ción: &" #ombre de la )mpresa )valuada $$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$ $$$ '" *ubro del #egocio de la )mpresa )valuada $$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$$$ $$ (" #ombre del del +istema de nformació nformación n el cual está está evaluando evaluando su -ase de de datos de la organización organización $$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$ $$$$$$ " $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$
8)
CUESTIONARIO
+e realiza realiza copias copias de seguridad seguridad 0diariamente, 0diariamente, semanalmente semanalmente,, mensualmente, mensualmente, etc."1 2" + #3 #4A !5" 3bservaciones !!" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$ !%" !&" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$ %. )6iste alg7n alg7n usuario que que no sea el 8-A 8-A 0administrad 0administrador or de base de de datos" pero pero que tenga tenga asignado asignado el rol 8-A del servidor1 !'" + #3 #4A !(" 3bservaciones !" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$ !/" !9" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$ &. +e encuentra encuentra un administrador administrador de sistemas sistemas en la empresa empresa que lleve lleve un control de de los usuarios1 usuarios1 !2" + #3 #4A %5" 3bservaciones %!" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$ %%" %&" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$ %'" %(" '. +on gestionados gestionados los perfiles perfiles de acceso de estos estos usuarios usuarios por el administrador1 administrador1 %" + #3 #4A %/" 3bservaciones %9" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$ %2" &5" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$ (. +e renuevan renuevan las claves claves de de los usuarios de la -ase de 8atos1 8atos1 &!" + #3 #4A &%" 3bservaciones &&" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
UNIVERSIDAD PRIVADA DE TACNA FACULTAD DE CIENCIAS EMPRESARIALES Escuela Profesional de Cs. Contables F inancieras
&'" &(" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ . +e obliga el cambio de la contrase:a de forma automática1 &" + #3 #4A &/" 3bservaciones &9" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ &2" '5" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ /. +e encuentran listados de todos aquellos intentos de accesos no satisfactorios o denegados a estructuras, tablas f;sicas y lógicas del repositorio1 '!" + #3 #4A '%" 3bservaciones '&" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ ''" '(" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 9. uando se necesita restablecer la base de datos, se le comunica al administrador1
Auditoría de Sistemas de Información Página 2 de 6
UNIVERSIDAD PRIVADA DE TACNA FACULTAD DE CIENCIAS EMPRESARIALES Escuela Profesional de Cs. Contables Financieras
/2"
+
#3
#4A
95" 3bservaciones 9!" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 9%" 9&" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ !(. =a comunicación para la restauración de la base de datos se establece de forma escrita1 9'" + #3 #4A 9(" 3bservaciones 9" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 9/" 99" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ !. Una vez efectuada la restauración, se le comunica al interesado1 92" + #3 #4A 25" 3bservaciones 2!" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 2%" 2&" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ !/. +e lleva a cabo una comprobación, para verificar que los cambios efectuados en la base de datos son los solicitados por el interesado1 2'" + #3 #4A 2(" 3bservaciones 2" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 2/" 29" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ !9. +e documentan los cambios efectuados manualmente de la base de datos1 22" + #3 #4A !55" 3bservaciones !5!" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ !5%" !5&" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ !2. )l motor de -ase de 8atos soporta herramientas de auditoria1 !5'" + #3 #4A !5(" 3bservaciones !5" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ !5/" !59" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ %5. )6iste alg7n tipo de documentación referida a la estructura y contenidos de la -ase de 8atos1 !52" + #3 #4A !!5" 3bservaciones !!!" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ !!%" !!&" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ %!. +e cuenta con niveles de seguridad para el acceso a la -ase de 8atos1 !!'" + #3 #4A !!(" 3bservaciones !!" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ !!/" !!9" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$
Auditoría de Sistemas de Información Página 3 de 6
UNIVERSIDAD PRIVADA DE TACNA FACULTAD DE CIENCIAS EMPRESARIALES Escuela Profesional de Cs. Contables F inancieras
%%. )6iste alg7n plan de contingencia ante alguna situación no deseada en la -ase de 8atos1 !!2" + #3 #4A !%5" 3bservaciones !%!" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ !%%" !%&" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ !%'" %&. )6isten log?s que permitan tener pistas de auditor;a sobre las acciones realizadas sobre los objetos de las base de datos1 !%(" + #3 #4A !%" 3bservaciones !%/" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ !%9" !%2" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ %'. )6iste un contrato de confidencialidad en caso que la base de datos sea administrada o puesta en mantenimiento por terceras partes1 !&5" + #3 #4A !&!" 3bservaciones !&%" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ !&&" !&'" $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$$ %(. )stos terceros notifican las acciones realizadas de mantenimiento de hard@are y por ende su no disponibilidad de la base de datos1