Databases

Scholar Year: 2019/2020 - 2S

Courses

Head Teacher Responsability Cláudio Miguel Garcia Loureiro dos Santos Sapateiro Head

Weekly workload Hours/week T TP P PL L TC THE EL OT OT/PL TPL S Type of classes 3 2 Lectures Type Teacher Classes Hours Theorethical and Practical classes Totals 4 12,00 Cláudio Sapateiro   6,00 Prática Laboratorial Totals 1 2,00 João Santos   8,00 Gabriel Pestana   2,00 Novo Docente   2,00

Teaching language

Portuguese

Intended learning outcomes (Knowledges, skills and competencies to be developed by the students)

The curricular unit aims to provide students with the following skills:
- definition of normalized relational databases;
- explore the RDBMS capabilities;
- development of web interfaces for database access.

Syllabus

1 – Relational Database Management Systems: Introduction and objectives. Application development in RDBMS
2 – Information analysis and representation: Entity Relationship Model.
3 – Relational Model.
4 -Transformation rules of the entity relationship model in the relational model. Normalization and restrictions.
5 - SQL
- The Data Definition Language (DDL): create and destroy database objects.
- The Data Manipulation Language (DML) : access and manipulate data.
6 - Controlling access to data
- Views.
- Privileges and Roles.
7 - Program. SQL
- Blocks and programming constructs.
- Cursors.
- Exception handling.
- Procedures, functions and packages.
- Triggers.

Software

MySQL Community Edition

MySQL Workbench

Demonstration of the syllabus coherence with the UC intended learning outcomes

In the lectures is exposed the syllabus of theoretical support required to development normalized relational
databases, followed by the presentation of the SQL language and server programming language.

In labs the students must perform a set of exercises in the SGBD environment, in order to validate the
knowledge imparted in the lectures.

Teaching methodologies

The pedagogical methodology used in this curriculum unit is based on two components: lecture method and
group work in laboratory environment.
Will be used an e-learning platform (Moodle) to support teaching, as repository of information, forum, delivery of work and testing of self assessment and summative evaluation.
The evaluation of the discipline consists of making an exam and a practical work developed in group involving
the database scheme definition and its interface.

Demonstration of the teaching methodologies coherence with the curricular unit's intended learning outcomes

The main objectives of this unit are associated with the development of skills to use Database Management
Systems.
To consolidate the material taught in lectures, methods are used for exhibitions and practical work conducted in the laboratory in order to convey to students the essential knowledge to achieve the objectives.
The use of e-learning platform Moodle promotes greater contact between the participating faculty and their
students, either through forums or other activities that stimulate communication between elements (for selfassessment tests, availability of the classes, etc.).

Assessment methodologies and evidences

50%*Test/Exam + 50%Project

Assement and Attendance registers

Primary Bibliography

Secondary Bibliography