Universidad de Jaén

THEORY PROGRAM

 

    Introduction to Databases

1.1 Fundamental Concepts

1.2 Levels information

1.3 Functional description of the DBMS

 

    The relational database approach

2.1 Relational data structure

2.2 Relational Algebra

 

    The SQL language

3.1 Data Definition Language ( DDL )

3.2 Data Manipulation Language (DML )

 

    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 toconceptual schemes

4.6 Normalization tables

 

 

PRACTICAL PROGRAM:

 

    SQL Programming

1.1. Work environment Oracle SQL * Plus. Connecting toserver.

1.2 Commands CREATE TABLE , ALTER TABLE and DROP TABLE.

1.3 Inserting , modifying and deleting : Commands INSERT ,UPDATEand 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

 

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

2.1. Preparation of the document requirements as guidancedocument

2.2. Conceptual design (entity relationship model): Definitionof entities and relationships, Defining constraints anddocumentation

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 arelational database (Oracle DBMS) and the design and implementationof queries over the database.

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

The group and individual tutorials as established by the regulations are NOT PRESENTIAL. Therefore, the students themselves  have to dedicate these hours to the resolution of problems and doubts.

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 afteradding the grade of the following sections:

 

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

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

- 5% of the grade obtained throught the performance of proposed exercises

 

The practical part of the course consists of :

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

- Databases Final Project: Grade between 0 .. 10

 

The grade obtained in the continuous evaluation by the studentduring the academic year (practice and participation scores) willbe maintained for all the academic year.

 

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