Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(6) STUDENT Namo Student number Smith 17 Brown 8 C or OS OS 2 COURSE Course name Intro to Computer Science Data Structures Discrete Mathematics
(6) STUDENT Namo Student number Smith 17 Brown 8 C or OS OS 2 COURSE Course name Intro to Computer Science Data Structures Discrete Mathematics Database Counse number Credit hours Department CS1310 4 cs CS3320 4 CS MATH 2410 3 MATH CS3380 3 CS SECTION Section identition Course number 85 MATH2410 92 CS1310 102 CS3320 T112 MATH2410 119 CS1310 1135 CS3380 Somostar Fall Fall Spring Year 07 07 08 08 08 OB Instructor King Anderson Knuth Chang Anderson Stone Fall TESCO dentifier Grade B GRADE REPORT Student number 17 17 8 B B LR 185 22 102 135 A B INITIA B PREREQUISITE Course number CS3380 CS3380 033920 Prerequinte humber C$3320 MATH2410 CS1310 For the above CS-Department database schema, write SQL queries for the following data retrievals: (a) Retrieve the names of courses and credit hours for all courses taught by Dr. King and Dr. Knuth in 2007 and 2008. (b) Insert a new grade of 'B' for student 'Smith' for the 'Database' course. (C) Delete the 'Discrete Math course from this database
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