Requirements

Requirements Students' Perspective 1. Creating a Profile 2. Posting Queries to the Staffs 3. Viewing replies 4. Viewing their Circulars 5. Requesting Leave

Staffs' Perspective 1. Creating a Profile 2. Posting Queries and Replying to the Queries 3. Viewing their Circulars 4. Requesting Leave 5. Forwarding/Rejecting the Leave Request (If Tutor) 6. Submitting Circulars to the Class 7. Viewing a Student's profile

HODs' Perspective 1. Creating a Profile 2. Posting and Replying to the Queries 3. Viewing their Circulars 4. Requesting Leave 5. Accepting/Rejecting the Leave Requests of Students and Staffs 6. Managing Circulars created by them 7. Viewing a Student's profile

Principal's Perspective 1. Posting and Replying to the Queries 2. Managing Circulars 3. Accepting/Rejecting the Leave Requests of Staffs and HODs 4. Managing Circulars 5. View a Student's profile

Database Design 1. Profile RollNumber/ID (*)

:

Integer

Name

:

VarChar(50)

FatherName

:

VarChar(50)

DOB

:

SmallDateTime

YOJ (Year of joining)

:

Integer

YOL (Year of leaving)

:

Integer

Department

:

Byte

Type (Student/Staff)

:

Byte

Designation

:

VarChar(30)

Address

:

Text

EMailID

:

VarChar(50)

MobileNumber

:

VarChar(11)

Handle

:

Password

:

VarChar(15)

Sender

:

Integer

Receiver

:

Integer

Subject

:

VarChar(100)

Message

:

Text

SentAt

:

datetime

CreatedBy

:

Integer

Category

:

VarChar(50)

Circular

:

Text

CreatedAt

:

datetime

TargetPeople

:

VarChar(10)

2. Queries

3. Circulars

4. Leaves

LeaveID

:

Integer

RequestedBy

:

Integer

RequestedTo

:

Integer

Reason

:

Text

Day

:

datetime

Status

:

Byte

Job Split-ups 1. Create Profile This is fairly simple. Use a form to collect all the details from the Student/Staff. If the registrant is a Staff then Generate an ID of your own just by concatenating the first name and last name without the spaces, initials and dots. If there is more than one exists with the handle you arrived at then concatenate the numbers 1,2,3... like that. Lets give a code for all the departments and use them in the Department field.

2. Udpate Profile You know how to update and all those related things. Remember this module should include Change Password option too.

3. Udpate Profile You know how to update and all those related things. Remember this module should include Change Password option too.

I ll send the remaining things in the next update