Databases

Objectives

Introduce the fundamental concepts inherent in relational databases including data modeling - the conceptual point of view and from a physical standpoint, standardization, optimization of queries, data integrity and transaction management, aimed at supporting the development of transactional systems. This course places great emphasis on a theoretical framework coupled with the fact that providing extensive practical experience grounded in the use of relational DBMSs such as Microsoft SQL Server and data modeling tools such as Sybase Power Designer tool knowledge.

General characterization

Code

100012

Credits

6.0

Responsible teacher

Jorge Nelson Gouveia de Sousa Neves

Hours

Weekly - Available soon

Total - Available soon

Teaching language

Portuguese. If there are Erasmus students, classes will be taught in English

Prerequisites

Basic knowledge of information systems.

Bibliography

Abraham Silberschatz, Henry F. Korth and S. Sudarshan, Database System Concepts - 6th ed., McGraw-hill, 2011

Thomas M. Connolly and Carolyn E. Begg, Database Systems: a Practical Approach to Design, Implementation, and Management, Addison-Wesley, Pearce Education Limited, 2010

Luis Damas, SQL Structured Query Language - 13ª Edição, FCA, 2005

Teaching method

Oral presentation of theoretical subjects.
Practical project (groupwork).
Practical exercices in practical classes.

Evaluation method

Continuous

  • Crash Course SQL (10%)
  • Quizz (10%)
  • Project with presentation (40%), minimal grade 8.
  • Written examination 1st Period (40%), minimal grade 8.

Non-continuous

  • Written examination 2nd Period (100%), minimal grade 10.

Subject matter

1: Introduction to database design

2: Introduction to SQL. Crash Course SQL

3: Entity-Relationship Model

4: Relational Model. Transformation Conceptual - Logical - Physical. 

5: Normalization. Functional dependency and other fundamental concepts.

6: Normalization. 1NF, 2NF, 3NF. Boyce-Codd Normal Form (BCNF). 

7: SQL Language. DDL and DML Statements.

8: Advanced SQL.

9: Views and Indices.

10: Restrictions, Triggers and Transactions.

Programs

Programs where the course is taught: