ISMAT 1792

Databases

• ApresentaçãoPresentation

  Databases are part of Information Systems and are used in most computer applications we use daily. Additionally, the value we attribute to data is increasing and decisions are increasingly driven by the analysis of stored data. The Database course unit aims to provide the student with the fundamental knowledge of how to store data in a structured, non-redundant manner and perform data processing to obtain information. Understanding these concepts allows us to define how to structure data in order to guide the development of an application. This course is fundamental in the study cycle and is complemented by the course Web Programming, in which a web application consisting of a database is developed.
• ProgramaProgramme

  S1. Introduction to Databases S2. Conceptual Model of Databases 1. Entity and Association Model  Diagrams Multiplicity N-Aria associations and roles in association  Hierarchy Weak entities Restrictions 2. UML diagram Notations Rules for converting EA model to UML diagram  S3. Relational Model Distinction between Table and Relationship  Conversion of EA model to relational model  Functional Dependencies (FD) Keys and super keys FD projection  Normalization Anomalies Boyce Codd Normal Form (BCNF)  3rd Normal Form Multi-Value Dependencies 4th Normal Form S4. Relational Algebra Set Operations Row and column removal Cartesian Products and Joins  Extended Relational Algebra S5. SQL language DB Scheme Select, Insert, and Update Operations  Joins and set operations Sub Queries Aggregations Views Indexes Authorization  Restrictions Stored Procedures Triggers  S6. Transactions S7. Conventional SQL Programming
• ObjectivosObjectives

  LO1. Understand and know how to distinguish the concepts of Database (DB) and Database Management System (DBMS). LO2. Perform data analysis and modeling using Entity-Association and UML models. LO3. Know how to convert Entity-Association model diagrams to UML diagrams and vice versa. LO4. Know how to convert the conceptual model to the relational model. LO5. Know how to define the schema of a relational database. LO6. Understand relational algebra and the theory of relationship normalization. LO7. Know how to develop routines to insert, update and extract information from a database using the SQL language. LO8. Know how to specify constraints, views, indexes, stored procedures and triggers. LO9. Understand the mechanism of transactions. LO10. Know how to use the Java programming language to make queries to the DB. LO11. Know how to build a database project.
• BibliografiaBibliography

  Ullman, J. & Widom, J. (2015). A First Course in Database Systems. (International Edition). Prentice Hall. ISBN: 9780273769279 Damas, L. M. D. (2017). SQL - Structured Query Language. (14a ed.). Editora FCA. ISBN 9789727228294 Gouveia, F. (2014). Fundamentos de Bases de Dados. Editora FCA. ISBN: 9789727227990 Borges, J. L., Dias, T. & Cunha, J. (2015). Modelação de Dados em UML: Uma Abordagem por Problemas. Editora FCA. ISBN 9789727228126  
• MetodologiaMethodology

  Students use Postgres as their SGDB, which offers advanced and modern functionalities in the Database area. Through a methodology aimed at problem solving and also focused on project development, students consolidate the content acquired.
• LínguaLanguage

  Português
• TipoType

  Semestral
• ECTS

  6
• NaturezaNature

  Mandatory
• EstágioInternship

  Não