📅 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