Databases

Objectives

Introduce theoretical concepts on database systems, addressing the most widely used models.

Designing a database using the entity-relationship diagram and the relational database model.

Understand the concepts related to transactions, and their implementation, and the mechanisms for secure access to data.

Implement and manage a relational database in the language SQL, exploring a relational open source database management system.

Program

1. Introduction to Database Systems

 2. Architecture of a Database System

 3. The relational data model:

 3.1. Data structure

 3.2. The entity-relationship model

 3.3. Integrity and Standards

 3.4 Relational Algebra

 4. Database languages (SQL)

 4.1.  Data Definition Language  (DDL)

 4.2.  Data Manipulation Language(DML)

 4.3. Data Control Language (DCL)

 4.3. Functions and Routines

 5. Control and data protection

 5.1. Transaction Processing

 5.2. Security mechanisms

Teaching Methodologies

In the theoretical classes the expository and demonstrative method is used, with the use of visual aids and examples. In the practical classes, a constructivist methodology is applied, where, under the guidance of the teacher and using a working script and an open-source database manager, the contents are worked out, thus allowing students to work autonomously but supervised, and to grasp and consolidate the fundamental concepts related to the design, construction and management of databases. In the work script is given special attention to the construction of queries that allow to manage and extract information. 

All the support materials are available in Moodle (slides, worksheets and work guides, useful links).

 

Bibliography

-Silberschatz, et al., Database system concepts, 6th ed. McGraw – Hill, 2010 

(Site http://www.cse.iitb.ac.in/~sudarsha/db-book/db5-dir/)

-J. Pereira, Tecnologia de Bases de Dados, 3ª ed., FCA – Editora  de Informática, 1998

-L. Damas,  SQL, 6ª ed. FCA - Editora de Informática, 2000

-Elmasri, R. et al., Fundamentals of Databases Systems, 6nd ed. Addison-Wesley, 2011

-Russell, J.T.D., MySQL in a Nutshell, 2nd ed. O’Reilly, 2008