SQL Projects
Leveraging SQL to extract, analyze, and visualize insights from complex datasets.
Hospital Management Database
A comprehensive SQL database for hospital management with tables for patients, doctors, appointments, and medical histories.
View Code
Student Database Management
A comprehensive student management database system with tables for students, teachers, parents, classes, and subjects with proper relationships.
View Code
Hospital Management Database
• Database Purpose:
The SQL script creates a database for hospital management, focusing on patients, doctors, appointments, and medical histories.
• Entity Relationships:
Relationships are established through foreign keys, linking patients to appointments, medical histories, and doctors to schedules and diagnoses.
• Data Integrity:
Primary keys and foreign keys are used to maintain data consistency and enforce relational integrity across the database tables.
Student Database Management
• Database Structure:
Creates a student_management schema to organize tables for managing student, teacher, parent, and class data, ensuring a clean setup by dropping existing schema if present.
• Core Entities:
Includes tables for user_login, parent_details, teachers, class_details, student_details, subject, and subject_tutors, capturing essential attributes like IDs, names, and contact details.
• Relationships and Integrity:
Uses foreign keys to link students to classes and parents, subjects to teachers and classes, and ensures data consistency with primary keys and unique constraints.