Question: Consider the following database and answer the questions below. STUDENT table [ [ ST _ ID , ST _ NAME ] , [ 7
Consider the following database and answer the questions below.
STUDENT
tableSTIDSTNAMEJames BondSusan BrownSusan SmithMegan Black
tableCOURSECREDITHRCOURSEIDCOURSETITLE,COMPDatabase Systems,COMPComputer Organization,COMPData Structures,COMPAdvanced Database Systems,
ENROLLMENT
tableST IDCOURSEIDGRADECOMPAtCOMPAtCOMPA COMPCOMPACOMPBCOMPCCOMP
SPORT
tableST IDSPORTNAMEBasketballFootballBasketballBasketballTennisSoccerFootball
a Write the SQL statement the displays the names of the students who have enrolled in the Database Systems course
b Write the SQL statement that displays a list of the students whose names start with S
Select
From STUDENT
Where STNAME
c Write the SQL statement that displays the Student ID Student Name, Course ID and Grade for students that passed at least one course with a grade better than Bie A A and A
Select STID AS studentid, ST name As student name, Course ID Grade From
d Write the SQL statement that displays the total number of credit hours one number for the courses enrolled in by the student with ID
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
