Pce21cs178 Vandita Goyal Old Age Home Management System

OLD AGE HOME MANAGEMENT SYSTEM
(SUBMITTED BY: VANDITA GOYAL (PCE21CS178))
PROJECT DESCRIPTION
“Old Age Home Management System Project using MySQL” is an application that provides
an end-to-end smart application for old age people and old age homes. This application is
helpful for old age homes for keeping records of senior citizens who live in the old age home.
Each elderly people assign a registration number through which person’s detail find so easily.
PROJECT FEATURES
1.Employee Management:
 Add, update, and delete employee records.

 Track employee details such as name, address, phone number, age, and jobs.
2.Data Integrity:
 Maintain data integrity through foreign key relationships between tables.
3.Reporting:
 Generate reports for employee details, resident information, jobs details.

 Include features for customizing and filtering reports based on specific criteria.
4.User Interface:
 Develop a user-friendly interface for data entry, modification, and deletion.

 Implement features for easy navigation and accessibility.
5.Security:
 Implement access controls to ensure that only authorized users can add, modify, or
delete data.
 Secure sensitive information such as employee email addresses.
6.Data Insertion and Initialization:

 Include scripts for inserting initial data into tables, facilitating system setup and
testing.
7.Scalability:
 Design the database and queries to handle a growing number of employees and
records.
8.Testing:
 Implement comprehensive testing procedures to ensure the accuracy of calculations

and data integrity.
9.Documentation:
 Provide documentation for the database schema, table relationships, and data insertion
scripts.
 Include user guides for using the payroll management system.
10.Maintenance:
 Develop strategies for system maintenance, including regular updates, backups, and
troubleshooting.
Project Modules
In this project, we use MySQL database. It has two modules, admin and user.
Admin Module
1.Dashboard: In this section, the admin can see all detail in brief like the total number of
services, Total number of senior citizens, total number of unread enquiries received and the
total number of unread enquiries.
2.Pages: In this section, admin can manage about us, contact us pages, rules and eligibility.
3.Services: In this section admin can manage services(add/update/delete).
4.SC( Senior Citizen)Details: In this section, the admin can manage the detail of the senior
citizen(add/update/delete) who lived in an old age home.
5.Enquiry: In this section, admin can read a new enquiry(unread enquiry) and view the read
enquiry(read enquiry).
6.Search: In this section, admin can search senior citizen details with the help of his/her
registration number.
7.Reports: In this section admin can view senior citizen details in particular periods.
8.Changes: Admin can also update his profile, change password and recover password.
User Module
In OAHMS users can do the following activities:->
 Home Page: welcome page of the web Application

 Services: User views the services which offer by the old age home.
 Eligibility: The user views the eligibility criteria for an old age home.
 Rules: The user views the rules for the old age home.
 About Us: The user sees the detail of the old age home.
 Contact Us: The user can contact with old age home.
ER- DIAGRAM
DATABASE
CREATION OF DATABASE
create database PROJECT;
USE OF DATABASE
use database PROJECT;
CREATION OF TABLES
1. HOME
CREATE TABLE Home (
ID INT NOT NULL,
Old_Age_Home_Name VARCHAR(120) DEFAULT NULL,
MobileNumber VARCHAR(120) DEFAULT NULL,
Email VARCHAR(120) DEFAULT NULL
);
2. RESIDENT
CREATE TABLE Resident (
ID INT NOT NULL,
FirstName VARCHAR(200) DEFAULT NULL,
LastName VARCHAR(200) DEFAULT NULL,
Email VARCHAR(200) DEFAULT NULL,
Phone_no VARCHAR(120) DEFAULT NULL,
Room_No INT NOT NULL
);
3. DONOR
CREATE TABLE Donor (
Account_No VARCHAR(120) NOT NULL,
UserName VARCHAR(200) DEFAULT NULL,
Amount INT DEFAULT NULL
);
4. STAFF
CREATE TABLE Staff (
Job_ID INT NOT NULL,
Jobs VARCHAR(100) NOT NULL,
PRIMARY KEY (ID)
);
5. DOCTOR
CREATE TABLE Doctor (
Staff_ID INT NOT NULL,
Staff_Name VARCHAR(200) DEFAULT NULL,
Salary INT NOT NULL,
Contact VARCHAR(120) NOT NULL,
Specialization VARCHAR(200) DEFAULT NULL,
PRIMARY KEY (Staff_ID),
FOREIGN KEY (Job_ID)
REFERENCES Staff (Job_ID)
);
6. COOK
CREATE TABLE Cook (
Category VARCHAR(200) DEFAULT NULL,
);
7. EVENT MANAGER
CREATE TABLE Event_manager (
Position VARCHAR(200) DEFAULT NULL,
);
8. HELPER
CREATE TABLE Helper (
Staff_Name VARCHAR (200) DEFAULT NULL,
);
INSERTING THE DATA

1) HOME
insert into Home
values (001 , 'OKLAHOMA OLD AGE HOME' ,
9876541230 ,'[email protected]');
2) RESIDENT
insert into Resident
values (101 , 'Akshay' , 'Jain' , '[email protected]' , 5478322045 , 50),
(102 , 'aryan' , 'Jain' , '[email protected]' , 7845963210 , 75),
(103 , 'Lakhan' , 'gupta' , '[email protected]' , 7584123690 , 64),
(104 , 'Sumit' , 'Rathore' , '[email protected]' , 5478963102 , 85),
(105 , 'Rajat' , 'Sharma' , '[email protected]' , 1236478920 , 34);
3) DONOR
insert into Donor
values (4578632109845 , 'Pawan Gupta' , 8000),
(7541236895204 , 'Ashwini Dadhich' , 10000),
(7485963210254 , 'Himanshu Dixit' , 2000),
(4578963210542 , 'Remi Singh' , 5000);
4) STAFF
insert into Staff
values (301 , 'Doctor'),
(302 , 'Cook'),
(303 , 'Event_Manager'),
(304 , 'Helper');
5) DOCTOR
insert into Doctor
values (301 , 30101 , 'Lakshay Singh' , 90000 , 8745963210 , 'Cardiologist'),
(301 , 30102 , 'Aman khurana' , 100000 , 4587693201 , 'Orthopedic'),
(301 , 30103 , 'sudhnshu upadhya' , 90000 , 5423015698 , 'Gynecologist'),
(301 , 30104 , 'Vikram Singh' , 98000 , 4587123059 , 'Nutritionists'),
(301 , 30105 , 'Arnav Gupta' , 95000 , 3519745035 , 'Psychiatrist');
6) COOK
insert into Cook
values (302 , 30201 , 'Anjali Sharma' , 70000 , 5412369878 , 'Veg'),
(302 , 30202 , 'Rahul Khanna' , 70000 , 1245789654 , 'Veg'),
(302 , 30203 , 'Kunal Agarwal' , 65000 , 4587965482 , 'Non-Veg'),
(302 , 30204 , 'Khushi Sharma' , 75000 , 7586321045 , 'Non-Veg'),
(302 , 30205 , 'Laxmi Garg' , 60000 , 5236987410 , 'Veg');
7) EVENT MANAGER
insert into Event_Manager
values (303 , 30301 , 'Anjali Agarwal' , 80000 , 4589657123 , 'Team leader'),
(303 , 30302 , 'Sonal Sharma' , 75000 , 2365896541 , 'Staff manager'),
(303 , 30303 , 'Anika Rathore' , 75000 , 9874587568 , 'Marketing lead'),
(303 , 30304 , 'Nandini Gupta' , 70000 , 8568971135 , 'Venue manager'),
(303 , 30305 , 'Ishika Sharma' , 65000 , 9568741352 , 'Creative director');
8) HELPER
insert into Helper
values (304 , 30401 , 'Atharv Goyal' , 50000 , 5896741235),
(304 , 30402 , 'Kush Khandelwal' , 55000 , 5896748591),
(304 , 30403 , 'Meena Shekhawat' , 50000 ,9487563214),
(304 , 30404 , 'Geetika Pandey' , 45000 , 8795648532),
(304 , 30405 , 'Mayura Dixit' , 50000 , 9875685410);
RETRIEVAL OF DATA
 HOME
 RESIDENT
 DONOR
 STAFF
 DOCTOR
 COOK
 EVENT MANAGER
 HELPER
SCREENSHOTS OF PROJECT

Pce21cs178 Vandita Goyal Old Age Home Management System

Uploaded by

Copyright:

Available Formats

Pce21cs178 Vandita Goyal Old Age Home Management System

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Pce21cs178 Vandita Goyal Old Age Home Management System

Uploaded by

Copyright:

Available Formats

OLD AGE HOME MANAGEMENT SYSTEM

(SUBMITTED BY: VANDITA GOYAL (PCE21CS178))

 Add, update, and delete employee records.

 Maintain data integrity through foreign key relationships between tables.

 Generate reports for employee details, resident information, jobs details.

 Develop a user-friendly interface for data entry, modification, and deletion.

6.Data Insertion and Initialization:

 Implement comprehensive testing procedures to ensure the accuracy of calculations

3.Services: In this section admin can manage services(add/update/delete).

 Home Page: welcome page of the web Application

INSERTING THE DATA

You might also like