Base Knowledge
NA
Teaching Methodologies
The following teaching methodologies are used in this curricular unit:
1 – Expository method: an explanatory method were theoretical foundations and concepts are presented by theteacher 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 problemsolving and project development, individually and in group dynamics.
Learning Results
It is expected that by the end of the course each student is entitled to:
1. Understand the basic concepts on relational databases: relational model, integrity, normalization, and relationaloperations;
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.
Program
1. Introduction to databases and basic concepts (data models; entities and abstraction; cardinality; relational datamodel; attributes; primary keys and foreign keys; referential integrity; functional dependency);
2. Relational operations and SQL basic concepts (SQL language; relational operations, data types; integrityrestrictions; 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- Coddnormal form; rules for functional dependencies);
5. Database Project (Entity-Relationship diagrams; degrees of participation; binary relationship).
Grading Methods
- - one group project (25%) - 25.0%
- - three individual assignments (weighting 25% each) - 75.0%
- - one individual project (50%) - 50.0%
- - one individual written examination (50% - 50.0%
Internship(s)
NAO
Bibliography
“Database Management Systems”; Raghu Ramakrishnan, Johannes Gehrke; McGraw-Hill; ISBN: 0072465638; 2003
“Fundamentos de Bases de Dados”; Feliz Gouveia; FCA; 2014
“SQL – Structured Query Language”, 14.a Edição; Luís Manuel Dias Damas; FCA; ISBN: 9789727228294; 2017
“SQL: The Complete Reference”, 2.a Edição; James R. Groff, Paul N. Weinberg, Lyssa Wald; McGraw-Hill Osborne
Media; ISBN: 0071592555; 2009