A tool to support the relational database design process for INFO0009 [C. Debruyne]

Current Entity-Relationship Diagramming (ERD) tools often blur the lines between conceptual, logical, and physical database design, leading to diagrams that are overloaded with detail and fail to communicate the concepts of the data model effectively. This conflation of design levels hinders effective communication between stakeholders, complicates model evolution, and can lead to inconsistencies between the intended design and the final database implementation. This thesis aims to develop a tool that supports the conceptual design of the ER model, respecting the principles and notation used in INFO0009 and its transformation into the logical model, the relational model, and any adequate visualizations thereof. Ideally, the student can also support (some) aspects of the physical design. The student will have an opportunity to validate their tool in INFO0009 provided the implementation for the conceptual design is sufficiently advanced.