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 intothe appropriate table(s). A student 'Mickey Mouse' with Netld'mm1' joins 'CS' department.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!