Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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