Educational guide
IDENTIFYING DATA 2018_19
Subject Data bases Code 00417016
Study programme
GRADO EN INFORMACIÓN Y DOCUMENTACIÓN (OL)
Descriptors Credit. Type Year Period
6 Compulsory Second Second
Language
Castellano
Prerequisites
Department ING.ELECTR.DE SIST. Y AUTOMATI
Coordinador
MORÁN ÁLVAREZ, ANTONIO
 E-mail amora@unileon.es
adied@unileon.es
Lecturers
DÍEZ DÍEZ , ÁNGELA
MORÁN ÁLVAREZ, ANTONIO
Web http://agora.unileon.es
General description Fundamentals, applications and use of databases for undergraduate students in información y documentación
Tribunales de Revisión
Tribunal titular
Cargo Departamento Profesor
Presidente ING.ELECTR.DE SIST. Y AUTOMATI ALEGRE GUTIERREZ , ENRIQUE
Secretario ING.ELECTR.DE SIST. Y AUTOMATI ALAIZ RODRIGUEZ , ROCIO
Vocal ING.ELECTR.DE SIST. Y AUTOMATI RIESCO PELAEZ , FELIX
Tribunal suplente
Cargo Departamento Profesor
Presidente ING.ELECTR.DE SIST. Y AUTOMATI ALONSO ALVAREZ , ANGEL
Secretario ING.ELECTR.DE SIST. Y AUTOMATI FERNANDEZ LOPEZ , CARLOS
Vocal ING.ELECTR.DE SIST. Y AUTOMATI BENAVIDES CUELLAR , MARIA DEL CARMEN

Competencias
Code  
A14390
A14421
A14422
A14429
A14431
A14444
A14452
A14453
A14457
C1
C2
C4
C5

Learning aims
Competences
A14421
A14422
A14444
A14452
A14453
A14457
 C4
A14390
A14421
A14429
A14452
A14453
 C2
C5
A14390
A14422
A14431
A14444
A14452
A14453
 C1
C2
C5
A14429
A14431
 C1
C5

Contents
Topic Sub-topic
1.-Introduction to databases 1.1-Introduction
1.2-Architecture and levels
1.3-The DBMS / DBMS
1.4-Types of data
2.-Relational Data Model 2.1-Introduction RDBMS
2.2 Conceptual Model-E / R
2.3-Relational-BD
2.4-Standardization
2.5 Integrity and Safety-BD
3.-BD Implementation: SQL Language 3.1-Introduction
3.2 Levels SQL
3.3-SQL in a relational database
4.-BD Advanced Topics 4.1-Introduction
4.2- Other BD
4.3-Data mining, OLAP, ...

Planning
Methodologies  ::  Tests
  Class hours Hours outside the classroom Total hours
Lecture 5 7 12
 
Seminars 10 20 30
Practicals using information and communication technologies (ICTs) in computer rooms 20 10 30
Assignments 0 30 30
Other methodologies 26 0 26
 
Personal tuition 10 10 20
 
Mixed tests 2 0 2
 
(*)The information in the planning table is for guidance only and does not take into account the heterogeneity of the students.

Methodologies
Methodologies   ::  
  Description
Lecture Presentation by the teacher of the course contents . At the beginning of each block by the introduction to the different sections of which consists , and the student will define the most important key points of each. Allows exposing the contents to the students and explain the basics of the subject to facilitate orientation , preparation and study it.
Seminars Presentations and working methods and applications and then performing subsequent activities by students performing construction processes and information exchanges .
Practicals using information and communication technologies (ICTs) in computer rooms Several cases are solved using dynamic techniques on the platform and new exercises where students can apply their knowledge are proposed to arise . Use of platform resources .
Assignments Implementation by students reading on technological systems and / or conduct of a document or presentation on it.
Other methodologies Use of on- line learning techniques using local and remote dynamic self-learning tools for the managers use databases . They provide tutoring use and generation effort.
Personal tuition The tutorials will be conducted using the resources of the ULE platform . And can be made in person at weekly schedule request by the student , or the teacher tutoring defined in schedule agreed with the student.

Personalized attention
 
Practicals using information and communication technologies (ICTs) in computer rooms
Assignments
Description
TUTORING.
Classroom: monitoring the work of students is carried out. The teacher will assign a schedule to serve students within the student contact hours.
Tutoring via electronic resources: Allows you to track personal to each student via electronic resources such as email, forums and any other system that facilitates the ULE. A schedule will be established therein and it will be arranged with the students. Will be made at the end of each block.
Traditional tutoring. A schedule of care will be established for students in person. This schedule agreed with the students and may be performed on an on-line or in person.

Assessment
  Description Qualification
Practicals using information and communication technologies (ICTs) in computer rooms Performing exercises exercise concepts resolution
Resolution on-line questionnaires 		15%
Assignments Perform design / proposed by the profesorEstructura, quality, originality, and clarity work.
Using office automation tools 		35%
Mixed tests PRESENTIAL
It consists of questionnaires on the subject. Theoretical content
Exercises on the practical section. Knowledge and understanding of the subject. 		50%
 
Other comments and second call

Sources of information
Access to Recommended Bibliography in the Catalog ULE

Basic

Diez Diez, Ángela. 1997. Tecnologías aplicadas a la información: bases de datos, documentación electrónica y multimedia . León: Instituto de Automática y Fabricación, 1997.

A. de Miguel, M. Piattini. Concepción y Diseño de Bases de Datos.  Ra-Ma, 1993.  

Korth, H.F.: Silberschatz, A. .Fundamentos de Bases de Datos.  McGraw-Hill, 2002.  

Date, C.J.. Introducción a los Sistemas de Bases de Datos.  Addison-Wesley, 2002.

Elsmari y Navathe. Sistemas de Bases de Datos,  Addison-Wesley, 1997.

C. Marée, G. Ledant,  SQL. Iniciación, Programación y Prácticas Avanzadas. Masson, 1992.

B. Campderrich,. Técnicas de Bases de Datos.  Editores Técnicos Asociados, 1983.

Connolly, T.M. y Begg, C.E., Sistemas de bases de datos: Un Enfoque Práctico para Diseño, Implementación y Gestión, Cuarta Edición, Pearson Education S.A., Madrid, 2005 (ISBN: 84-7829-075-3)

Silberschatz, A., Korth, H.F y Sudarshan, S., Fundamentos de Bases de Datos, Quinta Edición, McGraw-Hill/Interamericana de España, S.A.U., Madrid, 2006 (ISBN: 84-481-4644-1)

Manuales profesor sobre SGBD comerciales. Manual Microsoft Access.

Manuales MYSQL. Manuales entornos de aplicación MySql on line.

Oracle. MySQL.com.  http://www.mysql.com/. 2010. Web oficial de MySQL, con descarga y manuales de uso.  [Consultado Mayo 2011]

Microsoft. Conceptos básicos del diseño de una BD. http://office.microsoft.com/es-hn/access-help/conceptos-basicos-del-diseno-de-una-base-de-datos-HA001224247.aspx.  Microsoft Corporation. 2011.  [Consultado Mayo 2011]
Complementary

Ullman, J.D. y Widom, J., Introducción a los Sistemas de Bases de Datos, Primera Edición, Prentice Hall, México, 1999 (ISBN: 970-17-0256-5)

Ramakrishnan, R. y Gehrke, J., Sistemas de Gestión de Bases de Datos, Tercera Edición, McGraw-Hill/Interamericana de España, S.A.U., Madrid, 2007 (ISBN: 978-84-481-5638-1)

Recommendations


Subjects that it is recommended to have taken before
BASIC INFORMATION TECHNOLOGIES / 00415005
ELECTRONIC EDITION / 00415013
 
Other comments
The students must have installed at least one office environment, either MSOffice, OpenOffice or LibreOffice.