Wednesday, 25 November 2015

Student Database Management



This Student Database has been outlined considering the handy needs to deal with a Students' information. Also, it gives security at item level and in addition client level. Its configuration focuses on 2 sorts of clients:
1.       Administrator
2.       Students 

This Database takes after a normal occasion stream seen in such a framework. The database essentially is from the understudy perspective. Since the understudy is the focal point of the framework, all the different records in the database spin around the understudy exercises. A portion of the other free classifications of information incorporate the library office, fest, sports, social exercises and graduated class affiliation. 

All such data helps the whole gang to think about the advancement accomplished by the establishment. Each understudy can be given uncommon consideration by knowing his execution in the database. What's more, if the association is competent to put it on a LAN then regardless it includes more adaptability for the association staff. 

INFORMATION STORAGE:
          Student Profile: Student Details, Address, Admission Details, Dependent Details.
          Attendance Details: Total no of classes, No of classes went to by understudy for every subject.
          Internal and Examination Information: Takes Data for each of the 3 internals and Exam Details.

          Supports Data Management for finding:
        Student in every Department by URN.
        Internal Average Marks Scored.
        Attendance Shortage.
        Exam Result. 

Control OF DATABASE:
          Addition of Student Profile.
          Addition of Department Details and its Corresponding Subjects.
          Modify or Delete Student Profile.
          Modify Attendance and Examination Results. 

REPORT GENERATION:
          List of Students' in every Department.
          List of Attendance for every Student Department-wise.
          List of Examination Status for every Student Department-wise. 

So regarding this we have taken up a little work here, wherein we have added to a database for Students' Attendance and Examination Database that can hold the Institute in great stead. 

PROGRAMMING REQUIREMENT SPECIFICATION
REASON: 

Our Database is a storage facility of data with respect to the different Student and the different properties typified in it. To keep up such an enormous rundown of assorted information, the Institution can't bear to keep up paper-work, as it is tedious and has more opportunities to information misfortune and trustworthiness misfortune. The enormous measure of information can be made effectively viable and available, by the utilization of PCs. Business RDBMS like Oracle can facilitate the procedure of such a mechanization. 

Our Database Management task means to give mechanized interface to all the information to be controlled and put away, utilizing Oracle and Visual Basic. The application accommodates, 

1.       Retrieval of any information in view of specific criteria
2.       Storage of information, and its upkeep in a steady way
3.       Generation of altered reports in view of specific criteria
4.       Easy to utilize, interface with menus and structures, for clearer reversibility 

The application additionally does the fundamental information acceptance, so that excess or, superfluous copy information are kept from crawling into the database. It likewise traps the vast majority of the basic information section mistakes. 

The Application separates between 2 sorts of clients. One classification is of Students who simply need to get data about their individual subtle elements for participation and Examination data. The regulatory client is another classification, why should approved include, erase and alter the database content. He can include New Department, comparing Subjects. He can likewise enter Student data, all the while.

PROGRAMMING ITEMS UTILIZED:
The accompanying are the product that will be utilized as a part of finishing the venture:
        ORACLE 8 (individual release): As a back end to store the information. Prophet is picked since it is vigorous and easy to utilize.
        Visual Basic 6.0: As the front end to make easy to understand window interface. Visual fundamental gives exhaustive components that help in planning in point of interest. 

THE OVERALL HIGH LEVEL DESCRIPTION:
ITEM FUNCTIONS:
The accompanying is a synopsis of the capacities that the framework is relied upon to perform:
          Provide separate access to individual Student and head such that just the executive has the privilege to include, erase and adjust the different administrations offered by the framework.
          Provide the overseer with alternatives to include the same number of Students, Departments, relating Subjects as required.
          The overseer must be furnished with rights to change the Student information store..
          Provision to create reports and make inquiries in any fancied way. 

CLIENT CHARACTERISTICS:
Any individual with fundamental PC aptitudes can make utilization of the item. The client ought to have just been informed about the usefulness of the framework before he can begin utilizing the framework. 

SUPPOSITIONS AND DEPENDENCIES:
ALLOTTING OF PREREQUISITES:
The creators expect to redesign the framework to a LAN empowered multi client framework other than giving network to the web to general programmed updating of the information put away in the framework. 

PARTICULAR REQUIREMENTS:
CAPACITIES:
          The essential administrations that the Student Database System incorporate
          Entry of New Students' to the Department
          Entry of Attendance Information
          Entry of Examination Marks
          Provide individual and Department-wise reports.
          Update the understudy profile contingent upon Attendance and Exam Status.
          The framework should accommodate secret key secured head access to include, erase and change the fundamental administrations offered by the framework.

          The framework might accommodate putting away of Student individual points of interest alongside his Attendance and Examination marks.
          Reports:
          Individual Student report : Includes individual points of interest of individuals.
          Department-wise report: Lists every one of the representatives right now dynamic
          User Interface and Security:
          Menu based Interface
          Floating Pop-up menu
          Customized Background Picture
          File based Encrypted Password Handling

No comments: