Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the following tables: Question 5 Not yet answered Finish attempt Time left 0:03:35 Marked out of 10.00 P Flag question STUDENT STU_NUM STU_LNAME 321452

image text in transcribed

Given the following tables: Question 5 Not yet answered Finish attempt Time left 0:03:35 Marked out of 10.00 P Flag question STUDENT STU_NUM STU_LNAME 321452 Bowser 324257 Smithson ENROLL CLASS_CODE STU_NUM ENROLL_GRADE 10014 321452 C 10014 324257 B 10018 321452 A 10018 324257 B 10021 321452 10021 324257 C CLASS CLASS_CODE CRS_CODE CLASS_SECTION CLASS TIME CLASS ROOM PROF NUM 10014 ACCT-211 3 THUR, 2:30 - 3.45 PM BUS252 342 10018 CIT-220 2 MON, 9:00 - 9:50 PM KLR211 114 10021 QM-261 1 WED, 8:00 - 8:50 AM KLR200 114 Write the suitable SQL statement to do the following: 1- Create the table student, taking into account for the primary and foreign keys. 2- Update the structure of the Enroll table by adding another field named enroll date of type date. 3- List all the student's last names that got a grade C. 4- List all students last names that got grade C in course CIT-220 5- List all class times for courses that have students with grades "B". 1 i - BT

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

Step: 3

blur-text-image

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

Principles Of Multimedia Database Systems

Authors: V.S. Subrahmanian

1st Edition

1558604669, 978-1558604667

More Books

Students also viewed these Databases questions

Question

19. How do amphetamine and cocaine influence dopamine synapsespg105

Answered: 1 week ago