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 - Chapter Review Problems - Page 452: 16

Answer

See the explanation

Work Step by Step

a. To find which branches offer the course IT665, you can use the following SQL query: ```sql SELECT BName FROM Branch WHERE ID = 'IT665'; ``` b. To list all the branches present in the Branch relation, you can use the following SQL query: ```sql SELECT DISTINCT BName FROM Branch; ``` c. To find which branches offer 4-credit courses, you can use the following SQL query: ```sql SELECT DISTINCT BName FROM Branch WHERE Credits = 4; ```
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.