A database interrogation is a major benefit of the database management approach,

Question

A database interrogation is a major benefit of the database management approach, where end users can query ("ask") the database for information. The Structured Query Language (SQL) is an international standard query language found in many DBMS packages. The basic form of a SQL query is: SELECT. FROM... WHERE... For example, if we have the following STUDENTS table: STUDENT ID STUDENT NAME COURSE ID STUDENT GPA COLLEGE CODE 140064001 14006400:2 140064003 IT101 CHS CCI CCI CCI CHI Ahmad Nasser IT343 IT242 IT446 IT101 3.5 2.75 3.15 3.90 2.90 1.95 2.90 Sarah Abdullah Sultan Mohamed 140064004 14006400:5 Bader Ali Fahad Murlaa Salman Abdulaziz IT242 140064006 IT448 CCI 140064007 CCI The following SQL query is used to retrieve STUDENT NAME and COURSE_ID for all students who have GPA = 2.90 SELECT [STUDENT NAME], [COURSE ID] FROM [STUDENTS] WHERE STUDENT-GPA-2.90 And the result of the above query is: STUDENT NAME COURSE ID Bader Ali IT101 Salman Abdulaziz IT242

Explanation / Answer

1)SQL Query to retrive STUDENT_ID and STUDENT_GPA for all CCI students who study course has the code IT101:
:-SELECT [STUDENT_ID],[STUDENT_GPA]
FROM [STUDENTS]
WHERE [COLLEGE_CODE] = "CCI"
AND [COURCE_ID] = "IT101"

and the result of above query is
:-empty because currently no record satisfy above criteria

2)What is the result of the following query?
SELECT [STUDENT_ID], [COURSE_ID], [COLLEGE _ODE]
FROM [STUDENTS]
WHERE [COURSE_ID] = "IT242" OR [STUDENT_GPA] >3.00
:-

[STUDENT_ID]   [COURSE_ID]    [COLLEGE _ODE] Explnation:Condition matched

140064001 IT101 CHS [STUDENT_GEA] >3.00
140064003 IT242 CCI [COURSE_ID] = "IT242" [STUDENT_GEA] >3.00
140064004 IT446 CCI [STUDENT_GEA] >3.00
140064007 IT242 CCI [COURSE_ID] = "IT242"

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---