Databases

Recommended Prerequisites

Not applicable.

Teaching Methods

This course unit is structured in 2 hours of lectures per week and 1 hour of labs. Some practical exercises will be proposed during the classes for interacting with databases in particular contexts, for instance, to perform queries in SQL. The assessment consists of one exam (100%). In case of a negative grade in the exam (less than 9.5), the student is allowed to perform a second exam. The grade obtained in this second exam will replace the grade obtained in the first exam. The exam is a final and individual assessment moment.

Learning Outcomes

To acquire basic knowledge about the working principles of databases. This course unit provides complementary knowledge that is needed for the enrolment in the course unit Advanced Programming in Java. General skills that will be acquired at the end of the course are analysis and synthesis ability; organization and planning skills; problem solving and teamwork skills; autonomous learning; adapt to new situations; creativity; focus on quality and sustainable development.

Work Placement(s)

No

Syllabus

• Introduction to databases

• Relational model

• SQL

• Entity-relational model

• DBMS arquitecture. 

Head Lecturer(s)

João Rodrigues de Campos

Assessment Methods

Assessment
Exam: 100.0%

Bibliography

H. Garcia-Molina, J.D. Ullman, J. D. Widom, Database Systems: The Complete Book, Prentice Hall; 2001;

R. Ramakrishnan, J. Gehrke, Database Management Systems, McGraw-Hill, 2002.