Databases 1

Recommended Prerequisites

NA

Teaching Methods

This course unit is structured in 3 hours of theoretical-practical lessons per week. Some practical exercises will be proposed during the classes for interacting with databases in particular contexts, for instance, to perform queries in SQL.

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 of Databases 2 and Advanced Programming in Java. The objectives include familiarizing students with the basic principles of database management systems (DBMS), such as data modeling, database design, and querying with SQL. Moreover, the course aims to equip students with practical skills in designing relational databases, implementing database schemas, and performing common database operations.

Work Placement(s)

No

Syllabus

• Introduction to databases

• Relational model

• SQL

• Entity-relational model 

Head Lecturer(s)

Carlos Nuno Bizarro e Silva Laranjeiro

Assessment Methods

Final Assessment
Test: 100.0%

Bibliography

A. Silberschatz, H. F. Korth, S. Sudarshan, Database System Concepts, 7th Edition, McGraw Hill Education, 2019

C. Coronel, S. Morris, Database Systems: Design, Implementation, and Management, 12th Edition, Cengage Learning, 2017

H. Garcia-Molina, J.D. Ullman, J. D. Widom, Database Systems: The Complete Book, 2nd Edition, Pearson; 2008

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