Consider the relations Courses1. Courses2.Enrollment and Students.CorustAS IntLarvinnKary 144b) Courses1-Courses2(1) Give the results of the following relationalalgebra expressions:a) Tid (History OR Computing (Courses2))c) Courses Courses2FaralmentWHHEATHO ASHOBIHC ALAd) Courses Enrollmente)Enrollment/(Courses1)(2) Write the following query in Relational Algebra.a) Eind the sids of students who bave enrolled.incourse Calculusb) Find the names of students who have enrolled incourse Calculusc) Find the names of students who have enrolled atleast one course.d) Find the names of students who have enrolled inCalculus or Algebra.e) Find the sids of students who have enrolled in allcourses (both Courses1 and Courses2).

As per the answering guidelines solving the first 3 sub question completely. 1) Here selection…

Consider the relations Courses1.Courses Enrollment and Students. Location b) Courses1-Courses2 (1) Give the results of the following relational algebra expressions: a) Tid (e-History OR Computing (Courses2)) c) Courses In Courses2 Farst d) Courses Enrollment THE BE THE LAS HOA e) Enrollment/(Courses1) (2) Write the following query in Belational Algebra. a) Find the sids of students who bave enrolled in course. Calculus. b) Find the names of students who have enrolled in course Calculus. c) Find the names of students who have enrolled at least one course. d) Find the names of students who have enrolled in Calculus or Algebra. e) Find the sids of students who have enrolled in all courses (both Coursesland Courses2).

Consider the relations Courses1.Courses Enrollment and Students. Location b) Courses1-Courses2 (1) Give the results of the following relational algebra expressions: a) Tid (e-History OR Computing (Courses2)) c) Courses In Courses2 Farst d) Courses Enrollment THE BE THE LAS HOA e) Enrollment/(Courses1) (2) Write the following query in Belational Algebra. a) Find the sids of students who bave enrolled in course. Calculus. b) Find the names of students who have enrolled in course Calculus. c) Find the names of students who have enrolled at least one course. d) Find the names of students who have enrolled in Calculus or Algebra. e) Find the sids of students who have enrolled in all courses (both Coursesland Courses2).

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

Consider the following relational schema and answer the following questions. Employee (Employee_Id, First_Name, Last_Name, Email, Phone_Number, Hire_Date, Job_Id, Salary, Commission_Pct, Manager_Id, Department_Id) a. Write a query to find the manager ID and the salary of the lowest-paid employee for that manager. b. Write a query to get the department ID and the total salary payable in each department. c. Write a query to get the average salary for each job ID excluding programmer. d. Write a query to get the total salary, maximum, minimum, average salary of employees (job ID wise), for department ID 90 only.
Computer Science At UFL, each class is a specific offering of a course (subject). Each row in the Courses table contains information on a single course or subject taught a UFL and each row in the Classes table contains information on a single offering of a course during a specific term. Investigate the two tables, and then write a query that returns the CourseTitle, ClassID, Term, SectionID and FacultyID for classes taught by FacultyID 5000009. SOLUTION:
Using relational algebra, write a query that; Selects person's with stamps as their hobby from the relation in figure 10 i. Extracts the name and hobby attributes of the relation in figure 1.0. ii. Aedres Hoby 1123 John 123 Main stamps 1123 John 123 Main coins 5556 Mary 7 Lke Dr 9876 Bart S Pine St stamps Figure 1.0: Student's Hobby's List
How many rows does the resultant of the relational algebra expression acqcost>1500 (Tdesc,acqcost (A)) have, given the table A below? id 82943 Conference Table 77463 Conference Chair 99821 Desk 44320 Desk 99873 Conference Chair 77472 Conference Chair 88872 Speaker Phone 33411 Monitor 55" 98006 Printer 88753 Copier 72633 Chair 99098 Conference Chair desc acqcost 4998.00 247.45 1987.00 2019-09-15 1987.00 2017-11-05 247.45 2019-09-15 2019-09-15 247.45 247.00 2020-06-23 874.00 2018-03-08 1389.00 2019-12-18 4877.90 2017-12-01 642.00 2017-11-05 239.90 2020-02-10 dateacq 2019-09-15 2019-09-15
1.Implemet the following Query on the books table from book store database. Note: the table books consist of (book name, author, year_of publication, publisher).
convert it to relations that are normalization
Given the following query, which is represented by a relational algebra expression:Project[aid,aime,price](Select( place="Koper", Join( Agents, Orders, Agents.aid=Orders.aid ))Assumes all tables are ordered by key. Estimate the number of blocks read if yesimplementation of the contact algorithm useda) nested loop contact by blocks andb) fusion contact.
After executing a Cartesian product of student and advisor, followed by a selection operation on the result with the predicate s id = ID, what is the outcome of the operation? When stated in relational algebra's symbolic notation, this query may be represented as s id=ID(student advisor).
Run the problem using Relational Algebra, below the problem I added the needed table. Use self join find the answer (4) Find the name (fname,lname) of the direct supervisor of “Mary Smith”. (“Mary Smith” is an employee). group: emplyeeemployee = {fname, lname, ssn,superssn, departnumber'Mary', 'Smith',111, 222, 11'Green', 'Marjorie',333, 222, 12'Gren', 'Cheryl',222, 777, 14}
Using the instance of the Airport database, formulate the following queries in the relationalalgebra: 1)List the name and the state of all United States airports. 2)List full details of all airports located outside the United States.Note: You should use the not equal sign  in this query. 3)Display the number of all carriers and the average of their revenues. 4)Display the minimum, the average, and the maximum distances of the flights that arescheduled on October 17th, 2017? Example: List all airport names. π name Airport More example provided it attached file.
What is the result of first performing the cross product of student and advisor, and then performing a selection operation on the result with the predicate s_id = ID? (Using the symbolic notation of relational algebra, this query can be written as sid=1D(student x advisor).) M 1 1
Relational Algebra Questions:Using the instance of the Airport database, formulate the following queries in the relationalalgebra: 1. List full details of all airports located outside the United States.Note: You should use the not equal sign  in this query. 2. List the name and the state of all United States airports. 3. List the name and the fleet size of all carriers employing more than 50000 workers. 4. List the carrier name, the carrierID, the flightNo and the date of all flights. 5. Display the number of airports. 6. Display the number of flights with distances longer than 3000 miles. 7. Display the number of all carriers and the average of their revenues. 8. Display the number of flights leaving from JFK and the total of their distances. 9. Display the minimum, the average, and the maximum distances of the flights that arescheduled on October 17th, 2017?