Educational guide
IDENTIFYING DATA 2024_25
Subject DATABASES Code 00415016
Study programme
0415 - GRADO EN INFORMACIÓN Y DOCUMENTACIÓN
Descriptors Credit. Type Year Period
6 Compulsory First Second
Language
Castellano
Prerequisites
Department ING.ELECTR.DE SIST. Y AUTOMATI
Coordinador
PEREZ LOPEZ , DANIEL
E-mail dperl@unileon.es
adied@unileon.es
ggonzm@unileon.es
Lecturers
DÍEZ DÍEZ , ÁNGELA
GONZALEZ MATEOS , GUZMAN
PEREZ LOPEZ , DANIEL
Web http://agora.unileon.es
General description In this course, the basic principles of databases are presented, starting with the definition of the basic concepts of data, conceptual models and implementation in a relational DBMS, and SQL language.
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 BLAZQUEZ QUINTANA , LUIS FELIPE
Secretario ING.ELECTR.DE SIST. Y AUTOMATI FERNANDEZ LOPEZ , CARLOS
Vocal ING.ELECTR.DE SIST. Y AUTOMATI BENAVIDES CUELLAR , MARIA DEL CARMEN

Competencias
Code  
A2124
A2149
A2155
A2159
A2200
A2203
B224
B225
B233
B234
B248
B250
B257
C2 CMECES2 That students know how to apply their knowledge to their work or vocation in a professional manner and possess the skills that are usually demonstrated through the development and defense of arguments and the resolution of problems within their area of study.
C3 CMECES3 That students have the ability to gather and interpret relevant data (normally within their area of study) to make judgments that include reflection on relevant issues of a social, scientific or ethical nature.

Learning aims
Competences
Knows how to use the different elements contained in the current DBMS (mainly in Windows environment). A2124
A2155
A2159
A2200
 B224
B225
B233
B257
 C2
C3
Know how to perform SQL queries in Relational Databases. A2124
A2149
A2200
A2203
 B233
B234
B248
B250
B257
 C2
C3

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 DB
2.4-Normalization
2.5 Integrity and security in BD
3.-DB Implementation: SQL Language 3.1-Introduction
3.2 Levels of SQL
3.3-SQL in a relational database
4.-DB 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 At the beginning of each block there will be an introduction to the different sections of which it consists, and the main important key points of each one will be defined to the student. It allows to expose the contents to the students and explain the basic concepts of the subject to facilitate the orientation, preparation and the study.
Seminars Presentations of methods, work, 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 Students will carry out works and/or make a document or presentation about it.
Other methodologies Use of on- line learning techniques using local and remote dynamic self-learning tools for the management database systems. The use of these tools will be tutored.
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.
Traditional tutoring. A schedule of care will be established for students in person. This schedule agreed with the students and may be performed on-line or in person.

Assessment
  Description Qualification
Practicals using information and communication technologies (ICTs) in computer rooms Performing concepts exercises.
Resolution of practical exercises.
Resolution on-line questionnaires 		15%
Assignments Perform proposed design/work. Structure, quality, originality, and clarity.
Using office 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

The student's initiative in the development of the activities and new contributions are valued.

The CONTINUOUS EVALUATION IS 50% OF THE FINAL GRADE. THE OBJECTIVE TEST IS 50%.

In the application of the above table, when activities corresponding to any of the evaluable aspects outlined are NOT carried out; the percentage of these aspects will be distributed evenly among the rest of the different concepts in order to complete 100% of the grade. If the grade of the on-site evaluation block is lower (by more than 2 points) than that of the continuous evaluation block, a correction factor will be applied to obtain the final grade, giving more weight to the on-site evaluation.

For the evaluation the following criteria and modalities will be taken into account, a) Students who follow the continuous evaluation will be evaluated taking into account the above data, b) Those students who do not follow the continuous evaluation, must pass an exam exercise and perform at least 50% of the activities of the continuous evaluation where they demonstrate that they master the learning outcomes. The activities must be delivered on time.

In order to pass the course, two evaluation processes are contemplated, of which at least half of the percentage of each must be achieved: -Continuous evaluation: 50%. -Mixed test: 50%;

The mixed exams will be held in two calls corresponding to the months of June and July, on the dates established and approved by the Junta de Facultad, published in the web of the Facultad de Filosofía y Letras.

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, Jeffrey D.., Widom, Jennifer. A First Course in database systems. Reino Unido: Prentice Hall, 1997.

Ramakrishnan, Raghu., Gehrke, Johannes. Database Management Systems. Reino Unido: McGraw-Hill, 2003.

Recommendations


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