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. ¶

• 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 EBD template ¶
• Copy the EBD tabs (EBD, A4, A5, A6) from the Reference Checklist ¶

• Understand the data persistence setup adopted reading the documentation at Computational Resources > PostgreSQL for Data Persistence ¶
• Setup and test the connection to the production database server at db.fe.up.pt ¶

• Database Specification Component ¶
  • EBD Component | EBD Template ¶
  • A4. Conceptual Data Model ¶

• MediaLibrary Example ¶
  • A4. Conceptual Data Model ¶
  • A5. Relational Schema, Validation and Schema Refinement ¶

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

• Computational Resources > PostgreSQL for Data Persistence ¶
• Template PostgreSQL ¶

• 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. ¶

« Previous | Index | Next » ¶