By the end of this class, the student should be able to: ¶

• Identify and create constraints needed to verify the business rules ¶
• Estimate the expected database workload ¶
• Develop the database physical schema ¶
• Identify the database transactions ¶
• Create and populate a PostgreSQL database ¶

• Present the artefact A5 (Relational Schema, Validation and Schema Refinement) ¶
• Identify and create constraints needed to verify the business rules, including triggers ¶
• Estimate the expected database workload ¶
• Identify and justify the creation of indexes ¶
• Identify and characterize the necessary database transactions ¶
• Create the database using PostgreSQL (locally and at the production server - db.fe.up.pt) ¶
• Populate the database with plausible data and with sufficient number of tuples for testing purposes ¶

• Database Specification Component ¶
  • EBD Component | EBD Template (GitLab Wiki) ¶
  • A5. Relational Schema, Validation and Schema Refinement ¶
  • A6. Indexes, Triggers, Transactions and Database Population ¶

• MediaLibrary Example ¶
  • A5: Relational Schema, Validation and Schema Refinement  ¶
  • A6. Indexes, Triggers, Transactions and Database Population ¶

• Generate data to populate the database: ¶
  • generatedata.com ¶
  • Spawner Data Generator ¶

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

• Integrity constraints and triggers. ¶
• Database indexes. ¶
• Database transactions. ¶
• Create and populate the database. ¶

« Previous | Index | Next » ¶