====== Lab #3 :: Week of 08/11/2021 ======

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

===== Goals =====

By the end of this class, the student should be able to:
  * Develop the conceptual data model using a UML class diagram.
  * Identify additional business rules.
  * Setup a local development environment using PostgreSQL and pgAdmin.
  * Setup a connection to the production PostgreSQL server.

===== Tasks =====

  * Obtain the conceptual data model (UML class diagram without methods).
  * Identify additional business rules (i.e. rules not included in the model).

  * Start the EBD component in the wiki using the [[https://git.fe.up.pt/lbaw/components/-/wikis/ebd|EBD template]]
  * Copy the EBD tabs (EBD, A4, A5, A6) from the [[https://docs.google.com/spreadsheets/d/14yj904W4QGnwpVw-zo2ijc3Y_2IBR6rkcZVl7HVj-j4|Reference Checklist]]

  * Understand the data persistence setup adopted reading the documentation at [[https://web.fe.up.pt/~ssn/wiki/teach/lbaw/202122/tools#postgresql_for_data_persistence|Computational Resources > PostgreSQL for Data Persistence]]
  * Setup and test the connection to the production database server at [[http://db.fe.up.pt|db.fe.up.pt]]

===== Materials =====

  * Database Specification Component
    * [[..:artefacts:index#ii_database_specification_ebd_25|EBD Component]] | [[https://git.fe.up.pt/lbaw/components/-/wikis/ebd|EBD Template]]
    * [[..:artefacts:a04|A4. Conceptual Data Model]]

  * MediaLibrary Example
    * [[https://docs.google.com/document/d/e/2PACX-1vTg0tTMbIv94ZWzbsPLymv4a3ji6JTucfPAWVOdKIIlHH9A9KwkreYupmzXZfHiiQS_dTjeTDRhzBR3/pub|A4. Conceptual Data Model]]
    * [[https://docs.google.com/document/d/e/2PACX-1vTDVn_kO0Um8mJCgihvcCr8e6UuIHAUQIQjszZt7eIVcrMuRp6XWAgPSBICviYpOgfWZacSFEKDojXR/pub|A5. Relational Schema, Validation and Schema Refinement]]

  * 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]]


  * [[https://web.fe.up.pt/~ssn/wiki/teach/lbaw/202122/tools#postgresql_for_data_persistence|Computational Resources > PostgreSQL for Data Persistence]]
  * [[https://git.fe.up.pt/lbaw/template-postgresql|Template PostgreSQL]]
===== Summary =====

  * Start the development of the Database Specification (EBD) component.
  * Develop and discuss the conceptual data model (A4. Conceptual Data Model).
  * Setup the local development environment for PostgreSQL.
  * Setup and test the connection to the production PostgreSQL server.

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