📅 2023-11-15 — Session: Developed Database Schema for Academic Management
🕒 14:15–17:56
🏷️ Labels: Database Design, Academic Management, Schema, DBML, Er Diagram
📂 Project: Dev
⭐ Priority: MEDIUM
Session Goal
The goal of this session was to design and refine a database schema for academic management, focusing on the relationships and structures needed to support educational and research activities.
Key Activities
- Explored the structuring of objects in relational databases, focusing on schema design for shared use across different databases in educational and research contexts.
- Created a relational schema diagram for academic management, detailing connections between entities such as teachers, students, courses, and scientific publications.
- Developed an ER diagram using Graphviz to visually represent relationships in the academic management database.
- Packaged a database schema using DBML, including entities like students, teachers, departments, courses, and research groups, and their relationships.
- Revised the database schema to correct relationship errors and ensure proper many-to-many relationships.
Achievements
- Successfully developed and refined a comprehensive database schema for academic management, ensuring accurate representation of entities and relationships.
Pending Tasks
- Further validation of the database schema with real-world data scenarios to ensure robustness and adaptability.
Additional Context
This session also involved planning and documentation for data management, including developing a data management plan and establishing protocols for deadline extensions.