INFORMATICS PRACTICES PROJECT
Synopsis
Title of the project:
Hospital Records
Contribution:
The project “Hospital Records” is developed by Mr .Haron Varughese , It took
approx 30 days to develop this project.
Objective:
To develop a structured database system that collects, organizes, and manages all
essential information related to hospitals, such as departments, doctors, patients,
appointments, and facilities. The goal is to simplify data retrieval and enhance
decision-making through well-organized relational tables and SQL queries.
Reason for Choosing the Topic:
The healthcare sector handles vast amounts of critical information every day,
including patient records, doctor schedules, hospital facilities, and appointments.
Managing this data manually or through unstructured systems can lead to
confusion, errors, and inefficiency.
I chose the topic "Hospital Information Management System using SQL"
because it addresses these real-world challenges by providing a structured, reliable,
and organized way to store and access hospital-related information.
This project helps:
Understand the practical application of SQL and relational databases.
Improve data organization and retrieval in healthcare.
Simulate a real-life system that can be scaled or extended in the future.
In short, this topic not only strengthens my technical skills but also demonstrates
how technology can be used to improve critical services like healthcare .
Software Used:
MySQL or SQLite (for database creation and management)
Python (optional, for GUI or scripting)
DB Browser or phpMyAdmin (for visual interface)
Database Design:
The project will consist of the following tables:
1. Hospital
Hospital_ID (Primary Key)
Name
Address
Contact_Number
Type (e.g., Private/Public)
2. Department
Dept_ID (Primary Key)
Dept_Name
Hospital_ID (Foreign Key)
3. Doctor
Doctor_ID (Primary Key)
Name
Specialty
Dept_ID (Foreign Key)
Contact_Number
4. Patient
Patient_ID (Primary Key)
Name
Gender
Age
Contact_Number
Address
5. Appointment
Appointment_ID (Primary Key)
Patient_ID (Foreign Key)
Doctor_ID (Foreign Key)
Date
Time
Status (e.g., Scheduled, Completed)
Key Features:
Relational database design for integrity and efficiency
Use of SQL queries for CRUD operations (Create, Read, Update, Delete)
Data analysis through SELECT queries, joins, filters, and grouping
Expected Outcomes:
A fully functional hospital management database
Easy navigation of hospital data using SQL
Enhanced understanding of relational databases and data handling
References/ Bibiliography:
Informatics practices –SUMITA ARORA
MYSQL 8.0 command line client
Conclusion:
This project will demonstrate practical knowledge of SQL and relational database
design by efficiently organizing hospital-related data. It provides a scalable
solution for managing medical information, benefiting hospital administrators,
staff, and patients.
