Educational guide
IDENTIFYING DATA 2018_19
Subject DATABASES Code 00709012
Study programme
GRADO EN INGENIERÍA INFORMÁTICA
Descriptors Credit. Type Year Period
6 Compulsory Second First
Language
Ingles
Prerequisites
Department ING.ELECTR.DE SIST. Y AUTOMATI
Coordinador
ALEGRE GUTIÉRREZ , ENRIQUE
E-mail ealeg@unileon.es
vgonc@unileon.es
Lecturers
ALEGRE GUTIÉRREZ , ENRIQUE
GONZÁLEZ CASTRO , VICTOR
Web http://
General description In this course, students will learn basic concepts about databases and will obtain some practical skills with two commercial DBMS, as are Oracle and Microsoft SQL Server. The student will learn: - Fundamentals about databases. - How to design a database using the Entity-Relationship Model. - How to implement a database using a Relational Model. - To use the SQL (Structured Query Language) to create databases and to query a database. - Some concepts about indexes and hash functions.
Tribunales de Revisión
Tribunal titular
Cargo Departamento Profesor
Presidente ING.ELECTR.DE SIST. Y AUTOMATI RIESCO PELAEZ , FELIX
Secretario ING.ELECTR.DE SIST. Y AUTOMATI BLAZQUEZ QUINTANA , LUIS FELIPE
Vocal ING.ELECTR.DE SIST. Y AUTOMATI FUERTES MARTINEZ , JUAN JOSE
Tribunal suplente
Cargo Departamento Profesor
Presidente ING.ELECTR.DE SIST. Y AUTOMATI ALONSO ALVAREZ , ANGEL
Secretario ING.ELECTR.DE SIST. Y AUTOMATI DIEZ DIEZ , ANGELA
Vocal ING.ELECTR.DE SIST. Y AUTOMATI ALAIZ RODRIGUEZ , ROCIO

Competencias
Code  
A8445
A8534
A8539
A8540
A8571
A8602
A8612

Learning aims
Competences
To understand and be able to use basic concepts related to databases. To be able to create an Entity-Relationship diagram from a database description problem and later to be able to translate it into a Relational diagram. To be able to implement a database using a graphical user interface. To understand and to use the primary SQL(Structured Query Language) sentences. To implement a database using SQL. To recover information from a database using SQL queries. To know and to understand the indexation concepts and to know how to apply them in a database implementation. To understand and to know how to use transactions, locks and concurrency concepts. A8445
A8534
A8539
A8540
A8571
A8602
A8612

Contents
Topic Sub-topic
THEORY I. Concepts I. Basic concepts
Database Management Systems, Data, Models, Languages, Transactions, Users, Systems structure.
II. Entity-Relationship Model
Basic Concepts, Design, Constraints, Keys, ER Diagram, Weak entities.
III. Extended Entity-Relationship Model
Extended features. EER to Relational Model transformation. Constraints. The student's problem.
IV. Normalization
Flat tables. Normal Forms. Advantages and disadvantages. De-normalization.
II. Structured Query Language (SQL) V. SQL
Tools. Select. Where. Columns and functions. Aggregates. Totals and subtotals. Joins. Subqueries. Inserting and creating data. Stored Procedures. Triggers.
III. Concurrency and indexes VI. Indexes
Introduction. Ordered indexes. Hashing functions.
VII. Transactions
Introduction. Transactions. Transactions recovering.
VIII. Hashig functions and B+ trees
Ordered indexes. Hashing functions.
IX. Concurrency control
Concurrency problems. Locks. Dead locks. Seriability.
LAB The practical sessions will take place in the F3 Lab using Microsoft SQL Server and Oracle DBMSs

a) Using the graphical interface in SQL Server:
Database design. Database implementation. Tables, index, views and constraints creation.

b) Using SQL command line:
(Both using M. SQL Server and Oracle)

Database creation. Tables, indexes and views creation.
Queries.
Stored procedures and triggers

Planning
Methodologies  ::  Tests
  Class hours Hours outside the classroom Total hours
Laboratory practicals 55 0 55
 
Problem solving, classroom exercises 25 0 25
Personal tuition 5 0 5
 
Lecture 55 0 55
 
Mixed tests 10 0 10
 
(*)The information in the planning table is for guidance only and does not take into account the heterogeneity of the students.

Methodologies
Methodologies   ::  
  Description
Laboratory practicals Will take place in the lab F3, using a computer in most cases for implementing and querying databases
Problem solving, classroom exercises The instructor will resolve a set of problems during the lectures, interacting with the students for answering doubts and to clarify questions.
Personal tuition Students attention will take place on person and on-line. The student will ask for an appointment using a specific agora forum prepared for this fact.
Lecture Will take place in the classroom using slides and the blackboard.

Personalized attention
 
Lecture
Laboratory practicals
Problem solving, classroom exercises
Description
Students attention will take place on person and on-line. The student will ask for an appointment using a specific agora forum prepared for this fact.

Assessment
  Description Qualification
Lecture The student will take two test to assess some of the theoretical concepts explained during the lectures:

- One test about the basic databases concepts (5% overall grade)
- Another test about indexes, concurrence and transactions (5% of overall grade)
15%
Laboratory practicals It will be a test about SQL. For passing the course it is necessary to obtain at least half of the maximum grade of this exam.
It will be necessary to submit the solutions for some practical sessions.
10%
Problem solving, classroom exercises The student will need to pass a test with two problems: a Entity-Relationship diagram and later a Relacional diagram created from a text proposed by the teacher.
To pass the course it is mandatory to pass this part obtaining at least half the maximum grade.
50%
Others All the students will carried out a practical project in groups of three.
This project will have several deliverables with fixed dates. No presentation of one deliverable will means a 20% of penalty in the final grade of the project.
25%
 
Other comments and second call

Students who do not pass a test during the continuous assessment will have another chance for every specific test in the ordinary first call.

Students who do not pass a test during the ordinary first call will have another chance for every specific test in the ordinary second call. 

To pass the course during the continuous assessment, it is necessary to pass each of the examinations of each part and also the practical project.

Students who do not present the Practical Project in the due dates will be allowed to present it in the day of the first or the second call, but they will have a penalty in their Practical Project grade. It also will be penalties for late submissions.


Sources of information
Access to Recommended Bibliography in the Catalog ULE

Basic

Silberschatz, A. Korth, H.F. y Sudarshan, S. (2010). Database System Concepts, 6th edition, McGraw Hil.

Alegre, E., Fernández, R.A. y Sánchez, L. (2003). Fundamentos y Prácticas de Bases de Datos. Secretariado de Publicaciones y Medios Audiovisuales de la Universidad de León.

Silberschatz, A. Korth, H.F. y Sudarshan, S. (2006). Fundamentos de bases de datos, 5ª edición, McGraw Hil.

Complementary

Date, C. J. (1999). An Introduction to Database Systems. Prentice-Hall.

Elmasri, RA & Navathe S., (2003). Fundamentals of Database Systems (4th Edition). Addison Wesley

Gary W. Hansen y J.V. Hansen (1997). Diseño y Administración de Bases de Datos, 2ª edición, Prentice Hall.

de Miguel, A. y Piattini, M. (1997). Fundamentos y modelos de Bases de Datos, RA-MA.

Beynon-Davies P. (2000). Database Systems, 2th edition, Macmillan Press Ltd.


Recommendations


Subjects that it is recommended to have taken before
COMPUTER PROGRAMMING I / 00709009