Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 10, Problem 10.27PAE
Consider the customer table created in Figure 10-24 and populated with data as shown in Figure 10-27 Write the Hive script that will display the age-groups that exist in the data set and their average incomes.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Samples of 42 college students are considered for study and were categorized according to year level. The data set is
FreshmenFreshmenFreshmenSophomoreJuniorFreshmenSenior
SophomoreSeniorSeniorFreshmenSeniorSophomoreSophomore
JuniorSophomoreFreshmenFreshmenSophomoreSophomoreFreshmen
SeniorSophomoreSophomoreFreshmenFreshmenJuniorJunior
SophomoreJuniorSophomoreJuniorJuniorJuniorFreshmen
FreshmenSeniorJuniorFreshmenFreshmenFreshmenSophomore
Solution:ClassTallyFrequency (f)Percentage (%)
Total
Consider the scores of 50 Grade 7 students in Math.2939263520
2226363119
2026352528
2239323219
3732283320
2026353119
2531252220
4031193220
2228333919
2026373119
ScoresfPercentage
40
39
37
36
35
33
32
31
29
28
26
25
22
20
19
Total
Solution:
The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.
4 and 5
Chapter 10 Solutions
Modern Database Management
Ch. 10 - Prob. 10.1RQCh. 10 - Prob. 10.2RQCh. 10 - Prob. 10.3RQCh. 10 - Prob. 10.4RQCh. 10 - Prob. 10.5RQCh. 10 - What are the two main categories of technologies...Ch. 10 - Prob. 10.7RQCh. 10 - Prob. 10.8RQCh. 10 - Prob. 10.9RQCh. 10 - Prob. 10.10RQ
Ch. 10 - Prob. 10.11RQCh. 10 - Prob. 10.12RQCh. 10 - Prob. 10.13RQCh. 10 - Prob. 10.14RQCh. 10 - Prob. 10.15RQCh. 10 - Prob. 10.16RQCh. 10 - Prob. 10.17RQCh. 10 - Prob. 10.18PAECh. 10 - Prob. 10.19PAECh. 10 - Prob. 10.20PAECh. 10 - Prob. 10.21PAECh. 10 - Prob. 10.22PAECh. 10 - Prob. 10.23PAECh. 10 - Prob. 10.24PAECh. 10 - Prob. 10.25PAECh. 10 - Prob. 10.26PAECh. 10 - Consider the customer table created in Figure...
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
- Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1 Center, and Dose2 Center as shown below: CNIC Name Contact Dose1 Center Dose2 Center 22401-6645321-1 Nasir 3409991112 Lachi Kohat 2 14301-6045321-5 Shahab 3409991112 kohat 3 Dara The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who were vaccinated ‘Sinovac’ in the first dose, while Pfizer in the second dose.How many Viles of each type have been consumed so far. How many subjects are vaccinated from expired viles. Suggest the name of Incharge for the best performance award based on the highest number of subjects vaccinated on a single dayarrow_forwardThe Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys.arrow_forwardAdd two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment for each employee, and its default value should be the system date. The second column, named EndDate, contains employees date of termination.arrow_forward
- Write a PL/SQL script to print all the details of the Jobs table using a cursor. Your query must include %RowType (to access the column names and datatypes of jobs table), and a cursor attribute to print the total number of rows returned. DEPARTMENTS LOCATIONS DEPARTMENT_ID * DEPARTMENT_NAME F P * LOCATION_ID STREET_ADDRESS POSTAL_C MANAGER_ID LOCATION_ID JOB_HISTORY PF* EMPLOYEE_ID * START_DATE CITY P END DATE F * JOB_ID F STATE_PROVINCE F COUNTRY_ID DEPARTMENT_ID EMPLOYEES EMPLOYEE_ID FIRST_NAME LAST_NAME U * EMAIL PHONE_NUMBER HIRE_DATE * JOB_ID P. COUNTRIES P COUNTRY_ID COUNTRY_NAME F JOBS REGION_ID P * JOB_ID * JOB_TITLE MIN_SALARY MAX_SALARY SALARY COMMISSION_PCT REGIONS IF MANAGER_ID P * REGION_ID REGION_NAME F DEPARTMENT_IDarrow_forwardModify the PILOT table to add the attribute shown in the following table, with a precision and scale of (8,2).arrow_forwardTask 1: ' The Car Maintenance team wanted to ensure that the default price of the maintenance actions should not be empty and 0 instead if not specified. Alter the MAINTENANCE_TYPES table created in Chapter 8, Activity 1 to set the default MAINTENANCE_PRICE to 0. ANSWER IN MYSQL PLEASEarrow_forward
- Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT. ANSWER IN MYSQL PLEASEarrow_forwardQuestion 5 You are working with a database table that contains customer data. The table includes columns about customer location such as city, state, country, and postal_code. You want to check for postal codes that are greater than 7 characters long. You write the SQL query below. Add a LENGTH function that will return any postal codes that are greater than 7 characters long. 1 2 3 4 5 SELECT * FROM customer WHERE RunReset What is the last name of the customer that appears in row 10 of your query result? 1 pointarrow_forwardIn our dataset, each job has a predefined salary range. Expand on the previous query and explore this salary range per customer. The query should display the attributes as problem 1 but also include the name of their position, and salary ranges for each employee. Finally, add a column that calculates the difference between each employee’s current salary and the base (minimum) salary for their job. Renamed this last calculated field as “Pay_above_minimum”.arrow_forward
- The InstantRide Driver Relationship team wants to analyze the travel information of the low rated drivers. You will need to provide them with all the travel information of the drivers with the average rating lower than 4. The team wants to get in touch with the travelers and analyze their feedback. You need to run SELECT query and return all travel data from TRAVELS table filtered by the drivers who has lower rating than 4 in the DRIVERS table.arrow_forwardPLZ help with the following: Using oracle sql developer Translate your ER diagram into the form of SQL DDLs. Choose appropriatedata types for each attribute and include primary key and foreign key constraints, Check and NotNull constraints. Create tables using oralce developperarrow_forwardTask 5: ' The Driver Relationship team realized that there is no need for DRIVER_DRIVING_LICENSE_CHECKED field in the active drivers table. Since all the drivers are already active in InstantRide, their driving licenses should be checked regularly. The team wanted you to remove the field from the table. ANSWER IN MYSQL PLEASEarrow_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:CengageA 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
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY