Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[Q.3] Answer the following questions based on the following simple university database COURSE Course_name Intro to Computer Science Data Structures CS1310 CS3320 MATH2410 CS3380 3
[Q.3] Answer the following questions based on the following simple university database COURSE Course_name Intro to Computer Science Data Structures CS1310 CS3320 MATH2410 CS3380 3 MATH Database SECTION Section_identifier Course_number Semester Year King Fall Fall 85 92 102 112 119 135 MATH2410 CS1310 C$3320 MATH2410 C$1310 Fall Fall Fall 05 Chang Stone GRADE REPORT 17 17 8 8 8 8 112 119 92 102 135 PREREQUISITE CS3380 CS3380 CS332o CS3320 MATH2410 CS131o STUDENT | Name | StudentNumber | Class l M (a) Write SQL statement to create and populate SECTION table with referential constraint. You need to show how to insert one tuple into the table (b) Write a SQL statement to retrieve the names of all senior students majoring in CS. (c) Write a SQL statement to retrieve the names of all courses taught by Professor Andersorn in 2004 and 2005. (d) Retrieve the name and major departments of all students who do not have any grade A in any of their courses
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