BDA (Introduction to Databases: "Bases de Datos")

This is just a page with lecture notes given in José Hernández-Orallo's groups.

2nd Year. 2nd semester.

ETSINF (Escola Tècnica Superior d'Enginyeria Informàtica).

Degrees: ITIG/ITIS.

Academic Year 2010-2011

[versión en castellano curso 2004-2005] (Carlos Monserrat's groups)

[versió en valencià disponible] (2010-2011)

At the official and common Poliforma-t intranet page, more information can be found (in Spanish)

SYLLABUS:

LECTURES

1. Introduction to databases.
2. The relational data model.
3. Database Management Systems.

LABORATORY

1. Introduction to a relational database.
2. Representation of reality within the relational data model.
3. SQL.
4. Study of a DBMS.

Lecture Notes

PDF: Use Adobe Acrobat Reader to visualise them. If you don't want to print one slide per page, you can just print the original PDF to Distiller/PDF Writer again, specifying 4 slides per page.

LECTURES

Presentation (PDF)
Unit 1. Introduction to Databases (PDF)
Unit 2. The Relational Data Model

2a: (PDF)
2b: (PDF)
2c: (PDF)
2d: (PDF)

Unit 3. Database Management Systems.

3: (PDF)
Self-study document for Section 3.5. Physical Organisation (PDF)

THEORY EXERCISES:

Questions From Previous Exams (Questions) (Solutions)

LABORATORY:

Lab Guide for Practical Unit 1 (one session): (For Office XP: here) (For Office 2007: here) Some slides: here.
Lab Guide for Practical Unit 2 (one session): here . Some slides: here.
Lab Guide for Practical Unit 3a (six sessions approx.): here. Slides (part A), Slides (part B)

(Ms Access databases, cyclism, music, library, downloadable here):
Some slides on SQL: BASIC QUERIES: here MORE COMPLEX QUERIES: here.

Lab Guide for Practical Unit 3b (two sessions approx.) here. Some slides: here (solution for the database schema). COMPLETE SOLUTION WITH TRIGGERS.
Lab Guide for Practical Unit 4 (one session approx.): here. Some slides: here.

Other material:

Guide to solve complex SQL Queries.(PDF) (4x1 PDF)

Exams:

Previous Exams in English:

June 2004: (PDF) (2x1 PDF)
September 2004: (PDF) (2x1 PDF)
June 2005: (PDF) (2x1 PDF)
September 2005: (PDF) (2x1 PDF)
June 2006: (PDF)
September 2006: (PDF)
June 2007: (PDF)
September 2007: (PDF)
June 2008: (PDF)
September 2008: (There was no translation into English. Please check the Poliforma't website for a version in Spanish)
June 2009: (PDF)
September 2009: (PDF). For solutions (Spanish), check in the Poliformat
June 2010: (PDF)
September 2010: (PDF)
June 2011: (PDF)

Official document on the SQL syntax that can be carried and kept on the table during the exam: SQLsyntax.

Software Available to do the Lab work at home

Apart from Microsoft Access, if you have it, for which we propose the following databases (check also the microweb), we offer the following software packages as an alternative to do part of the lab work (the SQL queries, mainly):

ConsulWin (specific environment for performing SQL queries with the lab exercises embedded) (in Spanish):

          Includes the exercises wording and the databases "Ciclismo", "Musica" and "Biblioteca".
          Corrects the solutions given by the student.
        The correction is by the extension of the query result. Consequently, the corrector only detects incorrections, but some incorrect queries may not be detected.
          Works for Windows.