Question: This is using relational algebra not regular SQL commands. I am mostly confused on how the algebra is suppose to be wrote out. MINIT SSN

This is using relational algebra not regular SQL commands. I am mostly confused on how the algebra is suppose to be wrote out.

MINIT SSN BDATE SEX SALARY EMPLOYEE FNAME John Franklin Alicia Jennifer Ramesh Joyce Ahmad James B T J S K A V E LNAME Smith Wong Zelaya Wallace Narayan English Jabbar Borg 123456789 333445555 999887777 987654321 666884444 453453453 987987987 888665555 1965-01-09 1955-12-08 1968-07-19 1941-06-20 1962-09-15 1972-07-31 1969-03-29 1937-11-10 ADDRESS 731 Fondren, Houston, TX 638 Voss, Houston, TX 3321 Castle, Spring, TX 291 Berry, Bellaire, TX 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 980 Dallas, Houston, TX 450 Stone, Houston, TX M M F F M F M M 30000 40000 25000 43000 38000 25000 25000 55000 SUPERSSN DNO 333445555 5 888665555 5 987654321 4 888665555 4 333445555 5 333445555 5 987654321 4 1 null DEPT_LOCATIONS DNUMBER DLOCATION 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston DEPARTMENT DNAME Research Administration Headquarters DNUMBER 5 4 MGRSSN 333445555 987654321 888665555 MGRSTARTDATE 1988-05-22 1995-01-01 1981-06-19 1 WORKS_ON PNO 1 2 3 1 2 2 3 10 20 30 10 PROJECT PNUMBER PLOCATION ESSN 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 DNUM HOURS 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 35.0 5.0 20.0 15.0 null PNAME ProductX ProductY Productz Computerization Reorganization Newbenefits 5 5 5 1 2 3 10 20 30 Bellaire Sugarland Houston Stafford Houston Stafford 4 1 4 10 30 30 20 20 DEPENDENT ESSN DEPENDENT_NAME SEX BDATE 333445555 333445555 333445555 987654321 123456789 123456789 123456789 Alice Theodore Joy Abner Michael Alice Elizabeth F M F M M 1986-04-05 1983-10-25 1958-05-03 1942-02-28 1988-01-04 1988-12-30 1967-05-05 RELATIONSHIP DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE F F Specify the following queries on the database schema shown in above Figure using the relational algebra discussed in class. 5. List the last names of female employees who have no dependents. 6. the average salary of all female employees who works for 'Administration' department 7. For each department, list the department name and the total number of project controlled by the department

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

HELP IN F,G,H,I,J THANK YOU IN ADVANCE EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Plecation PROJECT...

Provide resulting relation (table with tuples) for each query. Using these tables. The table in a. is already completed as an example a. Retrieve first name, last name, and date of birth of all...

oracle sql statement help. I will upvote a clear, detailed response. Thank you!! more joins (inner and outer), subqueries and other SQL issues You are suggested to adopt a user friendly prefix string...

Use ORACLE For each of the following, Write the SQL & RA (RELATIONAL ALGEBRA) statements that satisfy the requirements using given database COMPANY. Don't use Multi Table select in SQL and Cross...

Please use relational algebra not SQL. Thank you! Table needed is pasted on and an example ion the 7 queries are pasted as well. Show the result of each of the sample queries in Section 6.5 as it...

For the Pizza Delivery Shop DB, (see Appendix), write SQL queries to answer each of the following questions. a) List all the last names, phone numbers and zip codes of the customers. b) List...

2. For the Company Projects DB, (see Appendix), write SQL queries to answer perform each of the following actions. a) For each department whose average employee salary is more than $30,000, retrieve...

For each of the following, Write the SQL & RA (RELATIONAL ALGEBRA) statements that satisfy the requirements using given database COMPANY. Don't use multitabel select cross product in these queries....

Q1) Consider the query: SELECT E.Lname, E.Bdate, D.Mgr_ssn FROM EMPLOYEE AS E, DEPARTMENT AS D WHERE E.Salary >= 30000 AND D.Dname = Administration AND E.Dno = D.Dnumber; Apply the query on two...

Short-seller Carson Block released a report questioning whether NMC was understating its debt position by sneaking debt off balance sheet and announced that it would take a short position on NMC...

How is it possible that reciprocal dumping can be beneficial for aggregate welfare if identical commodities are moving between countries and transportation costs are being incurred?

The following transactions occurred during Moose Jaw Marketplace's first month ofoperations, February, 2 0 2 3 :Feb 1 Feb 4 Feb 6 Feb 7 The owner, John Openheart, created the company by investing $ 3...

gpt 9 3 9 .

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...