📅 2023-11-15 — Session: Developed and Revised Database Schemas for Academic Management
🕒 14:15–17:56
🏷️ Labels: Database Design, Academic Management, Data Management, Er Diagram, DBML, Graphviz
📂 Project: Teaching
⭐ Priority: MEDIUM
Session Goal
The session aimed to explore and refine database schema designs for academic management systems, focusing on relational database structures and object sharing across multiple databases.
Key Activities
- Estructuración y Compartición de Objetos: Explored structuring objects in relational databases for shared use, relevant in educational and research contexts.
- Esquema de Relaciones: Designed relational schemas for academic management using entity relationships, focusing on connections between teachers, students, courses, and publications.
- Diagrama ER Creation: Developed an Entity-Relationship diagram using Graphviz to visualize academic management relationships.
- Schema Refinement: Revised database schemas using DBML, correcting relationship errors and ensuring accurate many-to-many mappings.
- Data Management Planning: Drafted guidelines and revised articles for a Data Management Plan (PMD) working group, focusing on requirements, access policies, and collaboration protocols.
Achievements
- Completed the creation and refinement of database schemas for academic management.
- Developed comprehensive guidelines for a Data Management Plan, including roles and protocols for deadline extensions.
Pending Tasks
- Further review and testing of the revised database schema to ensure all academic management needs are met.
- Implementation of the Data Management Plan guidelines and protocols in the relevant academic departments.