Computer Science: An Overview: Global Edition (12th Edition)

Published by Pearson Higher Education
ISBN 10: 1292061162
ISBN 13: 978-1-29206-116-0

Chapter 9 - Database Systems - Section 9.2 - The Relational Model - Questions & Exercises - Page 432: 3

Answer

solution 1

Work Step by Step

One solution is TEMP1 ← JOIN JOB and ASSIGNMENT where JOB.JobId = ASSIGNMENT.JobId TEMP2 ← SELECT from TEMP1 where TermDate = “*” TEMP3 ← JOIN EMPLOYEE and TEMP2 where EMPLOYEE.EmplId = TEMP2.EmplId RESULT ← PROJECT Name, Dept from TEMP3
Update this answer!

You can help us out by revising, improving and updating this answer.

Update this answer

After you claim an answer you’ll have 24 hours to send in a draft. An editor will review the submission and either publish your submission or provide feedback.

GradeSaver will pay $15 for your literature essays
GradeSaver will pay $25 for your college application essays
GradeSaver will pay $50 for your graduate school essays – Law, Business, or Medical
GradeSaver will pay $10 for your Community Note contributions
GradeSaver will pay $500 for your Textbook Answer contributions