Database

The following teaching methodologies are used in this curricular unit:

1 – Expository method: an explanatory method were theoretical foundations and concepts are presented by the teacher and discussed with the class, followed by demonstrative examples;

2 – Experimental method: an active method were the student develops the knowledge through the use of problem solving and project development, individually and  in group dynamics.

Regarding the evaluation, the following methods are used:

1 – Periodic Evaluation: a) three individual assignments (weighting 25% each); b) one project (individual or group) with presentation (25%);

2 – Final Evaluation: a) one individual written examination (50%); b) one individual project with presentation (50%).

Students must achieve at least 40% on each individual evaluation component. 

It is expected that by the end of the course each student is entitled to:

1. Identify the basic concepts on relational databases: relational model, integrity, normalization, and relational operations;

2. Manipulate databases through Standard Query Language;

3. Conceive a transactional project;

4. Project, conceive and implement databases using the entity-relationship model;

5. Plan, develop and maintain a database application.

1. Introduction to databases and basic concepts (data models; entities and abstraction; cardinality; relational data model; attributes; primary keys and foreign keys; referential integrity; functional dependency);

2. Relational operations and SQL basic concepts (SQL language; relational operations, data types; integrity restrictions; data definition language, data manipulation language; views; security; schemes definition and data manipulation through SQL);

3. Transactions and concurrency control (transactions, savepoints, rollback segments; commits; concurrency; blockage; deadlock);

4. Functional dependencies and normalization (databases project; 1st, 2nd and 3rd normal form; Boyce-Codd normal form; rules for functional dependencies);

5. Database Project (Entity-Relationship diagrams; degrees of participation; binary relationship).

• - Prova Escrita - 30.0%
• - Projecto - 70.0%

• - Trabalho Prático 1 + 2 - 50.0%
• - Projecto Final - 25.0%
• - Trabalho Pratico 3 - 25.0%

NAO

“Database Systems: The Complete Book”; Hector Garcia-Molina; Prentice Hall; ISBN: 933251867X; 2014

“Fundamentos de Bases de Dados”; Feliz Gouveia; FCA; 2014

“SQL – Structured Query Language”, 14.ª Edição; Luís Manuel Dias Damas; FCA; ISBN: 9789727228294; 2017

“SQL in 10 Minutes, Sams Teach Yourself, 4.ª Edicação; Ben Forta; Sams Publishing; 0672336073; 2012”

“Database Management Systems”; Raghu Ramakrishnan, Johannes Gehrke; McGraw-Hill; ISBN: 0072465638; 2003 (Bibliografia Complementar)