Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started