Educational guide
IDENTIFYING DATA 2011_12
Subject BASES DE DATOS Code 00702039
Study programme
INGENIERO EN INFORMATICA
Descriptors Credit. Type Year Period
7.5 Optional Fourth First
Language
Castellano
Prerequisites
Department ING.ELECTR.DE SIST. Y AUTOMATI
Coordinador
ALEGRE GUTIÉRREZ , ENRIQUE
E-mail ealeg@unileon.es
jmfocm@unileon.es
Lecturers
ALEGRE GUTIÉRREZ , ENRIQUE
FOCES MORÁN , JOSE MARÍA
Web http://
General description
The main objective is to give to the students some basic knowledge about Databases and Databases Management Systems (DMS). Our aim is that students learn what a database is and he or she learn how to design and implement databases using SQL (Structured Query Language) or either of two of the most used database systems, e. g., Microsoft SQL Server and Oracle. As particular objectives, we pretend that:
- The students obtain basic concepts about databases and DMS.
- The understand and learn how normalize and de-normalize databases
- They learn and they be able to use the SQL
- They understand and be able to create index and hash functions
- They understand the main ideas about transactions and coocurrence in a database environment
Tribunales de Revisión
Tribunal titular
Cargo Departamento Profesor
Tribunal suplente
Cargo Departamento Profesor

Objetivos
The main objective is to give to the students some basic knowledge about Databases and Databases Management Systems (DMS). Our aim is that students learn what a database is and he or she learn how to design and implement databases using SQL (Structured Query Language) or either of two of the most used database systems, e. g., Microsoft SQL Server and Oracle. As particular objectives, we pretend that:
- The students obtain basic concepts about databases and DMS.
- The understand and learn how normalize and de-normalize databases
- They learn and they be able to use the SQL
- They understand and be able to create index and hash functions
- They understand the main ideas about transactions and coocurrence in a database environment

Methodologies

The professor will give theoretical explanations in the classroom (lectures) using slices and he will resolve practical problems in the dashboard.

Students have a course book available (in Spanish) and the reference bibliography (in English).

In the course web site (agora) all the material used in the course will be available and the student will receive important information using post, events, and so on. The professor will explain and resolve the typical exercices in the dashboard.

The practical sessions will have place in the lab with the teacher assistance.

Contents
Topic Sub-topic
THEORY I. Concepts I. Basic concepts
II. Entity-Relationship Model
III. Extended Entity-Relationship Model
IV. Normalization
II. Structured Query Language V. SQL
III. Concurrence and indexes VI. Indexes
VII. Transactions
VIII. Hashing functions and B+ trees
IX. Concurrence control
LAB The practical sessions will take place in the F3 Lab using Microsoft SQL Server and Oracle DMSs

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

b) Using SQL in the command line
(Both using SQL Server and Oracle)
Database creation. Tables, index and views creation.
Queries
Stored procedures and triggers

Personalized attention

Assessment
  Description Qualification
 
Other comments and second call

Basic

Complementary