The database contains two very simple tables. One holds student information and the other holds assignment grade information.
Our goal is to provide a very rudimentary interface to the database allowing for some simple manipulation of the data.
You will need to allow the user to:
-> It should ask for a username and password and validate the input with the database and then perform the below operation
a.Create a new student
b.Add grades for an assignment.
c.You will need to prompt the user for the assignment number, and then prompt the user for each student''s grade.
When asking for the grade, make sure you display the student''s name and the assignment number
(i.e. Please enter Joe Smith''s Assignment5 Grade:______).
d.Change a grade for an assignment (i.e. this should work on only one student)
e.View all the grades for an assignment