7/30/2019 Campus Automation

1/23

Members:

Hemanta Madhab Gogoi(Gau-C-10/L-169),

Minakhi Borgohain(Gau-C-10/L-175),

Rajamoni Sarma(Gau-C-10-31).

Under the supervision of :

Mr. Dharani Roy(Assistant Professor, Dept. of CSE)

Mr. Pranav Kr. Singh(Assistant Professor, Dept. of CSE)

7/30/2019 Campus Automation

2/23

OUTLINE

Introduction

Application

Module

Platform

SRS

DFDER Diagram

Database Tables

Screen Shots

Work till now

Future work and modification

Future Scope

Bibliography and Reference

7/30/2019 Campus Automation

3/23

Database management system that can be update, delete

& modify record.

Project to transform the paper works of CIT to digital

form.

7/30/2019 Campus Automation

4/23

Offices, sections & different department of CIT.

7/30/2019 Campus Automation

5/23

1. Students admission ,fees , scholarship &administration.

2. Academic department management.

3. Teaching & learning management.

4. Hostel management.

5. Training & placement office management.

7/30/2019 Campus Automation

6/23

FrontEnd:

HTML , Javascript, CSS , PHP

BackEnd:

MySQL

7/30/2019 Campus Automation

7/23

For the lack of space it is displayed in MS Word.

Sorry for the inconvenience.

SOFTWARE REQUIREMENT SPECIFICATION (SRS)

7/30/2019 Campus Automation

8/23

User

Response

Request

LEVEL 0:

System

0.0

DATA FLOW DIAGRAM (DFD)

7/30/2019 Campus Automation

9/23

Login

0.1

Admin

LEVEL 1:

Module

coordinator

MLogi

n 0.2

New

Entry

0.4

Update

0.5

Module

0.3

View

0.6

Logout

0.7

Clerk db

Module db

Admin db

User_id, pwd

User_id, pwd

7/30/2019 Campus Automation

10/23

Entrance

and

verification

0.3.4

Login

0.3.1

Studentverificatio

n

0.3.2 Displa

y list

0.3.3

All other

modules

0.3.6

Logou

t 0.3.7

Hostelverificati

on

0.3.5

Admin

Hostel db

Student db

LEVEL 2:

7/30/2019 Campus Automation

11/23

For the lack of space it is displayed in MS Word.

Sorry for the inconvenience.

7/30/2019 Campus Automation

12/23

Field Type Null Default

Description

a_u_id varchar(255) Yes NULLadmin_username

name varchar(255) Yes NULLname

pwd varchar(255) Yes NULLpassword

address varchar(255) Yes NULLaddress

Table structure for table admin

7/30/2019 Campus Automation

13/23

Table structure for table administration

Field Type NullDefault

Description

section_no

varchar(255) Yes

NULL section_no

section_name varchar(255) Yes NULL section_name

7/30/2019 Campus Automation

14/23

Table structure for table administration_clerk

Field Type Null Default

Description

section_no varchar(255) Yes NULL section number

c_u_id varchar(255) Yes NULL clerkuserid

7/30/2019 Campus Automation

15/23

Field Type Null Default

Description

a_u_id varchar(255) Yes NULLadmin_username

name varchar(255) Yes NULLname

pwd varchar(255) Yes NULLpassword

address varchar(255) Yes NULLaddress

Table structure for table admin

7/30/2019 Campus Automation

16/23

7/30/2019 Campus Automation

17/23

7/30/2019 Campus Automation

18/23

7/30/2019 Campus Automation

19/23

Pages of FrontEnd.Forms.

Complete Database.

Partially linking of Forms to the Database.

7/30/2019 Campus Automation

20/23

Assigning responsibilities of the modules to thecoordinators.

Security measures.

Front end, specially the designing of the system.

7/30/2019 Campus Automation

21/23

Adding of different modules with least modification in

the database.

7/30/2019 Campus Automation

22/23

Elmarsi, Ramez and Shamkant Navathe. Fundamentals ofDatabase Systems. New Delhi: Pearson, 2008.

Mall, Rajib. Fundamentals of Software Engineering, Kolkata:

Prentice Hall of India, 2003.

Silberschatz, Abraham and Henry, Korth and S, Sudarshan. The

McGraw Hill,2004.http://www.w3shools.com/

7/30/2019 Campus Automation

23/23