Educational guide
IDENTIFYING DATA 2024_25
Subject DATABASES Code 00709012
Study programme
0709 - 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
efidf@unileon.es
Lecturers
ALEGRE GUTIÉRREZ , ENRIQUE
GONZÁLEZ CASTRO , VICTOR
FIDALGO FERNANDEZ , EDUARDO
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 ALAIZ RODRIGUEZ , ROCIO
Secretario ING.ELECTR.DE SIST. Y AUTOMATI DIEZ DIEZ , ANGELA
Vocal ING.ELECTR.DE SIST. Y AUTOMATI MORAN ALVAREZ , ANTONIO

Competencias
Code  
A18104
A18105
A18121
B5618
B5619
B5626
B5627
B5628
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.
C4 CMECES4 That students can transmit information, ideas, problems and solutions to both a specialised and non-specialised audience

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. A18104
A18121
 B5618
B5619
B5626
 C2
A18104
A18105
A18121
 B5618
B5619
B5626
B5627
B5628
 C2
C4
A18104
A18121
 B5618
B5619
B5626
B5627
B5628
 C4
A18104
A18105
A18121
 B5618
B5619
B5626
B5627
 C2
C4
A18104
A18105
A18121
 B5618
B5626
 C2
C4

Contents
Topic Sub-topic
Block I. CONCEPTS Lesson I: BASIC CONCEPTS
Interest of database management systems. Data vision. Data models. Database languages. Transaction management Users. General structure of the system.

Lesson I: ENTITY-RELATIONSHIP MODEL
Basic concepts. Design. Constrains. Keys. ER diagram. Weak entities set. Entity-relationship diagram.

Lesson III: EXTENDED ENTITY-RELATIONSHIP MODEL
Extended features. EER transformation to Relational. Restrictions. The student's problem.

Lesson IV: STANDARDIZATION.
Flat tables. Normal Forms. Advantages and disadvantages. Denormalization.
Block II. STRUCTURED QUERY LANGUAGE (SQL) Lesson V: SQL
Tools. Select. Where. Columns and functions. Aggregates. Totals and subtotals. Joins. Subqueries. Inserting and creating data. Stored Procedures. Triggers.
Block III. CONCURRENCY AND INDEXES Lesson VI: INDEXES
Introduction. Ordered indexes. Hashing functions.

Lesson VII. TRANSACTIONS
Introduction. Transactions. Transactions recovering.

Lesson VIII. CONCURRENCY CONTROL
Concurrency problems. Locks. Dead locks. Seriability.
Block IV. LABs 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 22 33 55
 
Problem solving, classroom exercises 10 15 25
Personal tuition 2 3 5
 
Lecture 22 33 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
 
Laboratory practicals
Lecture
Problem solving, classroom exercises
Description
Students attention will take place on person and on-line. The student will ask for an appointment by email or using a specific agora forum prepared for this fact.

Assessment
  Description Qualification
Laboratory practicals It will be a exam to evaluate the learned concepts of SQL. To pass the course it is necessary to obtain at least 3.5 points out of 10 in the SQL exam.
It will be necessary to submit the solutions for some practical sessions using a specific task in Agora. 		15%
Lecture The student will take a test to assess some of the theoretical concepts explained during the lectures related to basic databases concepts and also about indexes, concurrence and transactions. 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
In order to pass the course, both in the first and in the second call, the student must obtain an average of 5 out of 10 points, so he/she has to pass independently the evaluation of the three main parts of the course, which are: (i) The diagrams exam, which has a weight of 50%, (ii) The project of the course, which has a weight of 25%, and (iii) The theory, SQL and indexes exam, which has a weight of 25% of the mark.

Even if the average mark is higher than 5 out of 10 (or the value established for passing), the student will not pass if the above conditions are not met. If your average is higher than 5 out of 10 and you do not pass one of the parts, the grade that will appear in ACTAS will be NOT PRESENTED.


Other observations:
  • Students who do not pass an exam in the continuous assessment may take the exam again in the first ordinary exam session.
  • Students who do not pass the subject in the first ordinary exam may take the make-up exam for the parts not passed in the second ordinary exam.
  • Both in the first and in the second call, if a student does not submit any assignment, including the project or the deliverables of the laboratory practicals on the established date, he/she could submit them later, in the corresponding call but always before the deadline indicated for this purpose, although he/she will be penalised in the grade obtained for submitting it after the deadline. Each of the late submissions will also be penalised.

Sources of information
Access to Recommended Bibliography in the Catalog ULE

Basic

D. Kronenke, D. Auer, S. Vandenberg, R. Yoder (2019). Database Concepts. 9th Edition, Pearson.

C.J. Date (2019). Database Design and Relational Theory: Normal Forms and All That Jazz. 2nd edition, Apress

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
DATA STRUCTURES / 00709018