Database Question Based on the given database, answer the following questions EM

Question

Database Question Based on the given database, answer the following questions EMPLOYEE PROJECT 101 News 102 Senior 03 ArboughJune 104 Ramoras Anne 105 Johnson 106 Smithfield William 107 Alonzo 108 Washington Ralph 109 Smith 110 Olenko 111 Wabash 112 Smithson Darlene 113 Joenbrood Delbert 114 Jones 11/8/00 0:00 7/1289 0:00 121/97 0:00 11/15/88 0.00 2/1/94 0:00 6/22/05 0:00 1010/94 0:00 501 503 501 Evergreen105 Amber Wave 10 Roling Tide 113 8 8/22/89 0:00 511 7/18/99 0:00 2/1196 0:00 4/4/89 0.00 10/23/95 0:00 11/15/94 0:00 8/20/91 0:00 1/25/90 0:00 3/5/95 0:00 19/94 0:00 114/06 0:00 ASSIGNMENT 115 Bawang Travis 116 Pratt 17 WilliamsonAngie 118 Frommer 511 510 34/14 0:00 4/14 00 5/14 000 5/14 000 514 000 14 000 25 514 000 514 000 25 35/14 000 14 0:00 14 000 /14 0005 36/14 0:00 25 614000 6/14 000 14 000 14 0:00 614 0:008 3614 0:00 15 714000 814 000 36 25 510 113 101 35.75 96.75 38 Systems Analyst Database Designer 105 Electrical Engineer84.5 Mechanical Engineer 67.9 Civil Engineer Clerical Support DSS Analyst Applications Designer 48.1 Bio Technician 504 55.78 26.87 45.95 112 34.55 18.36 27 510 Write expressions in the Relational Algebra language to answer the following queries o Find EMP NUM of the employees who participate the project with PROJ_NUM-15 o Find FNAME, LNAME, and JOB-DESCRIPTIONM of the employee with EMP.NUM=108 o Find FNAME, LNAME, JOB_DESCIPTION, and JOB_CHG_HOUR of the manager of the project 'Rolling Tide'

Explanation / Answer

Solution:

Based on the given tables EMPLOYEE, PROJECT, JOB and ASSIGNMENT, the querues in the Relational Algebra language are given below:

1st Query:

select EMP_NUM from PROJECT where PROJ_NUM = 15

2nd Query:

select EMPLOYEE.EMP_FNAME, EMP_FNAME, EMPLOYEE.JOB_CODE, JOB.JOB_DESCRIPTION

from EMPLOYEE, JOB

where EMPLOYEE.EMP_NUM = 108

and JOB.JOB_CODE = 501

3rd Query:

select EMPLOYEE.EMP_FNAME, EMP_FNAME, EMPLOYEE.JOB_CODE, JOB.JOB_DESCRIPTION, JOB.JOB_CHG_HOUR, PROJECT.PROJ_NAME, PROJECT.EMP_NUM

from EMPLOYEE, PROJECT, JOB

where EMPLOYEE.EMP_NUM = 113,

PROJECT.PROJ_NAME = 'Rolling Tide'

and JOB.JOB_CODE = 508

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.