Introduction - If you have any usage issues, please Google them yourself
1. Information about student, course and course choosing can be modified. (6’, 2’ for each table)
2. Information about student, course and course choosing can be inserted and deleted. (6’, 2’ for each table)
3. Information about student and courses he/she chose can be queried based on a student’s ID or Name. If ID and Name are not given, show all students’ and their courses information. (12’)
4. The score of a course that a student chose can be queried based on a student’s Name (or ID) and a course’s Name (or ID). If no student’s and course’s ID or Name are given, show all scores of all students’ courses. (12’)
5. Information about course or course choosing can be queried based on course’s Name or ID. If no course’s Name or ID is given, show information about all courses or all course choosing. (7’)
6. Information about teacher or courses a teacher teaches can be queried based on a teacher’s Name or ID. If no teacher’s Name or ID is given, show information about all teachers or al