WEEK 9 ASSIGNMENT#3 Part I:Complete the following exercise: Create the following table with the correct columns. Call your new table: student_course (see below). Populate this table with four rows. Make sure the student id column contains values that are also in the student id column of your student table.student idcourse idsemesteryearJoin the student and student_course table where the student id values are the same.Join the student and student_course table where the student id values are the same and year is equal to 2020.Create a select statement that will return the length of the last name column by joining the student and student_course table where the student id values are the same and enroll month is June.Once you have completed your assignment, copy and paste the script into a Word document.Part II:Complete the following exercise: Using a subquery, select student first name where the student is in the student course table.Using a subquery, select the course id where the average GPA is 2.Using a subquery, select the course id where the average GPA is greater than 2.Using a subquery, select student first name where the student is not in the student course table.

The answer is written in step 2

Answered: Part I: Complete the following…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

WEEK 9 ASSIGNMENT#3

Part I:

Complete the following exercise:

Create the following table with the correct columns. Call your new table: student_course (see below). Populate this table with four rows. Make sure the student id column contains values that are also in the student id column of your student table.
1. student id
2. course id
3. semester
4. year
Join the student and student_course table where the student id values are the same.
Join the student and student_course table where the student id values are the same and year is equal to 2020.
Create a select statement that will return the length of the last name column by joining the student and student_course table where the student id values are the same and enroll month is June.

Once you have completed your assignment, copy and paste the script into a Word document.

Part II:

Complete the following exercise:

Using a subquery, select student first name where the student is in the student course table.
Using a subquery, select the course id where the average GPA is 2.
Using a subquery, select the course id where the average GPA is greater than 2.
Using a subquery, select student first name where the student is not in the student course table.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions