Question: Using the below University schema 1. Insert the following information into the appropriate table(s). A student 'Mickey Mouse' with Netld'mm1' joins 'CS' department. He is


Using the below University schema 1. Insert the following information into the appropriate table(s). A student 'Mickey Mouse' with Netld'mm1' joins 'CS' department. He is taking Computer Graphics course (CRN 195) offered by Prof. 'Donald Duck' from 'CS' department. 2 Write a SQL query that returns the LastName of student, Title of course he/she is taking, and the Score, for all students in 'CS' department Note that, you can write as many SQL statements as you need to insert data. Just maker sure, you write the SQL query after the insert statements Input Format The Students, Enrollments and Courses table are defined as follows: Students Column NameType Netld FirstName LastName Department VARCHAR(100) VARCHAR(10) VARCHAR(255) VARCHAR(255)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
