EnggRoom

PHP Project - Summer Training 2014,Noida
Computer Science Department Portal


The proposed system is to make an online web portal for Computer Science Department, so that everyone can get information about department, students can easily communicate with teachers from anywhere. Teachers can easily communicate with the students, and can keep records of every student easily and efficiently. The proposed system could be accessed from any corner of the world on net.


• Faculties: This module gives profile information of various faculties associated to the department.
 It gives profile information of all the faculties.
 Anyone can contact to these faculties and post queries to them.
 They can upload E-books and other reading materials.
 They can post notices to the students and also view the notices from the administrator.


• Students: This is a separate webpage for students.
 They can view, edit, and update their profile from anywhere.
 Student can download documents as well.
 They can view faculty profile and even post queries to the faculties.
 The can also generate their Resume
 They can view notices by the Admin.
 They can view notices by the Faculties.


• Administrator: The administrator has the central control over the whole portal.
 He can access the students and faculties information directly.
 He will create the student and faculty profiles which they can later on edit.
 He can respond to the queries of the faculties.
 He can post notices which will be accessible to the both the faculties and the students.
 He will handle the number of students and incase any student or faculty leaves he will edit the record accordingly.


Database Tables


LoginMaster

Field Name
Description
UserID(Email)
Varchar(50)PK
Password
Varchar(30)
Status
Varchar (5)
Note: Status may be Studn, Faclt, Admin.
​


StudentMaster

Field Name
Description
UserID
Varchar(50) FK(login_master)
RollNo
int
Batch
int
Branch
Varchar(30)
Degree
Varchar(10)
JoiningYear
Int
Note: Batch is the year of passing , Joining Year is the Year in which the student joined.

FacultyMaster

Field Name
Description
UserID
Varchar(50) FK(login_master)
Department
Varchar(30)
Degree
Varchar(20)
JoiningYear
int
Note: Department is the department in which the faculty teaches , Joining Year is the Year in which the faculty joined.
AdminMaster

Field Name
Description
UserID
Varchar(50) FK(login_master)
JoiningYear
int
StudentPersonalMaster

Field Name
Description
UserId
Varchar(50) FK(login_master)
Name
Varchar(30)
DOB
int
Gender
varchar(6)
Address
varchar(50)
MobNumber
numeric
Note: DOB is the Date of Birth ,MobNumber is the contact number.


FacultyPersonalMaster

Field Name
Description
UserId
Varchar(50) FK(login_master)
Name
Varchar(30)
DOB
int
Gender
varchar(6)
MobNumber
numeric


StudentAcademicMaster

Field Name
Description
UserId
Varchar(50) FK(login_master)
AcdAchvmt
Varchar(150)
Sports
Varchar(150)
Cultural
Varchar(150)
Others
Varchar(150)
Graduation
Int
Inter
Int
HighSchool
Int
Note: AcdAchvmnt is the Academic Achievement
Sports is the Sports Achievement
Cultural is the Cultural Achievement
Others will contain other information about the student

StudentTechnicalMaster
Field Name
Description
UserId
Varchar(50) FK(login_master)
PrgmLanguage
Varchar(30)
Database
Varchar(30)
OS
Varchar(30)
Software
Varchar(30)
OtherSkill
Varchar(30)
IndustryExp
Varchar(150)
AcademicProject
Varchar(150)
Note: PrgmLanguage is the Programing Language known.
Database is the databases known.
OS is the OS known.
Software is the softwares known.
OtherSkill is the Other skills the person knows.
NoticeMaster

Field Name
Description
UserId
Varchar(50) FK(login_master)
Title
Varchar(30)
Content
Varchar(30)
Type
varchar(8)
Date
Int
DocPath
Varchar(150)

NOTE : Title is the Title of the Notice
Type is the for the notice is for Student, Faculty, General


Description:

Admin Module:

1. Add Students and Faculty Details :
Create a form for administrator to add new student/Faculty. And insert new entry on LoginMaster table. This form has 1drop down list for selection of student or faculty.

2. Delete/Edit the details
Create a form where all students/faculty are display on the combo and the admin can select any student and can delete any of the student/faculty from the LoginMaster table.

3. Upload Notice
Create a page with 1 text field for title of the notice and text area for the content of the notice. The page should also contain a combo to choose for whom the notice is for.

4. Delete/Edit the details
Create a form where all notice title are display on the combo and the admin can select any notice and can delete/edit any of the notice.


Student Module:
1. Create An profile(Registration):
Create a form where the user can create an enter the details of academics and extra curricular activites the profile is is in editable mode. .
2. Resume Builder
Create a page which will generate a resume based on the data entered by the student in the profile.
3. Notice board:
Create a page which will have a combo box from which the student can choose which notice he wishes to see either by the admin or by the faculty.
4. Faculty page:
Create a page which will contain the list of the faculties sorted alphabetically and each entry serves as a link to the faculty profile.
5. Ebooks page
In this form user can download the ebooks uploaded by the faculties the are also sorted by their name.
6. Scrap Space:
Each student should have his own scrap space where the response to their queries is posted.
Faculty Module:

1. Create An profile(Registration):
Create a form where the faculty can create an enter the details of academics and extracurricular activities the profile is in editable mode. .
2. Notice :
Create a page with 1 text field for title of the notice and text area for the content of the notice. The page should also contain a combo to choose for whom the notice is for.
3. Students page:
Create a page which will contain a combo box from which the faculties can choose to view the profile of the students of the respective batch.
4. Upload ebooks page
In this form user can upload the ebooks for the students it will have a combo to decide for whom the ebook is to be uploaded.
5. Scrap Space:
Each faculty should have their own scrap space where the queries is posted.
7. Notice board:
The faculty should be able to view the notices uploaded on the common notice board.
8. Delete/Edit the details
Create a form where all notice title are display on the combo and the admin can select any notice and can delete/edit any of the notice.


Tools & Technology

Server Side : PHP, Ajax

Client Side : HTML, JavaScript, CSS

Database : MySql

Web Server-Apache

IDE hp Designer 7 of Higher,Net Beans