PROJECT
SYNOPSIS
OF
ON LINE INSTITUTE
MANAGEMENT
Submitted to: Ripunjai kumar Submitted by: Ankur kumar
Ashish kumar
Aakansh raj
Table of contents
1. Project Title
2. Preface
3. Project Certificate
4. Acknowledgement
5. Introduction
6. Objective
7. Project category
8. Software platform
9. Hardware platform
10. Feasibility study
11. Testing
12. DFD
13. ER Diagram
14. Data Dictionary
15. Process Logic
Project Title
On line
Institute
Managem
ent
Preface
The main aim of science technology is to understand natural
event. We feel this event with our mind, which is main part of
our body. Computer is also gift of science, which also works
like a brain, but the manner speed at so many other properties
are much more than a men’s brain. Modern age is an age of
computer. Computer has just become a part of our life.
The computer education in India was started in somewhere in
sixties. Now with the advent of micro computer, it has become
possible to have mass education in this field. The major
advantage of computers is the speed which calculated are the
and relative of output comes.
Computer can store much information and solve our problem
within very short duration.
So keeping these things in views, I have computerized my
project work “ON LINE INSTITUTE MANAGEMENT”. I
have maintained this project work on the suitable and
advance language i.e. “PYTHON”.
Introduction
Welcome to ON LINE INSTITUTE
MANAGEMENT. This project is for many
purposes because I want to give full satisfaction
of the user.
In my project I provide many facilities to user.
In ON LINE INSTITUTE MANAGEMENT system it
is very difficult to manage all things but with
the help of my software it becomes very easy to
handle. It saves our time and paper work.
So we consider the above problem and
make this software. In this software you store
all kinds of information like-
Objective of the Project
Our consideration while developing this software was to
achieve the following goals:-
1- This software is for Computer institute. Which provide ON
LINE INSTITUTE MANAGEMENT facility
2- It also saves the valuable time of the Teachers and lots of
paper works.
3- This will save lots of effort of the user. He/She is able to
manage lots of information after using this software and
also able for seeing in different angles.
4- User can manage all the records very easily. You can
generate all kinds of reports like Exam report, Faculty
status, Fess status and many more reports for
management.
We also try to maintain security of data. User cannot enter
directly to the software without using login and password
Project Category
This project belongs to the category of distributed software as
use the applications of ON LINE INSTITUTE MANAGEMENT
System can it. It is a network application,
At a more than
More than one user can use it. It is a type of commercial
software so terms and conditions are provides by the vender to
buyer.
Feasibility Study
It has very important place in the study of any software
because if the project are not feasible then working on this
working on this software is not a good work.
So I conducted the feasibility study in order to check out
whether our software “ON LINE INTSTITUTE MANAGEMENT
SYSTEM” is feasible or not. So we study about three types of
feasibility:-
Economic Feasibility
Technical Feasibility
Operational Feasibility
So brief description of above are following
1. Economic Feasibility:-
In this study, I was concerned about broad range of
factors. Our software has no need of any other equipment or
software. It
saves very much time and lots of manual work. It also saves the
paper work of the person.
So, in short we can say that it is economic feasible
software and saves lots of expenses of the person and time as
well.
2. Technical Feasibility:-
In technical feasibility we studied that the system is technical
feasible or not. If system is not feasible then, a system analyst takes a
decision about software that will be proceeding out or not.
So, we take care of that our software is overall technically
feasible. I take care of the development and technology of the Varanasi
region for ensuring availability of the hardware and software needs for
implementation of this project and that is minimal.
3. Operational feasibility:-
Our software is user friendly. So a person who does not have any
technical background can operate this software, prior knowledge of
computer is not mandatory for operating the software. Icons menus
and its options describing its meaning itself, input and output form are
designed in user friendly way for providing proper instructions with
user.
So we specially take care of that software is operational feasible.
DFD
DATA FLOW DAIGRAM
DFD ON “ENQUIRY”-
Student
Fee details
Report Enquiry Students
generated counter
Courses
Database
DFD ON “REGISTRATION”-
Student
Report
Registration
generated Registration form
counter
Database
DFD ON “STUDENT DETAILS”-
Student
Fee details
Enquiry
counter
Report Courses
generated
Student database Attendance
DFD FOR “FEES DETAILS”-
Student
o Additional fees
Report
Fees details Current fees
generated
Dues fees
Fees database
DFD ON “LIBRARY DETAILS”-
Staff
Book
Issue book
Report Library details
generated
Return book
Library database
DFD ON “STAFF DETAILS”
Staff
Class details
Report Attendance details
Staff details
generated
Salary details
Staff
ER Diagram
I. Entity of On Line Management System:
Course, dd, faculty, fees, mark, message, qinfo , que, result
, session, student , subject , test , testinfo , tmp
II. Attributes Entities and their structure
(a) Course (course_id, cname, totalsem, duration,
semfees, tutionfees)
(b) dd (f_id, bankname, ddno)
(c) faculty (f_id , f_name , address , dob , phone , exe)
(d) fees (f_id , Rollno , medium , type , amount ,
concession , paid)
(e) mark (Rollno , mark , wrong)
(f) message (message_id , message)
(g) qinfo (Rollno , qid , ans)
(h) que (q_id , sub_id , type_id , question , opa , opb , opc , opd
, ans)
(i) result (test_id , Rollno , mark)
(j) session (session_id , status , message_id)
(k) student (Rollno , Enrollno , Formno , Name ,
Course , Fname , City , Address , DateOfBirth ,
DateOfAdmission )
(l) subject (sub_id , subname )
(m) test (test_id , roll , marks )
(n) testinfo (test_id , course_id , sub_id , fac_id ,
totque , per , negval , deduction , duration , type ,
negflag , examdate)
Data Dictionary
Course : Hold course info
name Data type size null
course_id int 4 Not null
cname varchar 50 Allow
Totalsem Int 4 Allow
duration Int 4 Alllow
Semfees Int 4 Allow
Tutionfees Int 4 Allow
dd ; Hold dd information if student
name Data type size Null description
f_id Int 4 No Fees id of relevant student
bankname varchar 50 No DD’s bank name
ddno Int 4 no DD number
fees ; Hold fees submission information
name Data type size Null description
f_id Int 4 No Id for fees record
Rollno Int 4 No Roll no of student
medium bit 1 no Get int for check medium is check or cash
type varchar 50 No Store fees type like university,tution etc
amount Int 4 No Stote amount of fees
Concession Int 4 No Concession in fees amount
Paid Datetime 8 No Date of fees paid
faculty ; Hold faculty information
name Data type size Null description
f_id Int 4 No Primary key for faculty id
bankname varchar 50 No DD’s bank name
f_name varchar 50 No Name of faculty
address varchar 50 no Address of faculty
dob datetime 8 yes Date of birth of faculty
phone Varchar 15 Yes Phone no. of faculty
exe Char 7 No Store extension of resume
Mark; Hold marks information obtain in test for student
name Data type size Null description
Rollno Int 4 No Roll no. of student
mark Int 4 Yes Mark obtain by student
wrong Int 4 yes No. of wrong answer
Message; Hold message that will display on home page
name Data type size Null description
message_id Int 4 No Primary key for message id
message varchar 500 Yes Message for display
Multitype; Hold relevant type of particular subject
name Data type size Null description
test_id Int 4 No Id of test that will be conduct
type_id int 4 No Subject type for exam
password; Hold administrator user name and password
name Data type size Null description
username varchar 50 No Primary key hold username
password varchar 50 No Hold password
qinfo; Hold answer submitted in exam with question id
name Data type size Null description
Rollno Int 4 No Roll no. of student
qid int 4 No Question id
ans char 1 no Answer submitted by student
que; Hold question for all subject
name Data type size Null description
q_id Int 4 No Primary key id for question
sub_id int 4 No Foreign key hold subject id
question Varchar 500 No Question
opa Varchar 200 No Option A
opb Varchar 200 No Option B
opc Varchar 200 No Option C
opd Varchar 200 No Option D
ans Char 1 No Answer
Result ; Hold result of exam
name Data type size Null description
test_id Int 4 No Foreign key which have test information
Rollno int 4 No Roll no. of student
mark Int 4 No Mark obtain by student
Student : Hold student information
name Data type size null
Rollno int 4 Not null
Enrollno int 4 Allow
Formno varchar 20 Not Allow
Name varchar 100 Not Alllow
Course Int 4 Not Allow
Fname varchar 100 Not Allow
City varchar 50 Not Allow
Address varchar 350 Not Allow
DateOfBirth datetime 8 Not Allow
DateOfAdmission smalldatetime Not Allow
Subject ; Hold subject information
name Data type size Null
sub_id Int 4 Not Allow
Subname varchar 30 Allow
Session ; This table store information about message id that will show on
home page, test id for exam and flag that will show test status yes or no
name Data type size Null description
session_id Int 4 No Hold test id
status bit 1 Yes Show test activation
message_id Int 4 No Message which will display on home page
Testinfo ; Hold all related information about test
name Data type size Null description
test_id Int 4 No Primary key for test id
course_id int 4 No Id of exam course
sub_id Int 4 No Id of exam subject
fac_id Int 4 No Id of faculty
Totque Int 4 No No. of question in exam
Per Int 4 No Percentage for passing
Negval Smallint 2 No No. of wrongs answer
Deduction Smallint 2 No No of deduction based on wrong answer
Duration Smallint 2 No Duration of question change in auto-change
mode
type Smallint 2 No No of type for subject question
Negflag Bit 1 No Enable/disable minus marking
autoflag Bit 1 No Enable/disable question auto change
Examdate Datetime 8 No Date of examination
Type ; hold type of particular subjects
name Data type size Null description
type_id Int 4 No Primary key type of subject
sub_id bit 1 No Id of subject
Tname varchar 30 No Type name
Process Logic
Logic For Registration Form
Start
Enter All of Employee
NO
Is correct
YES
Process of Registration
Stop
Logic Logic for Delete Record form:
Start
Enter Employee id
No
Is correct
Yes
Deleted record
Stop
Logic for update Record form :
Start
No
Enter employee id & name
Is correct
Yes
Update Records
Stop
Logic for find Record form:
Start
No
Enter employee id & name
Is correct
Yes
Display the employee
Stop
Logic for submit Employee salary details :
Start
NO
Enter employee id & name
Is correct
Yes
Display salary Record of
Employee
Stop
