Universidad de Jaén

THEORY PROGRAM

1. Introduction to Databases

1.1 Fundamental Concepts

1.2 Levels information

1.3 Functional description of the DBMS

1. The relational database approach

2.1 Relational data structure

2.2 Relational Algebra

1. The SQL language

3.1 Data Definition Language ( DDL )

3.2 Data Manipulation Language (DML )

1. The Entity / Relationship Model

4.1 Basic Concepts

4.2 Reduction to hierarchical relationships

4.3 Transformation of ternary relationships

4.4 Conversion strong weak entities

4.5 Application of relational database logical approach to conceptual schemes

4.6 Normalization tables

PRACTICAL PROGRAM:

1. SQL Programming

1.1. Work environment Oracle SQL * Plus. Connecting to server.

1.2 Commands CREATE TABLE , ALTER TABLE and DROP TABLE.

1.3 Inserting , modifying and deleting : Commands INSERT ,UPDATE and DELETE. Integrity Rules

1.4 Basic use of the SELECT command

1.7 Advanced use of the SELECT command

1.8 Subqueries in INSERT, DELETE and UPDATE

1.9 Managing views in SQL: CREATE VIEW Command

1. Database Project (integration of learned concepts on a real case)

2.1. Preparation of the document requirements as guidance document

2.2. Conceptual design (entity relationship model): Definition of entities and relationships, Defining constraints and documentation

2.3. Relational Logic Design: Conversion N-M relationships, validation rules and default values, documentation.

2.4.Generating DDL and DMLfor the selected DBMS.

The activities will include theoretical lectures where database exercises will be discussed and resolved from a requirements document.

Practical activities will include the implementation of a relational database (Oracle DBMS) and the design and implementation of queries over the database.

The tutorial classes include debate about the key concepts of the subject and the resolution of advanced exercises.

Students with special educational needs should contact the Student Attention Service (Servicio de Atención y Ayudas al Estudiante) in order to receive the appropriate academic support

To pass the course, the student must obtain a score of 5.0 after adding the grade of the following sections:

- 70 % of the grade obtained in the theory exam (A minimum of 5 out of 10 is required in this exam)

- 25 % of the grade obtained in the practical part (No minimum required in this part)

- 5% obtained in the class participation

The practical part of the course consists of :

- Scripts practices. Continuous assessment by scoring exercises in practice sessions. If for any valid reason, the student is unable to attend continuously to those classes, he/she must notify to the teacher at the beginning of the semester, in order to find a solution that satisfies both parties. Grade between 0 .. 10

- Databases Final Project: Grade between 0 .. 10

The grade obtained in the continuous evaluation by the student during the academic year (practice and participation scores) will be maintained for all the academic year.

During the academic semester, it is possible to accomplish several tests in order to eliminate some parts of the subject.