Question: Please try your best at doing all 3 questions. Show the queries and the outputs please. If all is done properly, a big like will





Please try your best at doing all 3 questions. Show the queries and the outputs please. If all is done properly, a big like will be given to you. Thanks so much.
(Part II.). Formulate SQL queries in Oracle (show output) with reference to the STUDENT, COURSE, GRADE and GRADE_POINT tables presented below COURSE n. GRADE_POINT Primary Key: GRADE \begin{tabular}{|l|r|} \hline \multicolumn{1}{|c|}{ GRADE } & \multicolumn{1}{c|}{ POINTS } \\ \hline A & 4 \\ \hline B & 3 \\ \hline C & 2 \\ \hline D & 1 \\ \hline F & 0 \\ \hline \end{tabular} GRADE Primary Key: COURSE_NO + STUDENT_ID Foreign Keys: COURSE_NO references COURSE, STUDENT_ID references STUDENT, GRADE references GRADE_POINT table Express the queries 1 to 3 in SQL. (Show results). 1. Retrieve the STUDENT_FNAME and STUDENT_LNAME for all students with CS Major. 2. Retrieve the STUDENT_ID, STUDENT_FNAME, STUDENT_LNAME for all students in CS100. 3. List the first name and last name of all students who have received A in all the courses that they have taken. (Show the query and the result)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
