Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 6: Problem 10

Consider the University database. 1\. Create a query to list the department codes (with no duplicates) of departments that offer 6 credit hour courses. 2\. Modify your query to list the department names too.

Short Answer

Expert verified
1. The SQL query to get department codes of departments offering 6 credit hour courses is: SELECT DISTINCT dept_code FROM Courses WHERE credit_hours = 6; 2. The modified query to get department names as well is: SELECT DISTINCT dept_code, dept_name FROM Courses WHERE credit_hours = 6;

Step by step solution

01

Write the SQL query to list distinct department codes offering 6 credit hours

The keyword DISTINCT is used to return unique results in the query results. The WHERE clause is used to filter the results by selecting departments offering courses of 6 credit hours. The query should be written like: \n\n SELECT DISTINCT dept_code FROM Courses WHERE credit_hours = 6;
02

Test Your Query

Run your query in your SQL environment to see if it returns the expected results. Make sure that no duplicate department codes are returned in the results and only the departments offering 6 credit hour courses are listed.
03

Modify the Query to include Department Names

To add department names to the result, just extend the SELECT statement with the dept_name attribute. The modified query should be written like: \n\n SELECT DISTINCT dept_code, dept_name FROM Courses WHERE credit_hours = 6;
04

Test Your Modified Query

Rerun your modified query in your SQL environment. This time it should return not only the distinct department codes but also the department names of those departments that offer 6 credit hour courses.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Start your free trial

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Consider the Genealogy database. 1\. Create a query with two parameters: a start date and an end date. The query will list all persons whose birth dates fall in the range from start date to end date.

Consider the Library database. 1\. Write a query to list books due on a specific date (a parameter). 2\. Write a query to list books written by a specific author (a parameter).

Consider the Orders database and the Employee table. 1\. Write a query to list the employee who does not report to anyone. 2\. Write a query to list each employee and the number of employees they supervise.

Consider the University database: 1\. For each department list the department code and the largest value for credit hours. 2\. For each department list the department code, department name, and the number of courses.

Consider the following SQL statements and show how each statement would appear in Design View. You can confirm your result if you create a query, switch to SQL View, type the query statement and then switch to Design View. Unfortunately, if you make any syntax errors, Access will be unable to switch to Design View. Your database must contain the tables in the From clause. 1\. SELECT Products.ProductID, Products.ProductName, Categories.CategoryName FROM Categories INNER JOIN Products ON Categories.CategoryID = Products.CategoryID WHERE Categories.CategoryName = "Beverages" AND Products.Discontinued = Yes; 2\. SELECT Auto.Year, Dealer.name FROM Auto INNER JOIN Dealer ON Auto.Did = Dealer.Did WHERE Auto.Price > 10000 OR Auto.Colour = “blue” ; 3\. SELECT Auto.Year, Dealer.name FROM Auto RIGHT OUTER JOIN Dealer ON Auto.Did = Dealer.Did WHERE Auto.Price > 10000 OR Auto.Colour = “blue” ;
See all solutions

Recommended explanations on Computer Science Textbooks

Data Structures

Read Explanation

Game Design in Computer Science

Read Explanation

Problem Solving Techniques

Read Explanation

Functional Programming

Read Explanation

Computer Programming

Read Explanation

Algorithms in Computer Science

Read Explanation
View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free