ABSTRACT

The DEPART MANAGEMENT SYSTEM is a management tool for departments. In this all the user can handle the same system. It will make the all data stored at one place.
All the users of fire system can interact with it. Administrator can function over the department.
It is a web-based application for automation of certain basic functionalities of a department such as control on the department work and their things. It can also used for centralizing the large amount of data that has to be maintained in the college department i.e., student, time table employee information etc.














PAGE INDEX
Topic Page No.
I. Acknowledgement 03
II. Abstract 04
1. Introduction 09
1.1 Objective 09
2. System Study 10
2.1 Identification of Need 10
2.2 Feasibility Study 11
2.2.1 Operational
2.2.2 Technical
2.2.3 Economical
3. SRS 13
3.1 SRS Document 13
3.1.1 Introduction 14
3.2 Document Overview 14
3.2.1 Purpose 15
3.2.2 Scope 16
3.2.3 Definitions, Abbreviations & Acronyms 16
3.2.4 Technologies & Tools Used. 17
3.3 Overall Description 18
3.3.1 Software Interfaces 18
3.3.2 Hardware Interfaces 18
3.3.3 Communication Interfaces 18
3.3.4 User-Characteristics 18
3.3.5 Constraints 18
3.3.6 Assumption & Dependencies 18
3.4 Specific Requirements 19
3.4.1 External Interfaces 19
3.4.2 Functional Requirements 20
3.4.3 Performance Requirements 20
4. About the home 20
4.1 Detail 20
4.2 Events 21
4.3 Time tables 21
5. Admin login page 21
6. System Analysis 22
6.1 ER-Diagram 22
6.2 Data flow diagram 23
7. Use Cases 25
7.1 Logging functionality 25
7.2 Add new data 25
7.3 Add Employee record 26
7.4 Add department 27
10. Implementation 43
11. Maintenance 44
12. Test Plan & Testing 44
13. System Security Measures 45
14. Future Scope & Enhancements 46
15. References 47



FIGURE INDEX
Figure No. Figure Title Page No.
Fig: 01 E-R Diagram for the given System 22
Fig: 02 0-Level DFD 22
Fig: 03 1-Level DFD 23
Fig: 04 2-Level DFD 24
Fig: 05 Home page 28
Fig: 06 CT & TG table 29
Fig: 07 Leaves detail 30
Fig: 08 Lecturers detail 31
Fig: 09 Old Lecturers detail 32
Fig: 10 Training detail 33
Fig: 11 Industries visit detail 34
Fig: 12 Time table detail 35
Fig: 13 Student project detail 36
Fig: 14 Student attendance detail 37
Fig: 15 Student personal detail 38
Fig: 16 Database design- teachers 39
Fig: 17 Training 40
Fig: 18 Project 41
Fig: 19 Main table 42


















1. Introduction:
This project manages all the information of all the departments in a college and provides the information related to particular department according our requirements. This project helps us to distribute the work load. We can see the information related to a particular department at a single place.
It will also provide the information about different events that are being organized in our college. In this we can know about leaves in a month of particular faculty, different workshops , master time table, note sheet , resources that being used in our college, exam details , sitting arrangement in exam and we can also know about placement of students
Thus this project helps us in providing different information and to manage that information

1.1Objective:
Manage all the information related to the departments.
We can search required details from different tables according requirements.
Manage and update the table when a teacher join or leave the department.
















2. System Study:
2.1Identification of Need:
Identification of need is the basic step in software development. Before starting to develop any software, it must to known the need of the software i.e. the purpose of developing that software. Projects are initiative for different reasons. This topic reveals the basic introduction of the proposed system. This topic speaks about the subject matter of the project and tells for what the project is made and how it will work and contribute to the present system. The reasons behind need of development of DMS System are:
Capability: This web application reduces the work load of maintaining fire Information and also increases the working capability of the organization.
DMS System increases capability in two ways:
1. Handle High Volume of data: This web application means capacity to store the information such as employee records, student and project records etc.
2. Faster Information Retrieval: Locating and retrieving information from DMS becomes faster.
Control: The DMS system provides greater accuracy and consistency in information occurring in this web application.

Reduce Costs: The DMS reduces manpower requirement so ultimate effect is reduced cost.
Preliminary Investigation:
Investigation is the first step in defining the basis for the project Development. In investigation information is collected that helps programmer or developer to evaluate the merits of the project request.
It is the first way to interact with the user of the proposed system. This determines the feasibility of the system.
Use of preliminary investigation:-
The investigation provides costs and benefits of alternative approaches.
It clarifies and makes understand the project request.
It determines the size of the project.
Investigation defines the problem and the details of the problem.
The significance of the problem is also noted in Investigation.
The solution according to the user is noted in Investigation.
The contribution or help of the information system is also clarifying.
The present working procedure is studied in investigation.


2.2 Feasibility Study:
Feasibility is the determination of whether or not project is worth doing. The process followed in making this determination is called feasibility study. The contents and recommendation of such a study will be used as a sound basis for deciding whether to proceed, postpone or cancel the project. The important feasibility that is studied by us about the Employee Transfer Management System are operational feasibility, technical feasibility, and economic feasibility.

2.2.1 Operational Feasibility:
In operational feasibility we determine that proposed projects are beneficial only if they can be turned into information systems that will meet the operating requirements of the organization. This test of feasibility asks if the system will work when it is developed and installed, a three major barriers to implementation.
Following are the some of the important issues of the operational feasibility that are in favor of system are given below. The Department Management System is operationally feasible. The DMS if developed and deploy will make the working of organization fast. It provides simple and interactive interface due to GUI Environment.


2.2.2 Technical Feasibility:
These are number of technical issues, which are generally raised during the feasibility stage of the investigation. Does the necessary technology exist to do what is suggested? Do the present equipments have the technical capacity to hold the data required to use the new system? Can the system be upgraded? Is there a need of changing equipment?
In technical feasibility we specify the equipment and software that will be needed to satisfy the user requirements.
The DMS system provides the technical guarantee of accuracy, reliability, easy access and data security.

2.2.3. Economic Feasibility:
Economic Feasibility of the project is the main consideration before developing it. The cost incurred in the development work is estimated here. It is the most frequently used technique for evaluating the effectiveness of the proposed system. For economic study we perform the cost/benefit analysis. Here the benefits and savings that are expected from a proposed system are determined and compared with the cost of the project.
In Economic feasibility if benefits are more than the costs, the system is implemented. This feasibility considers the following aspects:
Cost of Hardware
Cost of Software
Working Cost


3. Software Requirement Specification:
3.1 Introduction:
This project manages all the information of all the departments in a college and provides the information related to particular department according our requirements. This project helps us to distribute the work load. We can see the information related to a particular department at a single place.
Document Overview:
3.2.1 Purpose:

Manage all the information related to the departments.
We can search required details from different tables according requirements.
Manage and update the table when a teacher join or leave the department.

3.2.2 Scope:
The different areas where we can use this application are:
Any organization or college can make use of it for maintaining information about employee, events etc.

Technologies and Tools Used:

Front End: PHP
PHP, which stands for "Hypertext Preprocessor", is a server-side, HTML embedded scripting language used to create dynamic Web pages. Much of its syntax is borrowed from C, Java and Perl with some unique features thrown in. The goal of the language is to allow Web developers to write dynamically generated pages quickly.
PHP offers excellent connectivity to many databases including MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, and Generic ODBC. The popular PHP-MySQL combination (both are open-source products) is available on almost every host. Being web-oriented, PHP also contains all the functions to do things on the Internet - connecting to remote servers, checking email via POP3 or IMAP, URL encoding, setting cookies, redirecting, etc

PHP scripting
PHP is now officially known as "PHP: Hypertext Pre-processor". It is a server-side scripting language usually written in an HTML context. Unlike an ordinary HTML page, a PHP script is not sent directly to a client by the server; instead, it is parsed by the PHP binary or module, which is server-side installed. HTML elements in the script are left alone, but PHP code is interpreted and executed. PHP code in a script can query databases, create images, read and write files, talk to remote servers - the possibilities is endless. The output from PHP code
is combined with the HTML in the script and the result sent to the users web-browser, therefore it can never tell the user whether the web-server uses PHP or not, because all the browser sees is HTML.
PHP support for Apache and MySQL further increases its popularity. Apache is now the most-used web-server in the world, and PHP can be compiled as an Apache module. MySQL is a powerful free SQL database, and PHP provides a comprehensive set of functions for working with it. The combination of Apache, MySQL and PHP is all but unbeatable. That does not mean that PHP cannot work in other environments or with other tools. In fact, PHP supports an extensive list of databases and web-servers.

Major Features of PHP:-
Standard CGI, Fast CGI and Apache module support - As a standard CGI program, PHP can be installed on any UNIX machine running any UNIX web server. With support for the new Fast CGI standard, PHP can take advantage of the speed improvements gained through this mechanism. As an Apache module, PHP becomes an extremely powerful and lightning fast alternative to CGI programming.
Access Logging
Access Control
Postgres SQL support
RFC-1867 File Upload Support
HTTP Based Authentication Control
Variables, Arrays and Associative Array
Conditionals and While Loop
Extended Regular Expression
Raw HTTP header Control
On-the-fly GIF Image Creation.

Hypertext
Special instructions in HTML permit text to point (link) to something else. Such pointers are called hyperlinks. Hyperlinks are the glue that holds the World Wide Web together. In your Web browser, hyperlinks usually appear in blue and are underlined. When you click one, it takes you somewhere else.
Hypertext or not, a Web page is a text file. You can create and edit a Web page in any application that creates plain text (such as Notepad). When youre getting started with HTML, a text editor is the best tool to use. Some software tools have fancy options and applications to help you create Web pages, but they generate the same text files that you create with plain-text editors. The World Wide Web comes by its name honestly. Its quite literally a web of pages hosted on Web servers around the world, connected in millions of ways. Those connections are made by hyperlinks that connect one page to another. Without such links, the Web is just a bunch of standalone pages.

Markup
Web browsers were created specifically for the purpose of reading HTML instructions (known as markup) and displaying the resulting Web page. Markup lives in a text file (with your content) to give orders to a browser.

Browsers
Web browsers read instructions written in HTML and use those instructions to display a Web pages content on your screen. Each Web browser interprets HTML in its own way.


3.2.3.2 Features of HTML:-
An HTML file is a text file containing small markup tags.
The markup tag tells the Web browser how to display the page.
An HTML file must have an html or html file extension.
  • An HTML file can be created using a simple text editor.
  • Its a display-only technology.
Back End:
My SQL
My SQL is a relational database management system. It stands for My Structured Query Language. The program runs as a server providing multi-user access to a number of databases.
Features:
v Easy to use
MySQL shows adherence to the ANSI SQL-92 standard and a comprehensive suite of external client programs, it is coupled with graphical administration tools such as PHP My Admin and the new MySQL Control Centre will get even neophyte users up and running quickly compared to other databases.
  • Cross platform Compatibility
  • MySQL run native on every popular flavor of Unix (including Mac OS X) and Windows. It provides cross platform support.
  • Stored Procedures
  • Triggers
  • Cursors
  • Updatable Views
  • true Varchar Support
  • INFORMATION_SCHEMA
  • Strict mode
  • X/Open XA distributed transaction processing (DTP) support, two phase commit as a part of using this, Oracle's InnoDB engine
  • SSL support
  • Query Caching
  • Sub-SELECT
  • Triggers
  • Cursors
  • Updatable Views
  • true Varchar Support
  • INFORMATION_SCHEMA
  • Strict mode
  • X/Open XA distributed transaction processing (DTP) support, two phase commit as a part of using this, Oracle's InnoDB engine
  • SSL support
  • Query Caching
  • Sub-SELECT
v MySQL software is Open Source
Open Source means that it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. If you wish, you may study the source code and change it to suit your needs.
The MySQL software uses the GPL (GNU General Public License), http://www.fsf.org/licenses/, to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need to embed MySQL code into a commercial application, you can buy a commercially licensed version from us. See the MySQL Licensing Overview for more information


v The MySQL Database Server is very fast and reliable DBMS

If that is what you are looking for, you should give it a try. MySQL Server also has a practical set of features developed in close cooperation with our users. You can find a performance comparison of MySQL Server with other database managers on our benchmark page.
MySQL Server was originally developed to handle large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Although under constant development, MySQL Server today offers a rich and useful set of functions. Its connectivity, speed, and security make MySQL Server highly suited for accessing databases on the Internet.

3.2 Overall Description:
3.3.1 Software Interface:
Number Description Alternatives (If available)
1 PHP 5.3.2.1
2 SQL Server 2005 Oracle 8i
3 Windows 2003 Alternatively, Windows 2000 with IIS Server



Table: 01
3.3.2Hardware Interface:
Number Description Alternatives (If available)
1 PC with 8 GB hard-disk and 1 GB RAM Not-Applicable
2 2.6 GHz CPU


Table: 02





3.3.3 User Characteristics:

In the Department includes two levels of Users:
Administrator
General User





Administrator
The Administrator has the ultimate power and privileges to add and edit record contents. He /She also has the privilege to add/update new employee, students and department, related data.

General User
General User has the privileges to see the record of call details or department. But he cannot change any type of information in the data base table .He can navigate through different pages.

3.3.5 Constraints:
The GUI is in English Only.
The User must be authenticated through Login and Password provided with them.

3.3.6 Assumptions and Dependencies:
The user must have sufficient knowledge of Computers.
The Organization Computers must have Internet Server capabilities.
The Department can access the department data database.
3.4 Specific Requirements:
3.4.1 External Interfaces:
The Department management System shall be designed as an application based that has a main user interface. The format of the main screen shall be standard and flexible. The system shall be designed in user friendly manner. Pages shall be connected with each other in a consistent way. Operations that can be done with the system shall be repeatable; the design of the pages should allow users to do this.
The main interface would include Login control, search button, Site map, various images, news feeds and other links. There shall be other pages which have functionality related with the users operations and admin tools operations.



3.4.2 Functional Requirements:
It allows users to navigate to the home page from every page of application. Support Search options, Update and view records. System should allow administrator to add new employees, update details and removal of record of existing employees.
4 About the home
The home page is the main page or starting page of this site. This site contains many controls in the left panel. Which are linked to following pages-
Details
Event
Time table
Resource
Sheets
Students
Project detail
Search Option: - By using this we can find the employee detail, departmental data.


4.1 Detail
This page contains the various options are following:-
CT & TG
LEAVES
TEACHERS
OLD LACTURES


4.2 EVENTS
TRAINING
WORKSHOP
OTHER EVENTS
INDUSTRIAL VISITS


4.3 TIME TABLE

LAB TT
MASTER TT
TECHERS TT
LECTURES VENUS

4.4 SHEETS
NOTE SHEET
LOAD SHEET
SHARED DATA


5. Admin Login Page
This page is used for login of administrator and after entering he can add/update different relevant tables and information and add/ delete records also.











6. System Analysis
6.1 E-R Diagram:-
ADMIN


view


PROJECT
[DMS]


Managed by


ADMIN


UPDATE


TABLES


Inform


DEPARTMENTS


are


MECHANICAL


INFORMATION TECHNOLOGY


Computer
SCIENCE

sssssSSCSScie


are


EMPLOYEE


User-id


Password




CT & TG


leaves


Password


User-id


id


name


id


month


Working days





6.2 Data Flow Diagram:-
0-level DFD:-
ADMINISTRATOR






PROJECT


OUTPUT











1-level DFD:-
Login Process


Event entry


Time Table
Entry


Resource entry


Exam & Project Detail


Leaves entry


CT & TG Entry


Teachers Entry




















2-level DFD:-
ADMINISTRATOR


Login Process




After login
After login
Event Entry


Employee Entry



Data stored
After login
CT & TG entry


Data entry After login
Data Stored
Employee
Department Entry



Data stored Data stored
Department
Data Entry
Data entry


ADMINISTRATOR







7. Use Case: UC-7.1: Logging Functionality
Summary: To access the application, admin needs to provide valid user-id & password for authentication.
Actor: Administrator
Trigger: User Enter URL of the Application
Main Success Scenario: 1. User should enter their username and password for logging in.
2. User should be able to login to panel successfully and should be directed to the Main Dashboard page.
Alternative
Scenario:
If the username and password are not valid, the user should not be redirected to Main Dashboard & an invalid login should be shown.
Fields: Sign-In form fields Information:
Username*
Password*
Post-Condition: 1. Upon successful login, the user should be on the Main dashboard


7.2 UC-02: Add New data

Summary: This interface provides administrator with power to add new data and provide its location and time..
Actor: Administrator
Trigger: User Choose add New data.
Main Success Scenario: 1. User is asked to Enter User Details
2. System validates the entries and adds it to database.
Alternative
Scenario:
User can select other option from Main Dashboard.
Fields: User details should include following fields:


7.3 UC-03: Add Employee Record

Summary: When a New detail is bought its details are added to System by login in admin menu.
Actor Administrator
Trigger User Selects add employee record From admin login Menu.
Main Success Scenario 1. Employee Details are Entered Correctly
2. Details are Saved in System.
Alternative
Scenario Extensions:
Invalid details Are Entered.
Page reloads with previous valid values.
Fields: Add Employee page should display following fields:
1. Employee id
2. Employee name
3. DOB
4. Type
5. Date of join
6. Address
7. Mobile no
Post-Condition: User is send to home page.








7.4 UC-04: Add Departments

Summary: When a New detail is bought its details are added to System by login in admin menu.
Actor Administrator
Trigger User Choose Add Departments From admin login.
Main Success Scenario Details are entered by user.
Details are checked and Saved in System.
Alternative
Scenario Extensions:
Invalid details Are Entered.
Page reloads with previous valid values.
Fields: User is asked to enter following fields:
Post-Condition: Require departments details are shown.














8. SCREEN SHOTS

8.1 HOME PAGE








8.2 CT & TG TABLE












8.3 LEAVE DETAIL











8.4 LECTURERS DETAIL











8.5 OLD LECTURERS DETAIL












8.5 TRAINING DETAIL









8.6 INDUSTRAIL VISIT DETAIL












8.7 TIME TABLE DETAIL













8.9 STUDENT PROJECT DETAIL













8.10 STUDENT ATTENDENCE DETAIL











8.11 STUDENT PERSONAL DETAIL










  1. Database Design
9.1 Teachers










9.2 Training








9.3 Projects







9.4Main Table


10. Implementation:
It is an important phase where the new comprised application is implemented or placed at the place of old one. This step includes all those activities that are needed to exchange the new one with the old one.
The complexity depends upon the nature of the old existing system. Any old system may be-
Manual
Semi Automated
Fully Automated
In any case the old system is Manual Where all the work is done manually. In either case it is necessary to implement the project in a proper way to provide a reliable system
The implementation includes the following activities-
1. Implementation Planning- It is planned previously- how the existing system will be replaced with the new one and what changes will take place in this replacement.
2. Software Installation-For this wed application the following software will be installed at the users site-
PHP with SQL Server-2005
Windows -XP operating system
Dreamweaver8
3. Running the old and new system simultaneously- The overall work of the Organization is performed in the new system as well as in the old system at the time to show the efficiency of new system over the existing one.
4. Live operation- The new application is run at the users site with actual amount of data and the application has to perform the actual operations to show the increased performance. So this web application reduces the work load of Administrator and also increases the working capability of the employees.



11. Maintenance:
Maintenance is the last and non-stop phase of software development life cycle. The programmer has to continually maintain the system during its life the requirement changes with the time spent and the programmer is responsible to update the system with new function and operations to meet the changed requirements.
Reasons for maintenance are:
Following are the reasons due to which maintenance is must in every software project:
1. The software may turn obsolete due to environmental changes and it may call for modifications and enhancements for its effective use.
2. The requirements of the user changes over time so more functions are added to meet the new requirements.
3. Software does not wear out, it is corrected. In maintenance software is repaired to improve its performance



12. Test plan & Test-Cases:
Preconditions: department work management must be installed at test location, All test cases are executed from this page.

12.1Login Verification:
S.NO. Test Case Title Description Expected
Outcome
Actual
Outcome
Result
Login 01 Successful User Verification Login to the system should be tried with the login assigned by the admin & correct password. Login should be successful & the user should enter the system. Login was Successful and user successfully enters the system through its welcome page Passed.
Login 02 Unsuccessful User Verification due to wrong password. Login to the system with a wrong password. Login should fail with an error message. Login fails with an error message UserName and Password are not correct. Passed
Login 03 Unsuccessful User Verification due to invalid login-id. Login to the system with an invalid login-id. Login should fail with an error message. Login fails with an error message UserName and Password are not correct Passed.


Table: 03



13. System Security Measures:
Security is critical in system development. The amount of protection depends on the sensitivity of the data, the reliability of the user, and the complexity of the system. The motives behind security are to keep the organization running, protect data as asset, and seek management support for more installations.
System security is also a main reason to change the current manual system into the computerized system. The possibility of loss and unauthorized access of information is more in the file system. So we have to make to make the new system fully safe and secure so that the unauthorized persons cannot access the important information.
Security of a system refers to protection of the computer system as well as security of data that is maintained through application stored within it; at this stage computer system is not entirely beyond the preview of a system designer. Some of the aspects of security are:
Risk Analysis
Password Control
Access Control
Data and Transaction validation
Data Integrity
Backup and Recovery


14. Future Scope & Enhancements:
FUTURE SCOPE OF APPLICATION:
This application can be easily implemented under various situations. We can add new features as and when we require. Reusability is possible as and when require in this application. There is flexibility in all the modules.

SOFTWARE SCOPE:
Extensibility: This software is extendable in ways that its original developers may not expect. The following principles enhances
To extensibility like hide data structure, avoid traversing multiple links or methods, avoid case statements on object type and distinguish public and private operations.
Reusability: Reusability is possible as and when require in this application. We can update it next version. Reusable software reduces design, coding and testing cost by amortizing effort over several designs. Reducing the amount of code also simplifies understanding, which increases the likelihood that the code is correct. We follow up both types of reusability sharing of newly written code within a project and reuse of previously written code on new projects.
Understandability: A method is understandable if someone other than the creator of the method can understand the code (as well as the creator after a time lapse). We use the method, which small and coherent helps to accomplish this.
Cost-effectiveness: Its cost is under the budget and make within given time period. It is desirable to aim for a system with a minimum cost subject to the condition that it must satisfy the entire requirement.
Scope of this document is to put down the requirements, clearly identifying the information needed by the user, the source of the information and outputs expected from the system











15. References:
Problem Statement(As Documented under Campus Connect Foundation Program)
IEEE SRS Format.
http://www.univraj.gov.in
http://www.phpschools.com
Begining of php and css(vikram vaswani)





ABSTRACT

The DEPART MANAGEMENT SYSTEM is a management tool for departments. In this all the user can handle the same system. It will make the all data stored at one place.
All the users of fire system can interact with it. Administrator can function over the department.
It is a web-based application for automation of certain basic functionalities of a department such as control on the department work and their things. It can also used for centralizing the large amount of data that has to be maintained in the college department i.e., student, time table employee information etc.














PAGE INDEX
Topic Page No.
I. Acknowledgement 03
II. Abstract 04
1. Introduction 09
1.1 Objective 09
2. System Study 10
2.1 Identification of Need 10
2.2 Feasibility Study 11
2.2.1 Operational
2.2.2 Technical
2.2.3 Economical
3. SRS 13
3.1 SRS Document 13
3.1.1 Introduction 14
3.2 Document Overview 14
3.2.1 Purpose 15
3.2.2 Scope 16
3.2.3 Definitions, Abbreviations & Acronyms 16
3.2.4 Technologies & Tools Used. 17
3.3 Overall Description 18
3.3.1 Software Interfaces 18
3.3.2 Hardware Interfaces 18
3.3.3 Communication Interfaces 18
3.3.4 User-Characteristics 18
3.3.5 Constraints 18
3.3.6 Assumption & Dependencies 18
3.4 Specific Requirements 19
3.4.1 External Interfaces 19
3.4.2 Functional Requirements 20
3.4.3 Performance Requirements 20
4. About the home 20
4.1 Detail 20
4.2 Events 21
4.3 Time tables 21
5. Admin login page 21
6. System Analysis 22
6.1 ER-Diagram 22
6.2 Data flow diagram 23
7. Use Cases 25
7.1 Logging functionality 25
7.2 Add new data 25
7.3 Add Employee record 26
7.4 Add department 27
10. Implementation 43
11. Maintenance 44
12. Test Plan & Testing 44
13. System Security Measures 45
14. Future Scope & Enhancements 46
15. References 47



FIGURE INDEX
Figure No. Figure Title Page No.
Fig: 01 E-R Diagram for the given System 22
Fig: 02 0-Level DFD 22
Fig: 03 1-Level DFD 23
Fig: 04 2-Level DFD 24
Fig: 05 Home page 28
Fig: 06 CT & TG table 29
Fig: 07 Leaves detail 30
Fig: 08 Lecturers detail 31
Fig: 09 Old Lecturers detail 32
Fig: 10 Training detail 33
Fig: 11 Industries visit detail 34
Fig: 12 Time table detail 35
Fig: 13 Student project detail 36
Fig: 14 Student attendance detail 37
Fig: 15 Student personal detail 38
Fig: 16 Database design- teachers 39
Fig: 17 Training 40
Fig: 18 Project 41
Fig: 19 Main table 42


















1. Introduction:
This project manages all the information of all the departments in a college and provides the information related to particular department according our requirements. This project helps us to distribute the work load. We can see the information related to a particular department at a single place.
It will also provide the information about different events that are being organized in our college. In this we can know about leaves in a month of particular faculty, different workshops , master time table, note sheet , resources that being used in our college, exam details , sitting arrangement in exam and we can also know about placement of students
Thus this project helps us in providing different information and to manage that information

1.1Objective:
Manage all the information related to the departments.
We can search required details from different tables according requirements.
Manage and update the table when a teacher join or leave the department.
















2. System Study:
2.1Identification of Need:
Identification of need is the basic step in software development. Before starting to develop any software, it must to known the need of the software i.e. the purpose of developing that software. Projects are initiative for different reasons. This topic reveals the basic introduction of the proposed system. This topic speaks about the subject matter of the project and tells for what the project is made and how it will work and contribute to the present system. The reasons behind need of development of DMS System are:
Capability: This web application reduces the work load of maintaining fire Information and also increases the working capability of the organization.
DMS System increases capability in two ways:
1. Handle High Volume of data: This web application means capacity to store the information such as employee records, student and project records etc.
2. Faster Information Retrieval: Locating and retrieving information from DMS becomes faster.
Control: The DMS system provides greater accuracy and consistency in information occurring in this web application.

Reduce Costs: The DMS reduces manpower requirement so ultimate effect is reduced cost.
Preliminary Investigation:
Investigation is the first step in defining the basis for the project Development. In investigation information is collected that helps programmer or developer to evaluate the merits of the project request.
It is the first way to interact with the user of the proposed system. This determines the feasibility of the system.
Use of preliminary investigation:-
The investigation provides costs and benefits of alternative approaches.
It clarifies and makes understand the project request.
It determines the size of the project.
Investigation defines the problem and the details of the problem.
The significance of the problem is also noted in Investigation.
The solution according to the user is noted in Investigation.
The contribution or help of the information system is also clarifying.
The present working procedure is studied in investigation.


2.2 Feasibility Study:
Feasibility is the determination of whether or not project is worth doing. The process followed in making this determination is called feasibility study. The contents and recommendation of such a study will be used as a sound basis for deciding whether to proceed, postpone or cancel the project. The important feasibility that is studied by us about the Employee Transfer Management System are operational feasibility, technical feasibility, and economic feasibility.

2.2.1 Operational Feasibility:
In operational feasibility we determine that proposed projects are beneficial only if they can be turned into information systems that will meet the operating requirements of the organization. This test of feasibility asks if the system will work when it is developed and installed, a three major barriers to implementation.
Following are the some of the important issues of the operational feasibility that are in favor of system are given below. The Department Management System is operationally feasible. The DMS if developed and deploy will make the working of organization fast. It provides simple and interactive interface due to GUI Environment.


2.2.2 Technical Feasibility:
These are number of technical issues, which are generally raised during the feasibility stage of the investigation. Does the necessary technology exist to do what is suggested? Do the present equipments have the technical capacity to hold the data required to use the new system? Can the system be upgraded? Is there a need of changing equipment?
In technical feasibility we specify the equipment and software that will be needed to satisfy the user requirements.
The DMS system provides the technical guarantee of accuracy, reliability, easy access and data security.

2.2.3. Economic Feasibility:
Economic Feasibility of the project is the main consideration before developing it. The cost incurred in the development work is estimated here. It is the most frequently used technique for evaluating the effectiveness of the proposed system. For economic study we perform the cost/benefit analysis. Here the benefits and savings that are expected from a proposed system are determined and compared with the cost of the project.
In Economic feasibility if benefits are more than the costs, the system is implemented. This feasibility considers the following aspects:
Cost of Hardware
Cost of Software
Working Cost


3. Software Requirement Specification:
3.1 Introduction:
This project manages all the information of all the departments in a college and provides the information related to particular department according our requirements. This project helps us to distribute the work load. We can see the information related to a particular department at a single place.
Document Overview:
3.2.1 Purpose:

Manage all the information related to the departments.
We can search required details from different tables according requirements.
Manage and update the table when a teacher join or leave the department.

3.2.2 Scope:
The different areas where we can use this application are:
Any organization or college can make use of it for maintaining information about employee, events etc.

Technologies and Tools Used:

Front End: PHP
PHP, which stands for "Hypertext Preprocessor", is a server-side, HTML embedded scripting language used to create dynamic Web pages. Much of its syntax is borrowed from C, Java and Perl with some unique features thrown in. The goal of the language is to allow Web developers to write dynamically generated pages quickly.
PHP offers excellent connectivity to many databases including MySQL, Informix, Oracle, Sybase, Solid, PostgreSQL, and Generic ODBC. The popular PHP-MySQL combination (both are open-source products) is available on almost every host. Being web-oriented, PHP also contains all the functions to do things on the Internet - connecting to remote servers, checking email via POP3 or IMAP, URL encoding, setting cookies, redirecting, etc

PHP scripting
PHP is now officially known as "PHP: Hypertext Pre-processor". It is a server-side scripting language usually written in an HTML context. Unlike an ordinary HTML page, a PHP script is not sent directly to a client by the server; instead, it is parsed by the PHP binary or module, which is server-side installed. HTML elements in the script are left alone, but PHP code is interpreted and executed. PHP code in a script can query databases, create images, read and write files, talk to remote servers - the possibilities is endless. The output from PHP code
is combined with the HTML in the script and the result sent to the users web-browser, therefore it can never tell the user whether the web-server uses PHP or not, because all the browser sees is HTML.
PHP support for Apache and MySQL further increases its popularity. Apache is now the most-used web-server in the world, and PHP can be compiled as an Apache module. MySQL is a powerful free SQL database, and PHP provides a comprehensive set of functions for working with it. The combination of Apache, MySQL and PHP is all but unbeatable. That does not mean that PHP cannot work in other environments or with other tools. In fact, PHP supports an extensive list of databases and web-servers.

Major Features of PHP:-
Standard CGI, Fast CGI and Apache module support - As a standard CGI program, PHP can be installed on any UNIX machine running any UNIX web server. With support for the new Fast CGI standard, PHP can take advantage of the speed improvements gained through this mechanism. As an Apache module, PHP becomes an extremely powerful and lightning fast alternative to CGI programming.
Access Logging
Access Control
Postgres SQL support
RFC-1867 File Upload Support
HTTP Based Authentication Control
Variables, Arrays and Associative Array
Conditionals and While Loop
Extended Regular Expression
Raw HTTP header Control
On-the-fly GIF Image Creation.

Hypertext
Special instructions in HTML permit text to point (link) to something else. Such pointers are called hyperlinks. Hyperlinks are the glue that holds the World Wide Web together. In your Web browser, hyperlinks usually appear in blue and are underlined. When you click one, it takes you somewhere else.
Hypertext or not, a Web page is a text file. You can create and edit a Web page in any application that creates plain text (such as Notepad). When youre getting started with HTML, a text editor is the best tool to use. Some software tools have fancy options and applications to help you create Web pages, but they generate the same text files that you create with plain-text editors. The World Wide Web comes by its name honestly. Its quite literally a web of pages hosted on Web servers around the world, connected in millions of ways. Those connections are made by hyperlinks that connect one page to another. Without such links, the Web is just a bunch of standalone pages.

Markup
Web browsers were created specifically for the purpose of reading HTML instructions (known as markup) and displaying the resulting Web page. Markup lives in a text file (with your content) to give orders to a browser.

Browsers
Web browsers read instructions written in HTML and use those instructions to display a Web pages content on your screen. Each Web browser interprets HTML in its own way.


3.2.3.2 Features of HTML:-
An HTML file is a text file containing small markup tags.
The markup tag tells the Web browser how to display the page.
An HTML file must have an html or html file extension.
  • An HTML file can be created using a simple text editor.
  • Its a display-only technology.
Back End:
My SQL
My SQL is a relational database management system. It stands for My Structured Query Language. The program runs as a server providing multi-user access to a number of databases.
Features:
v Easy to use
MySQL shows adherence to the ANSI SQL-92 standard and a comprehensive suite of external client programs, it is coupled with graphical administration tools such as PHP My Admin and the new MySQL Control Centre will get even neophyte users up and running quickly compared to other databases.
  • Cross platform Compatibility
  • MySQL run native on every popular flavor of Unix (including Mac OS X) and Windows. It provides cross platform support.
  • Stored Procedures
  • Triggers
  • Cursors
  • Updatable Views
  • true Varchar Support
  • INFORMATION_SCHEMA
  • Strict mode
  • X/Open XA distributed transaction processing (DTP) support, two phase commit as a part of using this, Oracle's InnoDB engine
  • SSL support
  • Query Caching
  • Sub-SELECT
  • Triggers
  • Cursors
  • Updatable Views
  • true Varchar Support
  • INFORMATION_SCHEMA
  • Strict mode
  • X/Open XA distributed transaction processing (DTP) support, two phase commit as a part of using this, Oracle's InnoDB engine
  • SSL support
  • Query Caching
  • Sub-SELECT
v MySQL software is Open Source
Open Source means that it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. If you wish, you may study the source code and change it to suit your needs.
The MySQL software uses the GPL (GNU General Public License), http://www.fsf.org/licenses/, to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need to embed MySQL code into a commercial application, you can buy a commercially licensed version from us. See the MySQL Licensing Overview for more information


v The MySQL Database Server is very fast and reliable DBMS

If that is what you are looking for, you should give it a try. MySQL Server also has a practical set of features developed in close cooperation with our users. You can find a performance comparison of MySQL Server with other database managers on our benchmark page.
MySQL Server was originally developed to handle large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Although under constant development, MySQL Server today offers a rich and useful set of functions. Its connectivity, speed, and security make MySQL Server highly suited for accessing databases on the Internet.

3.2 Overall Description:
3.3.1 Software Interface:
Number Description Alternatives (If available)
1 PHP 5.3.2.1
2 SQL Server 2005 Oracle 8i
3 Windows 2003 Alternatively, Windows 2000 with IIS Server



Table: 01
3.3.2Hardware Interface:
Number Description Alternatives (If available)
1 PC with 8 GB hard-disk and 1 GB RAM Not-Applicable
2 2.6 GHz CPU


Table: 02





3.3.3 User Characteristics:

In the Department includes two levels of Users:
Administrator
General User