Smart College

SMART COLLEGE Be at your College Any Where.. Any Time…

Group Members: Arjun Jeevaraj Sayyed Basim Sreejesh S Suvin Sukumaran Vaishak T

SCMS School Of Engineering And Technology Vidya Nagar, Karukutty, Ernakulam

Introduction • A web based application designed for teachers, parents and students. • The main design objective of the system is to provide a highly accessible platform which enables the interaction between teachers students and parents

SCMS School of Engg. & Tech.

2

EXISTING SYSTEM Application based system Draw backs • Accessibility is restricted to local networks. • Inadequate amount of information available for students. • Low transparency. • Low or no accessibility of information for parents. • Limited scope for interaction between students, teachers and parents. • Low level sharing of informative resources. SCMS School of Engg. & Tech.

3

Advantages of proposed system • Complete web based application. • Provision for sharing notes and resolving doubts between students and teachers. • Separate profiles for students, teachers and parents. • Parents can regularly check on their ward’s academic performance.

SCMS School of Engg. & Tech.

4

Advantages of proposed system • Low attendance alert for students and parents. • Separate login id and password for each profile to provide enhanced security. • Administrator profile to manage the database and to prevent unauthorized access and manipulation

SCMS School of Engg. & Tech.

5

Environment specificationsHardware Requirements • Processor:- Intel Pentium 4(2.4 Ghz or higher) • Memory:- 1GB DDR • Storage:- 40 GB HDD • Motherboard :- Intel 82845GV • Internet Connection:- 2Mb/s Broadband

SCMS School of Engg. & Tech.

6

Environment specificationsSoftware Requirements • Operating System:- Windows XP-Professional Edition • Database:- MySQL Version 5.0 • Server:- Apache Tomcat Version 6.0 • Website Development:- Adobe Dreamweaver, Adobe Photoshop. • JSP Coding:- Net Beans 6.0, Java Development Kit 1.6.0.

SCMS School of Engg. & Tech.

7

Technology Used • JSP/Servlets • Java Mail • JDBC - Java Data Base Connectivity

SCMS School of Engg. & Tech.

8

Functional Modules • • • • •

Registration Module Attendance Module Marks Updation Module Teacher-Student Interaction Module Semester Updation Module

SCMS School of Engg. & Tech.

9

Data Flow Diagram (Level 0) Users

Smart College

Database

Administrator

SCMS School of Engg. & Tech.

10

USERS

REGISTRATION MODULE

USER ID& PASSWORD

ADMINISTRATOR

LOGIN TABLE

LOW ATTENDENCE ALERT

CLASS COORDINATOR

attendenc e

ATTENDENCE MODULE

CALCULATION

ATTENDENCE TABLE

CLASS COORDINATOR

Marks

MARKS UPDATING MODULE

MARKS TABLE

TEACHER

STUDENT

Repl y

b Dou

t

TEACHER-STUDENT INTERACTION MODULE

DOUBTS TABLE

TEACHER

SEMESTER UPDATING MODULE

STUDENT Semester

ADMINISTRATOR

DETAILS TABLE

Data Flow Diagram (Level 1) Student Login table

STUDENT

LOGIN

VIEW DETAILS

Details table

POST DOUBTS

Inbox

VIEW NOTES

Inbox

SCMS School of Engg. & Tech.

16

Data Flow Diagram (Level 1) Parent

PARENT

Login table

LOGIN

VIEW DETAILS

SCMS School of Engg. & Tech.

Details table

17

Data Flow Diagram (Level 1) Teacher

Login table VIEW DETAILS

TEACHER

LOGIN

Details table

VIEW DOUBTS

Inbox

POST NOTES

Inbox

SCMS School of Engg. & Tech.

18

Data Flow Diagram (Level 1) Class Coordinator

CLASS COORDINATOR

Login table

LOGIN

VIEW DETAILS

Details table

VIEW DOUBTS

Inbox

POST DOUBTS

Inbox

MARK ATTENDENCE

Attendance table

UPDATE MARKS

Marks table

SCMS School of Engg. & Tech.

19

Data Flow Diagram (Level 1) Administrator

ADMINISTRATOR

Login table

ADD TEACHER

Coordinator table

UPDATE SEM

Details table

ASSIGN UID & PASSWD

Login table

LOGIN

STUDENT DETAILS TEACHER DETAILS

SCMS School of Engg. & Tech.

Details table

Details table

20

Login Table UserNo

Varchar

5

Name

Varhar

25

User id

Varchar

5

Passwd

Varchar

10

Primary key

SCMS School of Engg. & Tech.

21

Details Table User id

varchar

5

Name

varchar

25

Branch

varchar

3

Sem

varchar

2

SCMS School of Engg. & Tech.

Primary key

22

Attendance Table Stud. Id

varchar

5

Stud. Name

varchar

25

Branch

varchar

3

No. of working days

number

5

No. of days present

number

5

Attendance %

number

5

SCMS School of Engg. & Tech.

Primary key

23

Marks Table St. id

varchar

5

Branch

varchar

3

Sub. Code

char

2

S12 intrnl

number

5

S12 univ

number

5

S12 Total

number

5

SCMS School of Engg. & Tech.

Primary key

24

Coordinator Table TEACHER ID

varchar

5

SEMNO

varchar

3

BRANCH

varchar

5

SCMS School of Engg. & Tech.

Primary key

25

Conclusion This application is aimed at providing a highly accessible platform on which students teachers and parents can interact with each other and can share a wide array of information.

SCMS School of Engg. & Tech.

26

Thank You…..

SCMS School of Engg. & Tech.

27