Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

My attempt at the problem is the second picture 3.2 Insert more data into registered_students INSERT data into your database using the same steps as

My attempt at the problem is the second picture image text in transcribed
image text in transcribed
3.2 Insert more data into registered_students INSERT data into your database using the same steps as in 3.1 but this time use the following: - Add students where the student has a first name with "o" in the name. - The inserted value for the class_id should be the hardcoded value which corresponds to the same class_id value of the class which has the class code of COMM113 in your classes table. You will want to look up this value by using a separate SELECT query to obtain the class_id for COMM113. - Run the code to create the data Deliverable 3.2: send your code and screenshot \( \begin{array}{ll}31 & \text { INSERT INTO registered_students(class_id, student_id) } \\ 32 & \text { SELECT (SELECT class_id FROM classes WHERE code }=\text { 'cOMM113'), student_id } \\ 33 & \text { FROM students } \\ 34 & \text { WHERE first_name LIKE } \% \%{ }^{\prime} \text { ' } 3 \\ 35 & \end{array} \)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transactions On Large Scale Data And Knowledge Centered Systems Xxiv Special Issue On Database And Expert Systems Applications Lncs 9510

Authors: Abdelkader Hameurlain ,Josef Kung ,Roland Wagner ,Hendrik Decker ,Lenka Lhotska ,Sebastian Link

1st Edition

366249213X, 978-3662492130

More Books

Students also viewed these Databases questions

Question

Describe the types of power that effective leaders employ

Answered: 1 week ago

Question

Describe how leadership styles should be adapted to the situation

Answered: 1 week ago