SQL Database Creation & Query Execution

I. Create two tables: • Student (ID, Name, Major, GPA) • Majors (Major, Description, Department Name) • Major is a foreign key in student • 0 <= GPA <= 4.00 • Grant privileges to one of your group members on this table • Remember • Majors table must be created before Student table • Your friend must qualify the table name with your user id to access your table Note: For each table, enter at least seven (7) rows of data II. Query the two tables: 1. List student name, major and department name for all students 2. List student name, major, and department name for students that have a GPA > 3.0 2 Chapter8Assignment#08 (continued…) III. Use the Student and the Majors tables that you have just created to perform the following queries: 1. List all rows in Student table 2. List names, majors and GPAs of all students 3. List names, majors and GPAs of all students sorted by major in ascending order and by GPA within major in descending order 4. Print distinct major names from the student file 5. Print student count and average GPAs for all students 6. Print student counts and average GPAs by major 7. Print names and GPAs of all students that are INSY majors and have a GPA above 3.0 8. Print names and GPAs of all students that are INSY or Marketing majors and have a GPA above 3.0 9. What are the minimum and maximum GPAs? 10.What are the minimum and maximum GPAs of INSY majors? Submission Guidelines I. Submit your work as one MSWord document that contains the following three parts for each question: 1) The question of interest; 2) The SQL query responding to the question; 3) A screen shot of the resulting ‘table’.