Consider the following customer records. Rescale the Age of the first customer using 0-1 normalization. Write your answer in the box to the nearest two decimal places. Age Female Income Married Children Loan Mortgage 48 1 17546.00 0 1 0 0 40 0 30085.10 1 3 1 51 1 16575.40 1 0 0 23 1 1 3 0 57 1 1 0 57 1 1 2 22 0 0 0 58 0 1 0 37 1 1 2 54 0 1 2 66 1 1 0 52 1 0 0 20375.40 50576.30 37869.60 8877.07 24946.60 25304.30 24212.10 59803.90 26658.80 1 0 0 1 1 1 0 1 0 0 0 0 0 1

Consider the following customer records. Rescale the Age of the first customer using 0-1 normalization. Write your answer in the box to the nearest two decimal places. Age Female Income Married Children Loan Mortgage 48 1 17546.00 0 1 0 0 40 0 30085.10 1 3 1 51 1 16575.40 1 0 0 23 1 1 3 0 57 1 1 0 57 1 1 2 22 0 0 0 58 0 1 0 37 1 1 2 54 0 1 2 66 1 1 0 52 1 0 0 20375.40 50576.30 37869.60 8877.07 24946.60 25304.30 24212.10 59803.90 26658.80 1 0 0 1 1 1 0 1 0 0 0 0 0 1

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Show all the different positions in the Staff table. • Show all the different branchNo in the Staff…

A: The SQL queries for the given question are provided below -

Q: Calculate the number of days that have passed between your birthday and the current date using an…

A: Given: Calculate the number of days that have passed between your birthday and the current date…

Q: Show Customer name (concatenate First Name and Last Name with a space between) and total number of…

A: The given data samples have the details about a Customer in CUSTOMER table and corresponding orders…

Q: The SQL query given below will return the Nth highest salary from the employee table. The value of N…

A: Let's discuss how query will be worked.

Q: Return how many artists are currently in the band, how many artists have ever been in the band (be…

A: To work with relational databases, you must use SQL. Records in databases can be added, searched…

Q: In order to compute the number of days that have passed between your birthday and the current date,…

A: A function is a short-lived subprogram that returns a single value, Before executing a function, its…

Q: If every student at a school is assigned a 4-digit person ID number, but 0 and 1 are not used in ID…

A: The question asks about the potential number of student ID numbers in a school where each student is…

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: We have employee table contains (emp-no, emp-name, emp-age, emp-salary, emp-department) write a…

A: Given Employee table contains the attributes: emp_no, emp_name, emp_age, emp_salary, emp_department

Q: Customer Ic 8710101022 Amirul 12 8413521122 11 Custom Roo er Name m ld 7311001111 Amran able De…

Q: USE MY SQL List all the data in your table movie_prod, sorted by the id of the movie (smallest…

A: MySQL is based on the SQL programming language and allows developers to store, organize, and…

Q: What was the amount of the total sale of all products (sum of quantity * price of the product) for…

A: The SQL query for the given question is provided below using the the class diagram reference.

Q: SQL: Change the salary of those employees in dept 4001, to be 1.5 times their current salary.

A: To write SQL statement to change the salary of those employees in dept 4001, to be 1.5 times their…

Q: e function to determine how many days have pa

A: Oracle function to determine how many days have passed since your birthday.

Q: Use the given data to classify the record below using the k-NN algorithm for k=1 to 5. Loan…

A: Based on the information you provided, we can classify the record with the given loan purpose,…

Q: If you want to know how many days have passed since your birthday, utilise an Oracle function.

A: A server-less platform called Oracle Functions allows developers to design, execute and grow apps…

Q: Find the listing of customers who did not make purchases during the invoicing period. Sort the…

A: SQL: SQL (Structured Query Language) is a programming language used to manage and manipulate data in…

Q: For each band that currently has a female member: Return the name of the band and each artist's…

A: The question has asked us to join three tables, namely, p_artist, p_band, and p_member, based upon…

Q: Display Customer name (concatenate First Name and Last Name with a space between) and total number…

A: In order to concatenate the 'FNAME' with 'LNAME' use the '+' sign to combine them. Use the SELECT…

Q: in SQL code give an example of number integer

A: in SQL code give an example of number integer answer in below step.

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Concept explainers

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.

Question

Consider the following customer records. Rescale the Age of the first customer using 0-1 normalization. Write your answer in the box to the nearest two decimal places.
Age Female Income Married Children
Loan
Mortgage
48
1
17546.00
0
1
0
0
40
0
30085.10
1
3
1
1
51
1
16575.40
1
0
1
0
23
1
20375.40
1
0
57
1
50576.30
1
0
57
1
37869.60
1
0
22
0
8877.07
0
0
58
0
24946.60
1
1
37
1
25304.30
1
1
54
0
24212.10
1
1
66
1
59803.90
1
0
52
1
26658.80
0
1
0
TOON NOO
0
0
2
2
0
0
1

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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

Perform the following queries in SPARQL on the given data. Data: @prefix : @prefix ns: :laptop ns:sellprice 760 :laptop ns:buying_price 620 :smartphone ns:sell_price 368 :smartphone ns:buying_price 323 a) Find profit on each item. b) List the items where profit is more than 70.
It's best to utilize an Oracle function to determine how many days have passed since your birthday.
Consider the STUDENT table given below: CODE NAME GPA YEAR 291 ALEX 3.1 2 938 MICHELE 2.3 1 931 JHON 3.3 1 182 JOE 3.4 2 190 REY 2.0 2 330 RON 3.9 3 Which of the following queries retrieve a table with the max GPA of each year sorted by the max GPA value. a. SELECT YEAR, MAX(GPA) FROM STUDENT GROUP BY YEAR ORDER BY MAX(GPA) b. SELECT YEAR, MAX(GPA) FROM STUDENT GROUP BY GPA ORDER BY YEAR c. SELECT YEAR FROM STUDENT GROUP BY YEAR ORDER BY MAX(GPA) d. SELECT YEAR, MAX(GPA) FROM STUDENT GROUP BY YEAR ORDER BY GPA
Perform second normalization based on the table information given.
Table: Employee EmpID 1 2 3 4 DeptID D01 D02 Name D03 Ronny Table: Department Kith John Anny Age HR 32 50 34 29 DeptName ADMIN Testing Deptal D D01 D03 D01 D02 Retrieve the Department names and the count of employees work in each Department, but only for department name with more than 2 employees work.
To compute the number of days between your birthday and the current date, which Oracle function should you use?
It is necessary to use an Oracle function in order to determine the number of days that have elapsed between your birthday and the current date.
The order of operands is significant in EXCEPT (MINUS) queries but is irrelevant in UNION queries?
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
John Silas is an employee in a Logistics company with ID = 02361. He was newly promoted with an increase of R2000 on his salary. Write an SQL query to update his record in the stafflist table.
Use the following tables to write the SQL queries: Table Name: Employees EMPLOYEE_ID FIRST_NAME HIRE DATE JOB_ID SALARY DEPARTMENT_ID 100 Steven 02/13/2008 AD PRES 24000 90 101 Neena 05/20/2010 AD_VP 17000 90 102 Lex 09/11/2013 AD VP 17000 90 103 Alexander 09/01/2010 IT PROG 9000 60 104 Bruce 01/17/2012 IT PROG 6000 60 105 David 02/21/2018 IT PROG 4800 60 106 Vali 10/04/2018 IT PROG 4800 60 107 Diana 10/06/2019 IT PROG 4200 60 114 Den 08/05/2015 PU_MAN 11000 30 115 Alexander 01/14/2016 PU CLERK 3100 30 Table Name: Departments Table Name: Locations DEPARTMENT_ID DEPARTMENT_NAME LOCATION_ID LOCATION_ID POSTAL CODE CITY COUNTRY_ID 10 Administration 1700 1400 26192 Southlake US 30 Purchasing 1700 1500 99236 South San Francisco US 50 Shipping 1500 1600 50090 South Brunswick US 1700 98199 Seattle US 60 IT 1400 1800 M5V 2L7 Toronto CA 90 Executive 1700 1900 YSW 9T2 Whitehorse CA 100 Finance 1700 1.Write SQL Command to, display employee id and job id who gets salary within the range of 4000…