Answer the following questions using the School database and the data provided. For each question, submit the SQL statements used to determine the answer and your answer.
1) Create a view to calculate the numerical grade point average for each student listed in the database.
2) Create a view to calculate the number majoring in each department?
3) Create a view of the STUDENT table that includes the age of the student. This view should include all other STUDENT fields as well.
4) Which students have a grade point average that is higher than the grade point average of students who are majoring in ECT?
5) Which students have a grade point average that is higher than the grade point average of all the students who are majoring in HCI?
6) Create a view to list the different instructors that are teaching in the current academic year.
7) Which students have taken courses taught by Xiaoping Xia?
8) Which students have taken a course that is among the courses taught by Xiaoping Xia, even if the student did not take the course from Xiaoping Xia?
9) Which instructors teach courses in the same department as those taught by Evelyn Lulis and Yoseph Winograd?
10) Which five students have the highest grade point averages?
11) An analysis of the data in our database revealed that there are a lot of duplicate addresses in the ADDRESS table. In order to converse space, we need to make some changes to the database. We will assign each address a unique identifier and reference that address from the STUDENT table as either the permanent or temporary address. Students living at the same address will point to the same ADDRESS record. (25 points)
This question has 3 parts i can send to you. I also have a project that needs to be done and I can send that you as well.
## Deliverables
All I need is the SQL statements that would make this work. It would also help, though, if it could be explained what is happening in each part of the sql statement. Also, this is a beginnner class and should use certain statements that I can give you that we have gone over in class. I can email you the SCHOOL database that this uses and the project info.
## Platform
Should work on win2000 using oracle and SQL
## Deadline information
Please email me at k7e3v3 at aol.com. This can not be done in very advanced SQL. I will go over the details if you feel like youd like to do this and the project. Thanks a bunch for your help.