1) R. Ramakrishnan and J. Gehrke, Database Management Systems, McGraw-Hill, 3th Edition, 2007.
2) Feliz Gouveia, Fundamentos de Bases de Dados, FCA, 2014.
1) José Luís Pereira, Tecnologias de Bases de Dados, FCA - Editora de Informática, 3ª Edição.
2) Edward Whalen, Marcilina Garcia, Burzin Patel, Stacia Miscer and Victor Isakov, Microsoft SQL Server 2005 - Administrator''s Companion, Microsoft Press, 2007.
3) T. Connoly and C. Begg, Database Systems: A Practical Approach to Design, Implementation, and Management, Pearson, 6th Eition, 2014.
4) G. Simsion, Data Modeling Essentials, Van Nostrand Reinhold, 1994.
5) R. Riordan, Designing Relational Database Systems, Redmond, 2001.
6) J. Gray and A. Reuter, Transaction Processing: Concepts and Techniques, Morgan Kaufmann, 1993.
7) J. Dunham, Database Performance Tunning Handbook, McGraw-Hill,1998.
8) W. Inmon, Building the Data Warehouse, Wiley & Sons, 1996.
Teaching Methodologies and Assessment Criteria
The contents of this Course Unit are discussed in lecture classes and the practical part of those contents is explored in laboratory classes. Each type of class has two hours of weekly contact. The practical classes have lab guides that students perform in the computers of the lab, which include the usage of several technologies provided by nowadays database management systems, as well as the implementation of database web applications. Moreover, the proposed practical works (individual and group) are designed so that the students develop their technical skills via the development of software applications.
- Practical (10 points): 2 works (4.0 + 4.5) and student participation (1.5)
- Test: 7.5 points
- Theme (2.5 points). Evaluation: 50% teacher, 50% students.
Exam (test): 10 points.