21-01-2016, 02:42 PM
Student Information System (SIS) is a web-based application for students, faculty, academic staff and parents who want to get and retrieve student’s whole information instantly via internet. The major benefit of this web portal is to store the student’s information at one place (like SERVER) and it can be accessed via online interaction. The SIS web portal is to replace the old and traditional file (paper work) storing process. Instead of tedious paper work, students will be able to submit required information electronically, and the departments will be able to evaluate the submissions with a much quicker turn around.
LOGIN MODULE
The purpose of this module is to provide entry to the system or website. Based on the type of login, the user is provided with various facilities and functionalities. The main function of this module is to allow the user to use SIS. This module provides two types of login —Admin login and Student login.
ADMINISTRATOR MODULE
In this module when the administrator will enter his/her user name and password, then he/she will enter in to the administrator page and this page consists of two following sub modules.
Student Addition/ Updating / Deletion: In SIS each Student is added, updated or deleted according to its branch.
Notice/Attendance/Result Generation: In SIS information about notice, attendance and Internal result is generated.
Fee Detail and Schedules: Fee information detail and schedule detail are managed.
STUDENT MODULE
In this module when a user enters his student id and password, then he can visit all the
following pages.
Profile View:
When the student clicks on this link he/she will get his/her information like student id, student name, password, father name, date of birth, nationality, city, address, country, phone number, mobile number, email. If he/she wants then he/she can change the profile.
Notice View:
When the student clicks on this link, he can see latest notices released by the administrator.
Attendance View:
When the student clicks on this one, the student can get his overall attendance percentage (present and absent).
Time Table View:
When the student clicks on this link then he/she get all the information that on which day which room which class will be held at which time.
Fee Detail View:
When the student clicks this link he/she can get all the fees structure semester wise and annual fee.
The Student Helpdesk:
This helpdesk is staffed by faculty who are there to help you. You may contact on (faculty phone no.)
Goals
Quick and full information retrieval
Time saving process
High security level of data
Multiuser environment
Global access of data
No repetition of data
SQL Server Tables
SQL Server stores records relating to each other in a table. Different tables are created for the various groups of information. Related tables are grouped together to form a database.
Primary Key
Every table in SQL Server has a field or a combination of fields that uniquely identifies each record in the table. The Unique identifier is called the Primary Key, or simply the Key. The primary key provides the means to distinguish one record from all other in a table. It allows the user and the database system to identify, locate and refer to one particular record in the database.
Foreign Key
When a field is one table matches the primary key of another field is referred to as a foreign key. A foreign key is a field or a group of fields in one table whose values match those of the primary key of another table.