Databases I

Objectives

Introduce the fundamental concepts inherent to relational databases, namely data modeling - from a conceptual and from a physical point of view, normalization, query optimization, data integrity and transaction management, aiming to support the development of transactional systems. This curricular unit places great emphasis on a theoretical structuring of knowledge combined with the fact of providing extensive practical experience based on the use of relational DBMSs, namely Microsoft SQL Server and data modeling tools such as Sybase Power Designer.

General characterization

Code

100013

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

Thomas M. Connolly and Carolyn E. Begg, Database Systems: a Practical Approach to Design, Implementation, and Management, Addison-Wesley, Pearce Education Limited, 2010; Abraham Silberschatz, Henry F. Korth and S. Sudarshan, Database System Concepts, McGraw-hill, 2006; Luis Damas, SQL Structured Query Language - 13ª Edição, FCA, 2005; 0; 0

Teaching method

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

Evaluation method

Continuous

  • Project with presentation (40%), minimal grade 8.
  • Midterm exam (20%).
  • 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: Entity-Relationship Model
3: Relational Model. Transformation Conceptual → Logical → Physical. 
4: Normalization. Functional dependency and other fundamental concepts.
5: Normalization. 1NF, 2NF, 3NF. Boyce-Codd Normal Form (BCNF). 
6: Relational Algebra.
7: SQL Language. DDL and DML Statements.
8: Advanced SQL.
9: Views and Indices.
10: Restrictions, Triggers and Transactions.