Consider the COMPANY database as specified in Figure 3.6 and the FK ? PK relatio
ID: 3669107 • Letter: C
Question
Consider the COMPANY database as specified in Figure 3.6 and the FK ? PK relationships as specified in Figure 3.7, write relational algebra expressions to get answers from the following queries and show the answers (all answers are in the form of a relation/table).
1) List all the employees (Fname and Lname) whose salary is less than $35,000.
Figure 3.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Bdate Sex Salary Super ssn Dno Fname MinitLname John Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 8886655555 Alicia JZolaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 9876543214 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F43000 888665555 4 Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 3334455555 Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 5 Ahmad Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 4 ames EBorg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 DEPARTMENT DEPT LOCATIONS Dlocation Mgr ssn 333445555 987654321 888665555 Mgr start date 1988-05-22 1995-01-01 1981-06-19 Administration Stafford WORKS ON PROJECT Essn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Pno Hours Pnumber Plocation Dnum 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30 30.0 10 10.0 10 35.0 5.0 30 20.0 20 15.0 Computerization10 20 30 Houston Stafford Houston Stafford Reorganization 10 DEPENDENT 333445555 Alice 333445555 Theodore 333445555 Joy 987654321 123456789 Michael 123456789 123456789 Elizabeth Sex Bdate F 1986-04-05Daughter M 1983-10-25 Son F 1958-05-03 Spouse M 1942-02-28 Spouse M 1988-01-04 Son F 1988-12-30 Daughter F 1967-05-05Spouse 30 20 NULLExplanation / Answer
PROJECTFname,Lname (SELECTSalary < 35000(EMPLOYEE));
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.