|Curricular Unit (UC)||
Course category: B - Basic; C - Core Engineering; E - Specialization; P - Complementary.
|Year: 2nd||Semester: 1st||ECTS: 4.5||Total Hours: 115|
|Contact Hours||T:||TP: 45||PL:||S:||OT:2|
|Professor in charge||
Porfírio Pena Filipe
T - Lectures; TP - Theory and practice; PL - Lab Work; S - Seminar; OT - Tutorial Guidance.
- Learning outcomes of the curricular unit
1. Understand the principles underlying the design of information systems.
2. Know the main characteristics of data repositories.
3. Design data models and implement the respective data repositories.
4. Use databases management systems in developing information systems.
1. Introduction to database management systems.
2. Design and implementation of relational databases.
3. Conceptual model, logical model, and physical model.
4. The SQL language for defining and manipulating data.
5. Infrastructure and data access architectures.
6. Apply the acquired knowledge in developing applications.
- Demonstration of the syllabus coherence with the curricular unit's objectives
This curricular unit deals with the issue of information systems and aiming to facilitate the understanding and identification of key characteristics. In detail are addressed data modeling aspects at conceptual, logical and physical level. The development of applications reinforces the acquired knowledge.
- Teaching methodologies (including evaluation)
The teaching methodology is developed in two components:
45.0 hours of theoretical and practical: For each theme, theoretical examples are presented and solved exercises;
22.5 contact hours of laboratory practice: Theoretical concepts are consolidated in laboratorial classes by implementing exercises performed by the group.
Learning outcomes are assessed through a written exam and practical work, with clearly defined delivery dates for the reports, implemented and evaluated in a group (with individual grade) in a final discussion.
- Demonstration of the coherence between the teaching methodologies and the learning outcomes
In classes is given the syllabus corresponding to the learning outcomes (1) and (3). Some examples are presented and solved exercises.
In laboratorial classes is intended that students anticipate solutions, for this, a laboratorial guide is provided in advance. Taking into account compliance with learning outcome 4, the solutions proposed by students are discussed in the class.
In the final discussion is assessed the work, performed autonomously by the group, with particular attention to the reports, taking the opportunity to highlight aspects manifested in learning outcomes (1) to (4) that are considered opportunely relevant.
- Main Bibliography
F Sebesta R, Programming the World Wide Web, Addison-Wesley, ISBN 10 0-13-213081-5, 2010.
Pereira J, Tecnologia de Base de Dados, FCA – Editora Informática, ISBN 978-972-722-143-1, 2010.
Sousa A, Bases de Dados, Web e XML, FCA – Editora Informática, ISBN 978-972-722-321-3, 2010.
Ramakrishnan R, Gehrke J., Database Management Systems, McGraw-Hill, ISBN 0-07-246563-8, 2002.