====== Lecture #3 :: 08/11/2021 ======

{{page>..:header&nofooter}}

===== Goals =====

By the end of this class, the student should be able to:
  * Obtain the conceptual data model
  * Obtain the relational schema from the conceptual data model
  * Validate the relational schema using the database normalization
  * Connect to the production PostgreSQL server
  * Setup a local PostgreSQL development environment


===== Content =====

  * Database Specification
    * Conceptual Data Model | Relational Schema | Schema Validation and Refinement
  * Artefacts
    * A4. Conceptual Data Model
    * A5. Relational Schema, Validation and Schema Refinement
  * PostgreSQL
    * Overview | LBAW Computational Requirements | PostgreSQL at FEUP | pgAdmin

===== Materials =====

  * Materials presented in class:
    * {{lbaw2122-03-database-specification.pdf|Database Specification}} (slides)
  * [[..:artefacts:index#ii_database_specification_ebd_25|EBD Component]]
  * [[..:tools|LBAW Computational requirements]]
  * {{uml2rel.eng.pdf|Summary of Mapping Rules from Logical UML Models to Relational Schemas}} ({{uml2rel.pdf|PT}})

  * Scott W. Ambler, [[http://www.agilemodeling.com/artifacts/classDiagram.htm|UML 2 Class Diagrams: An Agile Introduction]]
  * [[https://www.uml-diagrams.org/class-diagrams-overview.html|UML Class and Object Diagrams Overview]]

  * PostgreSQL, https://www.postgresql.org
  * pgAdmin, https://www.pgadmin.org

===== Summary =====

  * Database Specification (EBD) Component.
  * Artefact A4 (Conceptual Data Model).
  * Artefact A5 (Relational Schema, Validation and Schema Refinement).
  * Overview of PostgreSQL relational database management system.

[[02|« Previous]] | [[index|Index]] | [[04|Next »]]