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
4. Database languages (SQL)
4.1. Data Definition Language (DDL)
4.2. Data Manipulation Language(DML)
4.3. Functions and Routines
5. Control and data protection
5.1. Transaction Processing
5.2. Security mechanisms
5.3. Concurrency control

Teaching Methodologies

In theoretical classes is used the expository and demonstrative method, with the use of visual aids and examples. In practical classes, a constructivist methodology is applied, where under the guidance of the teacher, and using a script and an open-source database management system, the contents lected in theoretical classes are worked. This allows the students to work independently, but supervised, and seize and consolidate the fundamental concepts related to the design, construction and management of databases, with user management and protection and data security operations. In screenplays work available is given special emphasis on constructing queries that allow manage and extract information.

All supporting materials are available at Moodle.

Bibliography

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

(Site de apoio 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