B3. Consider the following Student table and write the appropriate relational algebra query foreach of the questions below: [4..studentID firstNAME lastNAME AGETETCECitySurCourselD1001MariamAl Alawi20ITDR21061002SameeraAl Salti22ITDR2104SoharMuscatAl Ruzaiqi 22Al1003RahmaITDR11011004Bushra23ITDR2104MuscatMammari1005SalimAl Busaidi24ITSW3101Muscata) List the details of students who study the course having the id "ITDR2104" andwhose age is below 23? [1]b) List the details of students who do not live in the Muscat city?c) List first names and cities of students whose age is between 20 and 24 years.

a) -- create a tableCREATE TABLE students ( studentID INTEGER NOT NULL, firstNAME TEXT NOT NULL,…

- Consider the following Student table and write the appropriate relational algebra query for each of the questions below: [4 studentID firstNAME lastNAME 1001 City Sur AGE CourselD ITDR2106 Al Alawi Al Salti Mariam 20 1002 Sameera 22 ITDR2104 Sohar Muscat Al Ruzaiqi 22 Al Mammari 1003 Rahma ITDR1101 1004 Bushra 23 ITDR2104 Muscat 1005 Salim Al Busaidi 24 ITSW3101 Muscat a) List the details of students who study the course having the id "ITDR2104" and whose age is below 23? [1]

- Consider the following Student table and write the appropriate relational algebra query for each of the questions below: [4 studentID firstNAME lastNAME 1001 City Sur AGE CourselD ITDR2106 Al Alawi Al Salti Mariam 20 1002 Sameera 22 ITDR2104 Sohar Muscat Al Ruzaiqi 22 Al Mammari 1003 Rahma ITDR1101 1004 Bushra 23 ITDR2104 Muscat 1005 Salim Al Busaidi 24 ITSW3101 Muscat a) List the details of students who study the course having the id "ITDR2104" and whose age is below 23? [1]

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Please solve asap my deadline is very close
Write a relational algebra query/expression to show names of all faculty who work at any department that uses "Beau" building. Use the College Relational Schema provided below
Some rows of the table STUDENT are shown below: CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI 3.1 1992 938 MICHELE PHY 2.3 1992 931 JHON MD 3.3 2001 182 JOE MD 3.4 2002 190 REY PHY 2.0 2001 330 RON PSI 3.9 2001 You want the name all departments that have a department GPA average of 2004 greater than the global GPA average. Which query gives you the desired result? a. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT); b. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 AND AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT) GROUP BY DEPARTMENT; c. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT GPA FROM STUDENT GROUP BY DEPARTMENT); d. SELECT * FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT);
Question: Which colleges offer courses? (Change the SQL query to an relational algebra query.) **Please show the resulting tuples output based on your answer as well in a table for further explanation. ** SELECT COURSE.COLLEGE FROM COURSE, DEPARTMENT WHERE COURSE.DCODE = DEPARTMENT.DCODE;
What is the difference between an EXCEPT (MINUS) query and a UNION query?
Write SQL query to create the.given table:Worker(Worker Id int primary key, Name varchar(15), Department varchar(10))
Q. What is the syntax of GROUP BY in SQL?