Developed and Revised Database Schemas for Academic Management

• Day: 2023-11-15
• Time: 14:15 to 17:56
• Project: Teaching
• Workspace: WP 1: Strategic / Growth & Development
• Status: Completed
• Priority: MEDIUM
• Assignee: Matías Nehuen Iglesias
• Tags: Database Design, Academic Management, Data Management, Er Diagram, DBML, Graphviz

Description

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.

Evidence

• source_file=2023-11-15.sessions.jsonl, line_number=0, event_count=0, session_id=845dc2e2a952f8809ae6a57ca243ff1a029f2e73c511ad92d68af72fbc54eab5
• event_ids: []