Introduzir conceitos associados a sistemas de base de dados, abordando os modelos mais utilizados atualmente; Explorar um gestor de bases de dados relacional open-source (MySQL);
Modelar, desenhar e implementar uma base de dados relacional em linguagem SQL.
Learning outcomes of the curricular unit:
1. Understand theoretical concepts about database systems.
2. Know how to model, design and implement a relational database.
3. Know how to install, configure and administer a relational database management system;
4. Know how to extract information from a relational database management system.
Syllabus
1. Historical perspective and evolution of database management systems
2. Architecture of a database management system.
3. The Relational Data Model:
3.1. Relational model of data and diagram entity relation
3.2. Integrity and Standardization
4. Database languages
4.1. Data Definition Subdomain (LDD)
4.2. Data Manipulation Sub-Language (DML)
4.3. Data Control Sub-menu (LCD)
4.4. Functions and Routines
Demonstration of the syllabus coherence with the curricular unit:
Sections 1 and 2 of the syllabus provide the essentials needed to achieve the goal 1. Section 3 provides the essential learning
to achieve the goal 2, as well as more abstract perspective of goal 4. Topics 4 and 5 are intended to provide the
knowledge to reach goal 3 and 4, from a concrete perspective of the applicational language (SQL).
In the theoretical classes the expository and demonstrative method is used, using audiovisual resources and examples.
In the practical classes, a constructive methodology is applied, where, under the guidance of the teacher and using a working script and an open-source database manager, the contents are trained, thus allowing students to work autonomously but with supervision, to grasp and consolidate the fundamental concepts concerning the design, construction and management of relational databases.
In the work script is given special attention to the design of the database and to the construction of queries that allow to manage and extract information. All the support materials are available in Moodle (slides, worksheets and work guides, useful links).
Mandatory:
F. Gouveia, Fundamentos de Bases de Dados, FCA - Editora de Informática, 2014
Silberschatz, et al., Database system concepts, 6th ed. McGraw-Hill, 2011 (Site de apoio http://db-book.com)
Optional:
L. Damas, SQL, 14a ed. FCA - Editora de Informática, 2017
J. Pereira, Tecnologia de Bases de Dados, 3a ed., FCA - Editora de Informática, 1998
Elmasri, R. et al., Fundamentals of Databases Systems, 6nd ed. Addison-Wesley, 2011
Russell, J.T.D., MySQL in a Nutshell, 2nd ed. O’Reilly, 2008
0000304
6