Question: A) Express the question as a relational algebra query. B) Show the results of executing your query on the Company Database. ================================================================= 1) What are

A) Express the question as a relational algebra

A) Express the question as a relational algebra query.

B) Show the results of executing your query on the Company Database.

=================================================================

1) What are the names of the projects conducted in Houston?

2) What are the names of the oldest and youngest employees?

3) How many hours are spent on each project conducted in Stafford?

4) How many male employees have a salary greater than 35000?

5) What are the name of the departments not located in Houston or Stafford?

6) How many employees are in each department?

7) What is the name of the employee has the highest salary?

Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Fname Minit Dno John B 5 Franklin T 5 Alicia J 4 Jennifer S Lname Ssn Bdate Address Sex Salary Super_ssn Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 Wallace | 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M. 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL Ramesh K 5 A Joyce Ahmad V James E 1 DEPARTMENT DEPT LOCATIONS Dname Dnumber Mgr_start_date Dnumber Dlocation Mgr_ssn 333445555 5 1988-05-22 1 Houston Research Administration 4 987654321 1995-01-01 4 Stafford Headquarters 1 888665555 1981-06-19 5 Bellaire 5 Sugarland Houston 5 PROJECT WORKS ON Essn Pno Hours Pname Pnumber Plocation Dnum 1 32.5 ProductX 1 Bellaire 5 123456789 123456789 2 7.5 ProductY 2 5 Sugarland Houston 666884444 3 40.0 Productz 3 5 453453453 1 20.0 10 Stafford 4 453453453 2 20.0 Computerization Reorganization Newbenefits 20 Houston 1 Ic 333445555 10.0 30 Stafford 4 333445555 3 10.0 333445555 10.0 DEPENDENT 333445555 10.0 Essn Sex Bdate Dependent_name Alice 999887777 30.0 333445555 F 1986-04-05 999887777 10 10.0 333445555 Theodore M 1983-10-25 3981 |9| 33 Relationship Daughter Son Spouse Spouse Son 987987987 10 35.0 333445555 F 1958-05-03 Joy Abner 987987987 30 5.0 987654321 M 1942-02-28 987654321 20.0 123456789 Michael M 1988-01-04 987654321 15.0 123456789 Alice F 1988-12-30 Daughter Spouse 888665555 NULL 123456789 Elizabeth TI 1967-05-05 Select Example (a) o (DNO-4 AND SALARY>25000) OR (DNO-S AND SALARY330000 (EMPLOYEE). (a) FNAME MINIT LNAME SSN BDATE ADDRESS Franklin Wong 333445555 1955-12-08 638 Voss, Houston, TX Jennifer Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Ramesh Narayan 666884444 1962-09-15 975 FireOak, Humble, TX SEX SALARY SUPERSSN DNO M 40000 888665555 5 F 43000 888665555 4 M 38000 333445555 5

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 General Management Questions!

The following questions refer to the Company Database, for each question below: A) Express the question as a relational algebra query. B) Show the results of executing your query on the Company...

Consider two relation instances below, with the given Schemas For EACH question (query) below: 1. Write a Relational Algebra Expression, and Show its results, Also 3. Write the DML that the Oracle...

Based on the relational schema below: Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pcttime: integer) eptdteg er imegen Express the following queries...

Please Answer the following 1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is...

Specify the following queries on the COMPANY relational database schema shown in Figure 5.5belowusing relational algebra expressions. Also show the result of each query as it would apply to the...

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...

Database Management Systems Question 1. (16 points) Exercise 8.16 (a, c, e and i) on pages 281 - 282. Specify the follow-ing queries on the COMPANY relational database schema shown in Figure 5.5...

Specify the following queries on the COMPANY relational database schema using relational algebra operators. Also show the result of each query as it would apply to the database state of Figure 1 . 6...

Question 1. (16 points) Exercise 6.16 (a, c, e and i) on pages 281 - 282. Specify the follow- ing queries on the COMPANY relational database schema shown in Figure 5.5 using the relational algebra...

Consider the following information: rUS = 4%; rUK = 7% E0 = 2.00 dollars per pound F0 = 1.98(1-year delivery) Where the interest rates are annual yields on U.S. or U.K. bills. Given this information:...

The population P is P(t) = 2.0 106 + 2.0 104t and the weight per person W(t) is W(t) = 80 - 0.005t2. The total mass of a population is the product of the number of individuals and the mass of each...

The Cly of Algonguin maintains iss books to prepare fund accouming stavenents and reconds mobehout adjugmencs in order to prepere governmem - wife statements. Kou are to prepare, in journal fom,...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...