Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 5, Problem 5.51PAE
Program Plan Intro
To determine which student has the highest read score.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Classify students according to the total number of hours they have completed. (Less than30=freshman, 30 to 59 is sophomore, 60 to 89 is junior, 90+ senior)
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id.
D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table
Here are the tables and the columns within the table
CONSULTANTS
- CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID
.
COUNTRIES
- COUNTRY_ID- COUNTRY_NAME-REGION_ID
.
CUSTOMERS
- CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT
.
DEPARTMENTS
- DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID
.
EMPLOYEES
-…
WEEK 4 ASSIGNMENT
Complete the following exercises:
Using your student table, what is the average GPA?
Using your student table, what is the minimum GPA?
Explain why the following select statement is incorrect (your answer should be limited to no more than a few sentences):
SELECT COUNT(first_name) FROM student
Explain the following select statement (your answer should be limited to no more than a few sentences):
SELECT MIN(DISTINCT gpa) FROM student
Chapter 5 Solutions
Modern Database Management
Ch. 5 - Define each of the following terms: data...Ch. 5 - Match the following terms to the appropriate...Ch. 5 - Prob. 5.3RQCh. 5 - Prob. 5.4RQCh. 5 - Prob. 5.5RQCh. 5 - Prob. 5.6RQCh. 5 - List six potential benefits of achieving an SQL...Ch. 5 - Prob. 5.8RQCh. 5 - Distinguish among data definition commands, data...Ch. 5 - Prob. 5.10RQ
Ch. 5 - Prob. 5.11RQCh. 5 - Explain the purpose of indexing in database...Ch. 5 - What are the potential consequence of...Ch. 5 - Prob. 5.14RQCh. 5 - Explain and provide at least one example Of how to...Ch. 5 - Prob. 5.16RQCh. 5 - What is the difference between COUNT, COUNT...Ch. 5 - What is the evaluation order for the Boolean...Ch. 5 - If an SQL statement includes a GROUP BY clause,...Ch. 5 - Prob. 5.20RQCh. 5 - Prob. 5.21RQCh. 5 - Prob. 5.22RQCh. 5 - Explain why SQL is called a set-oriented language.Ch. 5 - When would the use of the LIKE key word with the...Ch. 5 - Prob. 5.25RQCh. 5 - Prob. 5.26RQCh. 5 - In what order are the clauses of an SQL statement...Ch. 5 - Within which clauses of an SQL statement can a...Ch. 5 - Prob. 5.29RQCh. 5 - Prob. 5.30RQCh. 5 - Prob. 5.31RQCh. 5 - Explain the difference between the WHERE and...Ch. 5 - Prob. 5.33RQCh. 5 - Write a database description for each of the...Ch. 5 - Analyze the database to determine whether or not...Ch. 5 - Prob. 5.36PAECh. 5 - To enforce referential integrity, before any row...Ch. 5 - Write SQL data definition commands for each of the...Ch. 5 - Write SQL commands for the following: Create two...Ch. 5 - Write SQL queries to answer the following...Ch. 5 - Write SQL queries to answer the following...Ch. 5 - Write SQL queries to answer the following...Ch. 5 - Write SQL queries to answer the following...Ch. 5 - Prob. 5.44PAECh. 5 - Prob. 5.45PAECh. 5 - Prob. 5.46PAECh. 5 - What is the average Read score for all students?...Ch. 5 - Prob. 5.48PAECh. 5 - What are the TutorIDs for tutors who have not yet...Ch. 5 - Prob. 5.50PAECh. 5 - Prob. 5.51PAECh. 5 - Prob. 5.52PAECh. 5 - Prob. 5.53PAECh. 5 - Prob. 5.54PAECh. 5 - How many tutors have an Active status in the...Ch. 5 - Prob. 5.56PAECh. 5 - Modify the Product_T table by adding an attribute...Ch. 5 - Enter sample data of your own choosing into...Ch. 5 - Add an order to the Order_T table and include a...Ch. 5 - Use the Pine Valley database to answer the...Ch. 5 - Prob. 5.61PAECh. 5 - Prob. 5.62PAECh. 5 - Prob. 5.63PAECh. 5 - Prob. 5.64PAECh. 5 - Prob. 5.65PAECh. 5 - Prob. 5.66PAECh. 5 - Prob. 5.67PAECh. 5 - Modify query in P&E 5-67 by considering only those...Ch. 5 - Prob. 5.69PAECh. 5 - Prob. 5.70PAECh. 5 - Prob. 5.71PAECh. 5 - Prob. 5.72PAECh. 5 - Prob. 5.73PAECh. 5 - Prob. 5.74PAECh. 5 - Prob. 5.75PAECh. 5 - Prob. 5.76PAECh. 5 - Prob. 5.77PAECh. 5 - Assume that for those materials the ID of which...Ch. 5 - Prob. 5.79PAECh. 5 - Prob. 5.80PAECh. 5 - Prob. 5.81PAECh. 5 - Prob. 5.82PAECh. 5 - Prob. 5.83PAECh. 5 - Prob. 5.84PAECh. 5 - Prob. 5.85PAECh. 5 - Prob. 5.86PAECh. 5 - Prob. 5.87PAECh. 5 - Prob. 5.88PAECh. 5 - Prob. 5.89PAECh. 5 - Prob. 5.90PAECh. 5 - Prob. 5.91PAECh. 5 - Prob. 5.92PAECh. 5 - Prob. 5.93PAE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Show students’ first name and last name, the course numbers the student took (don’t include currently taking) and its credits, and the grades of the courses in the ascending order of last name and first name and descending order of course number STUDENT TABLE 100001 Johnson Ariel 2000-07-10 Y 100002 Green Robin 2001-11-02 Y 100003 Johnson Charles 1995-01-12 Y 100004 Pearson Jeffery 1996-02-06 Y 100005 Sears Miguel 1998-10-31 Y 100006 Kyle Leah 2000-05-29 Y 100007 Myers Lynda 1980-08-24 Yarrow_forwardWho has rented movies in Japanese language? Return only the first five distinct results in alphabetical order by last name.(Hints: In the language table, there is a field “name” that contains the film language names.) Display: first name and last namearrow_forwardSelect the best answer from the given choices: Queries can be used within statement(s): update delete All of the answers Insertarrow_forward
- Show students’ first name, last name, the grades of the students, and the credits of the course for the students who took (don’t include currently taking) the course ‘MISM4221’. STUDENT TABLE 100001 Johnson Ariel 2000-07-10 Y100002 Green Robin 2001-11-02 Y100003 Johnson Charles 1995-01-12 Y100004 Pearson Jeffery 1996-02-06 Y100005 Sears Miguel 1998-10-31 Y100006 Kyle Leah 2000-05-29 Y100007 Myers Lynda 1980-08-24 Yarrow_forwardWEEK 9 ASSIGNMENT#6 Part II: Complete the following exercise: Using a subquery, select student first name where the student is in the student course table. Using a subquery, select the course id where the average GPA is 2. Using a subquery, select the course id where the average GPA is greater than 2. Using a subquery, select student first name where the student is not in the student course tarrow_forwardPlease provide an example that works for all 3 sub-questions.arrow_forward
- Determine the sorts of books that are presently available in the inventory. Only one of each category should be included.arrow_forwardNote:- Do correct answer get upvote Else downvotedarrow_forwardRank Normal forms where each form is a subset of the form above it. [ Select) [Select) First Normal Form Second Normal Form Third Normal Form BCNF Fourth Normal Form I Select] Question 5arrow_forward
- How are the column heading labels in a result table changed?arrow_forwardTask 2: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer for which the invoice was created.arrow_forwardPerform first normalization based on the table information given.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr