Modern Database Management
13th Edition
ISBN: 9780134773650
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
Database systems
In SQL
MurachCollege database.
Provide a list of all of the students, the number of courses they are taking, and the number of different instructors they have across all of their courses.
The first column should provide the last name of each student (column titled Student Last Name).
The second column should provide the number of courses that each student is taking (column titled Number of Courses).
The third column should provide the number of different instructors that each student has for all of the courses they are taking (column titled Number of Different Instructors).
No other columns should be provided in the result.
Organize the result by student last name in alphabetical order.
48
Refer to the given tables.
Salesperson Salesperson Commission Year of Department Manager
Number
Percentage
Product
Number
SALESPERSON table
Salesperson
Number
PRODUCT table
QUANTITY table
Frdig
Quantity
Which feature of the tables makes it clear that they are in second normal form?
Each non-key attribute is fully functionally dependent on the key of that table.
O The tables are completely free of data redundancy.
Each non-key attribute functions completely independently of the key of that table.
O The tables are dependent on one another in descending order.
Jh
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:
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
- Write a query to display the first name, last name, and email address of employees hired from January 1, 2005, to December 31, 2014. Sort the output by last name and then by first name. Write the answer to each query and the result of the query (screen capture). You should submit all design work, program documentation, and relevant sample screen shots of your implementation. A script file with all database creation and table populating is required.arrow_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_forwardThe 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.arrow_forward
- 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_forwardWrite 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_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
arrow_back_ios
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