CREATE TABLE Admins(
Admin_i.d INT(10) PRIMARY KEY,
Name VARCHAR(50),
Duty VARCHAR(100),
Email VARCHAR(100)
);
CREATE TABLE Doctors(
Doctor_i.d INT(10) PRIMARY KEY,
Department VARCHAR(100),
Name VARCHAR(50),
Speciality VARCHAR(100),
Phone VARCHAR(100)
);
CREATE TABLE Patients(
Patient_id INT(10) PRIMARY KEY,
Disease VARCHAR(50),
Admit_date DATETIME,
Gender vARCHAR(15),
Age INT(5)
);
INSERT INTO Admins VALUES
(101,'Ali','Oversees all departments','ali_12345@gmail.com'),
(102,'Faizan','Reports to the hospital board','faizan__@gamil.com'),
(103,'Yashfa','Hiring and onboarding','yashfa_122@gamil.com');
INSERT INTO Doctors VALUES
(501,'Cardiology Department','Saad','Cardiologist','032556699756'),
(502,'Pulmonology','Aaliyan','Chest Physician','03225586974'),
(503,'Orthopedics Department','Saba','bOrthopedic Surgeon','03265658554');
INSERT INTO Patients VALUES
(1,'Heart attack','2025-06-03','F',52),
(2,'lung cancer','2025-07-08','M',68),
(3,'back pain','2025-08-01','F',35);
SELECT*FROM Admins;
SELECT*FROM Doctors;
SELECT*FROM Patients;
Telegram: DB developers channel