A database system is to be designed for keeping records of the students of a school.

<br><br> <img src='./qimages/9560-1a.jpg'>

A student can appear in many exams. Perform the following tasks for the E-R diagram as given above
Design and implement normalised relations/tables for the E-R diagram. You should include primary key, validation checks and referential integrity constraints in your implementation.

1.(b) Enter 5 sets of meaningful data in every table that you have created

1.(c) Design and implement the following forms/queries/reports for the database system created as above: Create two forms one for entering student information and the other for entering exam information.
List all the exams on the subject "Physics".

(iii) List all the exams in which the student whose ID is "S001" has appeared. Also show his/her marks obtained.
Make a list/report of all students in the order of their names.
Find the maximum marks obtained in an examination whose
Exam_ID is "Ex1".