Universidad de Jaén

Menú local

Syllabus 2019-20 - 13312013 - Database Foundations (Fundamentos de bases de datos)

Caption
  • Level 1: Tutorial support sessions, materials and exams in this language
  • Level 2: Tutorial support sessions, materials, exams and seminars in this language
  • Level 3: Tutorial support sessions, materials, exams, seminars and regular lectures in this language
DEGREE: Grado en Ingeniería informática
FACULTY: SCHOOL OF ENGINEERING OF JAÉN

ACADEMIC YEAR: 2019-20
SYLLABUS
1. COURSE BASIC INFORMATION
NAME: Database Foundations
CODE: 13312013 ACADEMIC YEAR: 2019-20
LANGUAGE: English LEVEL: 3
ECTS CREDITS: 6.0 YEAR: 2 SEMESTER: SC
 
2. LECTURER BASIC INFORMATION
NAME: MOLINA AGUILAR, ANDRÉS
DEPARTMENT: U118 - INFORMÁTICA
FIELD OF STUDY: 570 - LENGUAJES Y SISTEMAS INFORMÁTICOS
OFFICE NO.: A3 - 135 E-MAIL: molina@ujaen.es P: 953212889
WEBSITE: -
LANGUAGE: - LEVEL: 3
 
NAME: MARTÍNEZ CRUZ, CARMEN
DEPARTMENT: U118 - INFORMÁTICA
FIELD OF STUDY: 570 - LENGUAJES Y SISTEMAS INFORMÁTICOS
OFFICE NO.: A3 - 241 E-MAIL: cmcruz@ujaen.es P: 953213017
WEBSITE: http://wwwdi.ujaen.es/?q=es/cmcruz
LANGUAGE: - LEVEL: 3
 
3. CONTENT DESCRIPTION

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.

4. COURSE DESCRIPTION AND TEACHING METHODOLOGY

    

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

5. ASSESSMENT METHODOLOGY

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.

6. BOOKLIST
MAIN BOOKLIST:
  • Database design for mere mortals [Recurso electrónico] : a hands-on guide to relational database des. Edition: 3rd ed. Author: Hernandez, Michael J. (Michael James), 1955-. Publisher: Upper Saddle River, NJ : Addison-Wesley, c2013  (Library)