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

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
To compute the number of days between your birthday and the current date, which Oracle function should you use?
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.
#SQL Question Use TopBabyNamesbyState.csv1 and write queries to extract the following information: 4) How many unique names are there in this dataset? 5) Which name in which state and in which year had the highest number of occurrences. 6) What is the average occurrence of “Jessica” as a top name in the state of CA? 7) How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”. 8) The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. 9) Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.
Use a data set of property value from 2007 - 2019. The data contains sale price for houses and units with 1, 2, 3, 4, and 5 bedroom. The data is: date of sale; price in dollars; property type (unit or house); number of bedrooms Using R, calculate and show the mean price of the house properties and unit properties. ```{r} ```
This is for SQL Give me a list of all of our vendors (by their name) and, if they have an invoice, give me the total number of invoices we have from them and the invoice date of their first invoice. The invoice date results should be provided in a way that shows the date only in the following format: mm/dd/yyyy (e.g. 10/04/2021)
Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).