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
Comments