Database Systems Concepts 7th Edition Solutions – Chapter 3

Database Systems Concepts 7th Edition Solutions is a highly recommended book for people interested in databases. The free version of this book can be downloaded from HERE.

Database Systems Concepts 7th Edition Solutions - Chapter 3
Database Systems Concepts 7th Edition Solutions – Chapter 3

Practice Excercise

3.1 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.

Database Systems Concepts 7th Edition Solutions
Answer

Selects title of courses which matches with Com.Sci and the credits it has equals to 3.


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

Database Systems Concepts 7th Edition Solutions - Chapter 3
Answer

Selects No Duplicate (Distinct) IDs on all the Students who Einstein taught

c. Find the highest salary of any instructor (there may be more than one Instructor earning the highest salary).

Database Systems Concepts 7th Edition Solutions
Answer

Selects Max Salary of Instructor Table.


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

3.1d
Answer


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

Database Systems Concepts 7th Edition Solutions - 3.1e
Answer


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

3.1f
Answer


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

 3.1g
Answer

Other Questions Related to Database Systems Concepts 7th Edition Solutions – Chapter 3 are going to be Posted Sooner.

READ MORE

Data Structures related posts visit HERE

Python-related posts Visit HERE

C/C++ related posts Visit HERE

Databases related posts Visit HERE

Algorithms related posts visit HERE

Data Science related posts visit HERE

Leave a Comment

  Canva Pro Crack Filmora Pro Crack Spotify Premium Free Download Tradingview Premium Free