Task for composite experiment on database systems

2. Project Description There is an administrator who manages student-learning information of the college. The administrator needs to deal with much querying about students' information. Of course, it is very boring. So he wants to design database to help him to complete the work efficiently and conveniently. According to his daily works, he lists his requirement as follows: l. The college has some different majors, for example, computer science, software engineering, digital media, network engineering, etc. Each major has several classes and each class has about 30 students. 2. The information about a student involves student ID name, sex, age, hometown, province, total credits, etc 3. The information about the course involves course ID course name, major, credits, etc, One course often has several sections, and one section is taught by one teacher in a semester. The information about the section involves course ID, section ID, semester, year, teaching location, etc. 4. The information about the teacher involves teacher ID name, sex, age, title, contact phone, office, email, etc 5. The information about a student's marks involves student ID, course ID, semester, course marks, etc. 6. Note that: One major has more than one class. One course in a semester needs more than one teacher. And one teacher can take more than one course in a semester 7. Functions and querying to be done: a) To list one student's marks of all courses grouping by semester: b) To list all students' marks about some course in the ascending or decreasing order. And each querying only lists the marks of students in one clas c) To compute the average marks of each course. And the average marks can be grouped by class; d) To count the number of courses that one student has learned, and compute his total credits; e) To query marks of one student about some course: To query courses that are taught by some teacher in one semester g) To query courses that are taken by some class in one semester: h) Other possible functions and querying that you can imagine. And extra functions and querying will give you extra marks. rogramming language (CIC Java, Ca etc to develop a GUI program to realize al