Consider a relational database with the following schema:PERSONS (NAME, DATE-OF-BIRTH, CITY-OF-BIRTH)PLAYS (PERSON-NAME, SPORT)Foreign key: PLAYS (PERSON-NAME) REFRERENCES PERSONS (NAME)For each of the query in the left column below, select the relational algebra from the right column that is the correct answer for it. (5 pointseach)a. Find the names of the sports that are played by everyone.f. Find the sports that are played by at least one person.g.✓ Find the name and date of birth of each person who playsthe sports tennis.i. Find the name of the person who doesn't play any sports.a. PLAYS/T NAME (PERSONS)b.π NAME, DATE-OF-BIRTH (PLAYS SPORT='tennis' PERSONS)C. IT SPORT (PLAYS NAME=PERSON-NAME PERSONS)d. πT NAME (PERSONS)e. πT NAME (PERSONS)/PLAYSf. I SPORT (PLAYS)g. π NAME, DATE-OF-BIRTH (PLAYS∞ NAME=PERSON-NAME ANDSPORT='tennis' PERSONS)h.π PERSON-NAME (PLAYS)-IT NAME (PERSONS)i. π NAME (PERSONS)-TI PERSON-NAME (PLAYS)

Let's match each query on the left with the correct relational algebra expression on the…

Answered: Consider a relational database with the…

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

Refer to the Company Database. List the ssn, last name, birth date, and department name of all employees who were born in the 1980s and are younger than their supervisor. i. Show the SQL for the statements ii. Express the SQL statements as a sequence of relational algebra statements (to be executed sequentially). You must use all the operators: selection projection, join. iii. Illustrate a relational algebra query tree for the execution of the statements. You must use all the operators: selection, projection, join.
Practical Tasks for Database Systems Question:1 Show all data from employee table where name should be in ascending and salary in descending order. Question:2 Show the total length of (eno, deptno). joined it and rename by function from the employee table? Question:3 Show the ename first 3 alphabets of manager? Question:4 Write a query that show the manager data like this. ename job ***MANAGER *** MANAGER JONES BLAKE Question:5 Calculate the percentage of any student and round to 0 digit? Question:6 Show the last date of December 2014? Question:7 Show the date of next data base class and rename by cs-400? Question:8 Convert today date to character?
EMPLOYEE Frame Minit Lname Sen Bdate Address Sex Salary Super sen Dno +444 DEPARTMENT Dname Dnumber Mor an Mgr start date DEPT LOCATIONS Dnumber Dlocation PROJECT Prame Prumber Plocation Dnum WORKS ON Ennn Pno Hoir Hours DEPENDENT Esen Dependent name Se Bdate Relationship Reforential integrity constraints displayed on the COMFWNY relational database schema. One possible database state for the COMPANY relational database schema. EMPLOYEE Fname Minit Lname John Frankin T Sex Salary 30000 333445555 5 M 40000 Jo00665555 F 25000 Joe7e54321 43000 J88Ge5556 San Bdate Address Super en Dno 123456789 1965-01-09 731 Fondren, Hounton, TX M 333445555 1955-12-08 638 Voas, Houston, TX Go0087777 1960-01-19 3321 Castle, Spring. TX 987654321 1941-06-20 291 Berry, Bellaire, TX Narayan 666884444 1962-09-15 975 Fire Oak, Humibile, TX M B Smith Wong Zelaya Wallace 5 Alicia 4 Jennifer F 38000 333445655 25000 333445555 M 25000 007654321 M 55000 NULL Ramesh English 453453453 1972-07-31 5631 Rice, Houston, TX F…
Use the following relational schemas for answering the queries in relational algebra; STUDENT(ID, Name, Phone, Gender) ENROLMENT(Student_ID, Course_ID) COURSE(CID, CName, Instructor) Find the name and phone of all students who registered the course ‘ITE1004’ under ‘Prof. Raghu’.
I need the answer as soon as possible
We have a relational database that contains the table ‘Staff’. The table ‘Staff’ consist of columns ‘Name’, ‘Department’ and ‘Date of Joining’. What query would you use to extract the Names and Department of all staff in the table? a. SELECT * FROM Staff b. a) SELECT Name, Department FROM Staff c. SELECT Name, Department IN Staff d. SELECT * IN Staff
I need the answer as soon as possible
Q2/ Map your ER into a relational schema. All constraints must be included: Primary keys (PK) highlighted, foreign keys (FK) well referring to their PK, unique not null and other constraints also specified. Name PUBLISHER Phone Address publish Author_id Book_id M BOOK AUTHOR Has Titele M Name Date_out Loan Due_date phone f name I name BORROWER address Card id F_name
Relation algebra (Database)
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?
Database Management Systems

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

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

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

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

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS