Consider a database with the tables listed below. The columns in each table are

Question

Consider a database with the tables listed below. The columns in each table are shown in parentheses 0. The primary key for each table is signified by the underlined columns UnitDetails (UnitCode, UnitName) Offerings (UnitCode Year, Semester, coordinator) Results (UnitCode, ear, Semester, Student Number, Result) StudentDetails (StudentNumber, Name, Address) Consider the following SOL query: SELECT UnitDetails.UnitCode, UnitDetails.UnitName, Results.Year, Results.Semester, Results.Result FROM StudentDetails, Unitbetails, Results WHERE StudentDetails.StudentNumber Results.StudentNunber AND UnitDetails.UnitCode = Results "UnitCode AND StudentDetails.Name 'John Bron' ORDER BY Results.Year, Results.Senester, UnitDetails.UnitCode Which of the following best describes the purpose of that SQL query? The query extracts all unit details and corresponding results for units that John Brown has studied and orders them by year, semester and unit code. All of the columns from the UnitDetails, Results and Studenttails tables are included in the output The query joins all four tables in the database to extract all unit details corresponding results for units that John Brown has studied and orders them by year, semester and unit code. The query extracts all unit details and corresponding results for units that John Brown has studied and orders them by year, semester and unit code. A selection of the columns from the UnitDetails, Results and StudentDetails tables are included in the output. The query extracts all unit details and corresponding results for units that John Brown has studied and orders them by year, semester and unit code. A selection of the columns from the UnitDetails and Results tables are included in the output. The query extracts all unit details and corresponding results for units that John Brown has studied and orders them by year, semester and unit code. All of the columns from the UnitDetails and Results tables are included in the output. The query is not valid as it is syntactically incorrect

Explanation / Answer

Solution:

The answer to the above question is:

d) The query extracts all unit details and corresponding results for units that John Brown has studied and orders them by year, semester, and unit code. A selection of the columns from the UnitDetails and Results table are included in the output.

Explanation:

SELECT UnitDetails.UnitCode, UnitDetails.UnitName, Result.year, Result.semester, Result.Result,

this line makes the selection of coloms to include in the output from the UnitDetails and Results table

FROM StudentDetails, UnitDetails, Results

this line joins the three tables

WHERE StudentDetails.StudentNumber = Results.StudentNumber

AND UnitDetails.UnitCode = Result.UnitCode

these lines consist of the join condition between three tables

AND StudentDetails.Name = 'John Brown'

this line specifies the condition that student name has to be 'John Brown'

ORDER BY Result.Year, Result.Semester, UnitDetails.UnitCode

this line orders the output on the basis of above mentioned three feilds

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.