📅 2024-12-16 — Session: Database Schema Design for Individualized Study Plans

🕒 09:45–11:25
🏷️ Labels: Data Architecture, Database Design, PEI, DBML, SQL
📂 Project: Dev
⭐ Priority: MEDIUM

Session Goal

The session aimed to design and refine a database schema for managing Individualized Study Plans (PEIs), focusing on scalability, normalization, and data consistency.

Key Activities

  • Analyzed and designed a data schema for PEIs, outlining necessary tables and relationships.
  • Created technical documentation detailing requirements, models, specifications, and procedures for implementing the schema.
  • Developed a DBML schema for managing PEIs, including tables for students, tutors, and subjects.
  • Addressed duplication issues in DBML relationships and proposed solutions with code examples.
  • Emphasized the use of technical and descriptive names in database systems for better accessibility.
  • Provided a DDL block for the Estudiantes_Tutores table, including improvements for managing PEI IDs with versions.
  • Discussed data redundancy and normalization principles in database design.
  • Delivered DDL for PEI_Materias and Materias tables in DBML format, with necessary indexes and table structure explanations.
  • Defined the structure of the id_pei identifier to ensure uniqueness and traceability.

Achievements

  • Successfully outlined a comprehensive schema for PEIs with considerations for scalability and normalization.
  • Resolved key duplication issues and improved database design practices.

Pending Tasks

  • Further testing and validation of the schema in a live environment.
  • Implementation of the schema in the production database.

Tags

  • Data Architecture, Database Design, PEI, DBML, SQL