Universidad de Jaén

THEORYPROGRAM

1. Introduction to Databases
1.1 Fundamental Concepts
1.2 Levels information
1.3 Functional description of the DBMS

2 . The relational database approach
2.1 relational data structure
2.2 Relational Algebra

3 . The SQL language
3.1 Data Definition Language ( DDL )
3.2 Data Manipulation Language (DML )

4 . The model Entity / Relationship
4.1 Fundamental 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 DELETE TABLE.
1.3 Inserting , modifying and deleting : Commands INSERT , UPDATE and DELETE
Integrity Rules
1.4 Consultation of information I. Basic uses of the SELECT
1.7 Consultation of information II . Advanced uses of the SELECT
1.8 Subqueries in INSERT, DELETE and UPDATE
1.9 Creation and view queries : CREATE VIEW Command

2. Database Project (integration of concepts learned on a real case)
2.1 Preparation of the requirements document as guidance document
2.2 . Conceptual design ( entity relationship model ): Definition of entities and   relationships, Defining constraints and model documentation
2.3 . Relational Logic Design : Conversion NM relationships , validation rules and
default values, model documentation .
2.4.GeneratingDDL andDMLfor theselectedDBMS.

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

Hands-on activities include the implementation of a relational database (Oracle DBMS) and the realization of queries to the database and the data dictionary.

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, you must obtaina scoreof 5.0after addingthe notesofthe following:

- 70 % of grade theory exam (A minimum of 5 out of 10 is required in this exam)
- 25 % of the grade of the practical (No minimum required in this part)
- 5% of the note of harvesting and monitoring the theoretical and practical

The practical part of the course consists of :

- Scripts practices . Continuous assessment rated PASS / FAIL . If for any valid reason , the student is unable to attend continuously to those classes, will notify the beginning of the semester the teacher responsible for the group , in order to find a solution that satisfies both parties

- Draft Databases: Note number 0 .. 10


A call shall be deemed exhausted when the student has completed all the assessment procedures provided for in the Teaching Guide , including the final proof , if any

During theacademicsemester,tests may be conductedevaluation studentsofpart of the syllabus, in agreement withthe majority ofstudents.