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: 4


converting To SQL

Work Step by Step

select JobTitle from JOB where Dept = “PERSONNEL” select EMPLOYEE.Name, JOB.Dept from JOB, ASSIGNMENT, and EMPLOYEE where (Job.Job = ASSIGNMENT.JobId) and (ASSIGNMENT.EmplId EMPLOYEE.EmplID) and (ASSIGNMENT.TermDate “*”)
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.