Universidad de Jaén

Menú local

Syllabus 2017-18 - 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: 2017-18
COURSE: Database Foundations
SYLLABUS
1. COURSE BASIC INFORMATION
NAME: Database Foundations
CODE: 13312013 ACADEMIC YEAR: 2017-18
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: -
ORCID: https://orcid.org/0000-0002-7823-8348
LANGUAGE: - LEVEL: 3
NAME: MARTÍN VALDIVIA, MARÍA TERESA
DEPARTMENT: U118 - INFORMÁTICA
FIELD OF STUDY: 570 - LENGUAJES Y SISTEMAS INFORMÁTICOS
OFFICE NO.: A3 - 127 E-MAIL: maite@ujaen.es P: 953212898
WEBSITE: blogs.ujaen.es/maite
ORCID: https://orcid.org/0000-0002-2874-0401
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 databaseexercises will be discussed and resolved from a requirementsdocument.

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.

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 minimumrequired in this part)

- 5% obtained in the class participation

 

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)