In this assignment we will use database for MTech grading systems of CSE department. First step is to
create the database with the following information.
- Student(Roll_No,Name) // Roll_No is unique
- Subject(Subject_Code,Name,Credit,L,T,P) // Subject_Code is unique
Develop an (graphical) user interface to perform the following:
- Update the database with the subjects taken by a student - Register(Roll_No,Subject_Code)
- Update the database with the grade of a student in a subject - Grade(Roll_No,grade,Subject_Code)
Along with this information, the following constraints/assumptions are to be taken care of.
- A student can choose a subject only from the subject list
- A student is not allowed to take more than 25 credits and no less than 20 credits.
- Grade in a subject of a student can only be updated if the student is registered in that subject
- A student can register for a subject once only
Some of these constraints can be coded as referential integrity constraints, while others can be checked using consistency checks. You are required to do the following:
- Update the database with sample text file. (Use comma separated format like csv)
- List all the students
- List all the subjects
- List the subject in order of the number of student registered
- List the grades of a particular student
- List the grades of students in a particular subject
- Find the name of the student with highest cgpa
- List top k students on the basis of cgpa
- List top k students on the basis of gpa on the selected subjects
- Find the name of the student who scored highest gpa in the lab
Download sample test case from
here.