Question: Write the following queries in SQL, using the university schema. (We suggest you actually run these queries on a database, using the sample data that

Write the following queries in SQL, using the university schema. (We suggest you actually run these queries on a database, using the sample data that we provide on the web site of the book, db book.com. Instructions for setting up a database, and loading sample data, are provided on the above web site.)

a. Find the titles of courses in the Comp. Sci. department that have 3 credits.

b. Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result.

c. Find the highest salary of any instructor.

d. Find all instructors earning the highest salary (there may be more than one with the same salary).

e. Find the enrollment of each section that was offered in Fall 2017.

f. Find the maximum enrollment, across all sections, in Fall 2017.

g. Find the sections that had the maximum enrollment in Fall 2017.

Step by Step Solution

★★★★★

3.40 Rating (172 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a SELECT DISTINCT title FROM course WHERE deptname Comp Sci AND cre... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database System Concepts Questions!

The delivered-equipment cost for setting up a production and assembly line for high-sensitivity, gas-damped accelerometers is $650,000. If the direct cost and indirect cost factors are 1.82 and 0.31,...

The delivered equipment cost for setting up a production and assembly line for two-way floating ball valves is $650,000. If the direct cost and indirect cost factors are 1.82 and 0.31, respectively,...

Write the following queries in relational algebra, using the university schema. a. Find the ID and name of each instructor in the Physics department. b. Find the ID and name of each instructor in a...

3. (4.5 points) (Note: Read the schema of each table in the university database from ddl.sql or using schema before working on this problem.) Write the following queries in SQL, using the university...

**THE FOLLOWING IS THE ddl.sql SCHEMA*** create table classroom (building varchar(15), room_number varchar(7), capacity numeric(4,0), primary key (building, room_number) ); create table department...

Use the Schema: CREATE TABLE classroom (building varchar(15), room_number varchar(7), capacity numeric(4,0), primary key (building, room_number) ); CREATE TABLE department (dept_name varchar(20),...

(5 points) (Note: Read the schema of each table in the university database from ddl.sql or using schema before working on this problem.) Write the following queries in SQL, using the university...

1 Find the names of courses in Comm.Sci.department which have 3 credits. 2 For the student with ID 1 1 4 5 5 . show all course _ ( i ) d and title of all courses registered for by the student. 3 Find...

This assignment uses an actual PostgreSQL database with data about a university. The schema of the database is provided below. Keys are in bold face and underlined, field types are omitted; assume...

We don't actually need them to do this. Just SQL commands that would appropriately filter to what is specified. Unfortunately i cannot upload files here. The structure is provided in the first...

Identify any barriers to communication in this situation. How could they have been reduced?

1. ______________ was important to the success of the Louis and Clark expedition. a. Zebulon Pikeb. B. Sacagaweac. C.James Wilkinsond. D.Facundo Melgares 2. Following a price drop in the 1790s,...

Grand Company's cost of ending work in process inventory is twice the amount of its beginning balance; as a result: Multiple Choice Total manufacturing costs for the period must exceed the cost of...

Discuss the impact of the Brundtland Report in terms of sustainability.

Repeat Exercise 3.5 using the tuple relational calculus and the domain relational calculus.

Let R = (A, B) and S = (A, C), and let r(R) and s(S) be relations. Write relational-algebra expressions equivalent to the following domain-relationalcalculus expressions: a. { | b ( r...

Let R = (A, B) and S = (A, C), and let r(R) and s(S) be relations. Using the special constant null, write tuple-relational-calculus expressions equivalent to each of the following: a. r 1 s b. r 1 s...

Because commodity futures are a zero-sum game, as many speculators make Money as lose money. O True O False To reduce commissions on commodity futures, invest in long-term contracts. O True O False...

The Austin Heights Commercial Bank's (AHCB) simplified balance sheet (in millions of US$) looks as follows: 230 Assets Reserves Fixed Rate Loans and Securities Variable Rate Loans and Securities...

Eagle Sports Supply has the following financial statements. Assume that Eagle's assets are proportional to its sales. a . Find Eagle's required external funds if it maintains a dividend payout ratio...