Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

[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

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

Transactions On Large Scale Data And Knowledge Centered Systems Xxxviii Special Issue On Database And Expert Systems Applications Lncs 11250

Authors: Abdelkader Hameurlain ,Roland Wagner ,Sven Hartmann ,Hui Ma

1st Edition

3662583836, 978-3662583838

More Books

Students also viewed these Databases questions

Question

Have I incorporated my research into my outline effectively?

Answered: 1 week ago