Answer to Question #3454 in ASP | ASP.NET for nimit jain

Question

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 int(10) PK
Password Varchar(30)
Status Varchar (5)
Note: Status may be Studn, Faclt, Admin.



StudentMaster
Field Name Description
UserID int(10) primary key
RollNo int(10)
Batch int(4)
Branch Varchar(30)
Degree Varchar(10)
JoiningYear int(4)
Note: Batch is the year of passing , Joining Year is the Year in which the student joined.

FacultyMaster
Field Name Description
UserID int(10) primary key
Department Varchar(30)
Degree Varchar(20)
JoiningYear int(4)
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 int(10) primary key
JoiningYear int(4)

StudentPersonalMaster
Field Name Description
UserId int(10) primary key
Name Varchar(30)
DOB int(10)
Gender varchar(6)
Address varchar(50)
MobNumber Int(10)
Email Varchar(20)
Note: DOB is the Date of Birth ,MobNumber is the contact number.

FacultyPersonalMaster
Field Name Description
UserId int(10) primary key
Name Varchar(30)
DOB int(10)
Gender varchar(6)
MobNumber Int(10)
Email Varchar(20)

StudentAcademicMaster
Field Name Description
UserId int(10) primary key
AcdAchvmt Varchar(150)
Sports Varchar(150)
Cultural Varchar(150)
Others Varchar(150)
Graduation Int (5)
Inter Int (5)
HighSchool Int (5)
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 int(10) primary key
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 int(10) primary key
Title Varchar(30)
Content Varchar(30)
Type varchar(8)
Date Int(10)

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 : ASP.NET with C#,Ajax
Client Side : HTML, JavaScript, CSS
Database : SQL Server 2005
Web Server-IIS6.0
Framework : .NET Framework 3.5.
IDE :Microsoft Visual Studio 2008

Answer 1

Unfortunately, your question requires a lot of work and cannot be done for free. Submit it with all requirements as an assignment to our control panel and we'll assist you.