📅 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.