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 ¶

• 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 presented in class: ¶
  • Database Specification (slides) ¶
• EBD Component ¶
• LBAW Computational requirements ¶
• Summary of Mapping Rules from Logical UML Models to Relational Schemas (PT) ¶

• Scott W. Ambler, UML 2 Class Diagrams: An Agile Introduction ¶
• UML Class and Object Diagrams Overview ¶

• PostgreSQL, https://www.postgresql.org ¶
• pgAdmin, https://www.pgadmin.org ¶

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

« Previous | Index | Next » ¶