Educational guide
IDENTIFYING DATA 2024_25
Subject Data bases Code 00417016
Study programme
0417 - GRADO EN INFORMACIÓN Y DOCUMENTACIÓN (OL)
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
amora@unileon.es
Lecturers
DÍEZ DÍEZ , ÁNGELA
GONZALEZ MATEOS , GUZMAN
MORÁN ÁLVAREZ, ANTONIO
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


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 DB
3.-DB Implementation: SQL Language 3.1-Introduction
3.2 Levels of SQL
3.3-SQL in a relational database
4.-Advanced Topics 4.1-Introduction
4.2- Other DB
4.3-Data mining, OLAP, ...

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   ::  
  Description
Lecture Presentation by the teacher of the contents of the course. 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 online at weekly schedule request by the student , or the teacher tutoring defined in schedule agreed with the student.

 
Assignments
Practicals using information and communication technologies (ICTs) in computer rooms
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 an on-line or in person.

  Description Qualification
Assignments Perform proposed design/work. Structure, quality, originality, and clarity.
Using office automation tools 		35%
Practicals using information and communication technologies (ICTs) in computer rooms Performing concepts exercises.
Resolution of practical exercises.
Resolution on-line questionnaires. 		15%
Mixed tests 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 Faculty Board, which will be made public on the ULE Online website. http://online.unileon.es/estudios/grado-informacion-documentacion/

The final exam will be carried out using the SMOWL proctoring program and the specific indications posted on the virtual campus about its use and the allowed behavior during the exam must be followed.


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.  

Date, C. J.. An introduction to database systems. Jamaica: Addison-Wesley, 2000.

Elmasri, Ramez., Navathe, Sham. Fundamentals of Database Systems. Estados Unidos: Addison-Wesley Pub., 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, Thomas M.., Begg, Carolyn E.. Database Systems: A Practical Approach to Design, Implementation, and Management. Reino Unido: Addison-Wesley, 2002.

Silberschatz, Abraham., Korth, Henry F.., Sudarshan, S.. Database System Concepts. Reino Unido: McGraw-Hill Higher Education, 2005.

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]
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)



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.