Database Schema - SubarnaSaha08/JUMCMS-Jahangirnagar-University-Medical-Center-Management-System GitHub Wiki

Author(s)

Subarna Saha, Sudipta Singha and Hasan Al Mamun

Introduction

The database schema is designed and implemented using SQLite, a lightweight and serverless database engine, integrated within a Django web application. Models representing the main application entities were defined using Django's built-in ORM (Object-Relational Mapping). Django's migration engine was then used to automatically convert these models into a SQLite database structure, enabling smooth database interaction.

Using DbVisualizer, a potent database management and visualization tool, the schema was visualized to aid in the understanding and analysis of the database's structure. The relationships between various tables, the limitations imposed by main and foreign keys, and the general data flow throughout the system were all made clear by this graphic representation.

The application's primary entities, relationships, and constraints are appropriately reflected in the schema, guaranteeing

Graphical representation