Income < 60 no yes (non-owner 12 12 Lot_Size < 21 Lot_Size < 20 non-owner owner 7 1 5 11 non-owner owner Income < 85 owner 7 0 0 1 0 7 non-owner 5 4 non-owner owner 5 1 0 3 This classification tree sorts customers who have either purchased and become owners of a riding mower or not based on their annual income (in Kilobucks) and the size of their home lot (in 1000s of square feet). Each node of the tree ists the number of non-owners and owners in that partition and the classification decision based on a majority vote. Suppose we impose a stopping criterion that prevents a splitting that yields a eaf with fewer than 3 cases. Which splitting question would be pruned in this case?

Income < 60 no yes (non-owner 12 12 Lot_Size < 21 Lot_Size < 20 non-owner owner 7 1 5 11 non-owner owner Income < 85 owner 7 0 0 1 0 7 non-owner 5 4 non-owner owner 5 1 0 3 This classification tree sorts customers who have either purchased and become owners of a riding mower or not based on their annual income (in Kilobucks) and the size of their home lot (in 1000s of square feet). Each node of the tree ists the number of non-owners and owners in that partition and the classification decision based on a majority vote. Suppose we impose a stopping criterion that prevents a splitting that yields a eaf with fewer than 3 cases. Which splitting question would be pruned in this case?

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: 3. Write a query to display the book number, book title, and subject for every book sorted by book…

A: In the database management and information organization, a common scenario involves designing…

Q: Model Vin Price VEHICLE CAR TRUCK SUV Engine_size Tonnage No_seats VEHICLE Vin price Model CAR Vin…

A: Map this schema to a set of relationships. 1) CAR entity relationship: Merge the SALES…

Q: he following shows a training company’s workshops, the number of days of each, and their…

A: In this question we have to calculate and display the total cost of attending a workshop, including…

Q: c) Write a query to display the patron ID and the average number of days that patron keeps books…

A: Algorithm:Select Data: Start by selecting the necessary data from the PATRON and CHECKOUT…

Q: Write SQL statement that retrieve the department_name that has the maximum number of employees:…

A: The given is the requirement to find the department_name from depart table for the department that…

Q: Using R calculate the total income for each of the bedroom types from the chart. Sort the output…

A: Here is the total income for each of the bedroom types & the Output from High to low income…

Q: 2. Write a query to display the checkout number, checkout date, and due date for every book that has…

A: Algorithm:Select Data: Select the desired columns Check_Num, Check_Out_Date, and Check_Due_Date.Join…

Q: Find those job categories whose maximum salary among the people hired after 1980 is more than 2500…

A: 1)To find those job categories whose maximum salary among the people hired after 1980 is more than…

Q: 5. Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The problem involves retrieving key information from a database tracking book checkouts by patrons.…

Q: Conference Planning The following table shows a training company's workshops, the number of days of…

A: Code for an application that lets the user select a workshop from one ListBox and a location from…

Q: Find the staff name who has the maximum salary for each branch Find the staff name who has the…

A: SQL is the Structured Query Language, which is the computer language for storing, manipulating and…

Q: what is a suitable name and data type for "the percentage of people that can program computers"

A: The percentage of people can be any value including some fractional value. So, we need to choose…

Q: Questions 1. Explain why the data in the table is not in First Normal Form.

A: Note: As per Bartleby's answering guidelines, only one question can be answered ata time. Hence,…

Q: .Display the seating capacity, fuel capacity, and miles per gallon for all aircraft manufactured by…

A: The correct answer is given below with an explanation. I cannot attach the output as I don't have…

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition. student…

Q: Is [CLASS_CODE, CLASS_NAME, STU_NUM, STU_NAME] a Superkey? Why? Is [CLASS_CODE, CLASS_NAME, STU_NUM]…

A: Dear Student, A superkey is a combination of key attributes which can identify each tuple uniquely.…

Q: Adoption(AnimalID, SIN, AdoptDate, chipNo) Formulate the following queries in SQL; 1. Create the…

A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…

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: Muscat Special Cleaning Service company has been providing building maintenance and cleaning service…

A: ALGORITHM:- 1. Take input details from the user for 5 houses. 2. Calculate the total maintainence…

Q: Happy Shop sells different products to the customers. A customer could buy one or more products at a…

A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…

Q: 2. Explain why the data in the table is not in Third Normal Form. • For this question you cannot say…

A: Answer 2. A table is considered to be in third normal form if it looks like this:If it's in the…

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…

Q: price 29.8.29 m sell city store sid S1001 S1002 $1003 store table sid city Union Edison Newark sid…

A: In the ER diagram we can see that we have the three entities those entities are Store , sell and…

Q: Define users, giving the three groups of users there are.

A: Users A user is a person who utilizes a computer or network service. It includes expert programmer…

Concept explainers

Eight puzzle problem

The N-puzzle problem contains N tiles (N+1 including empty tiles) where the value of N can be 8, 15, 24, etc. The puzzle is divided into the square root of (N+1) rows and the square root of (N+1) columns. These problems have an initial state or configuration and a goal state or configuration. The puzzle can be solved by shifting the tiles one by one in the empty space. The objective is to place the numbers on the tiles to match the final state using the empty space. The other name for the N-puzzle problem is the sliding puzzle.

Question

yes
Income < 60
no
(non-owner
12 12
Lot_Size < 21
Lot_Size < 20
owner
5 11
non-owner
7 1
non-owner
owner
Income < 85
owner
7 0
01
0 7
non-owner
5 4
non-owner
owner
5 1
0 3
This classification tree sorts customers who have either purchased and become
owners of a riding mower or not based on their annual income (in Kilobucks)
and the size of their home lot (in 1000s of square feet). Each node of the tree
lists the number of non-owners and owners in that partition and the
classification decision based on a majority vote.
Suppose we impose a stopping criterion that prevents a splitting that yields a
leaf with fewer than 3 cases.
Which splitting question would be pruned in this case?

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 with 1 images

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

Table EMP Column name Column type Integer Up to 10 characters Integer Integer Example entry 7369 Description Employee ID number Employee surname ΕMPNO ENAME SMITH Employee's job title No ID no. of employee's manager Date employment started Monthly salary JOBNO 10 MGR 7566 HIREDATE Date 17/12/1980 SAL Integer 1600 Table JOB Column type Integer Up to 15 Column name Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN characters c) Write SQL statements to define referential integrity constraints on EMP table and give SQL examples to describe the different ways that referential integrity constraints can cause the database system to behave when a user attempts to update a table row. (Maximum 300 words).
It has to be based on this table
The data in this table is as follows: Team Dragons Carp Bay Stars Marines Ham Fighters The latest scores from the Japanese Baseball League are in the table with schema Scores(Team, Opponent, RunsFor, RunsAgainst) Lions Tigers Swallows Giants Hawks Buffaloes O a. Hawks Opponent Tigers Swallows Giants Hawks Buffaloes O b. Dragons O c. Buffaloes O d. Giant Golden Eagles Dragons Carp Bay Stars Marincs Ham Fighters RunsFor 5 3 1 Bay Stars 6 3 Tigers Ham Fighters 5 1 8 4 2 RunsAgainst 3 6 Golden Eagles Lions 12 What is the result of executing the following query on this data? 6 1 3 6 12 5 4 2 5 1 8 Identify, in the list below, a row of the result. Marines SELECT Team, Opponent FROM Scores WHERE Team LIKE '% %' OR Opponent LIKE '_i%';
In the following ER diagram, the Key for LEG_INSTANCE must include Airport_code City State Name Company Type_name Max_seats Date Seat_no AIRPORT Leg_no M CAN LAND N Airplane_id Number AIRPLANE_ TYPE TYPE 1 N AIRPLANE SEAT Airport_code Seat_no Scheduled_dep_time Total_no_of_seats Customer_name Scheduled_arr_time Scheduled_dep_time Dep_time N DEPARTS 1 N ASSIGNED DEPARTURE AIRPORT N ARRIVES N ARRIVAL AIRPORT RESERVATION Cphone Scheduled_arr_time Arr_time N N INSTANCE_OF N Instances Number Airline Weekdays Restrictions Amount Code No_of_avail_seats LEG_INSTANCE Date Leg_no FLIGHT LEG N LEGS FLIGHT 1 FARES N FARE Notes: A LEG (segment) is a nonstop portion of a flight A LEG_INSTANCE is a particular occurrence of a LEG on a particular date.
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear
Corporation: id 15 17 20 instance: Company: cid id 1 2 3 4 5 15 17 15 20 15 Assumptions: id in Company references id in Corporation. • cid in Department references cid in Company. Department: did cid 1 2 3 4 5 6 7 8 9 10 11 12 5 1 2 2 3 5 1 3 3 1 2 4 Each option starts from the original tables (given above) NOT from the tables modified by the previous option You don't need to copy the entire table. Just explain the action of each operation. (a) Suppose that all the foreign keys are declared using on delete restrict. What is the effect of the instruction delete from Company where cid=2? (b) Suppose that all the foreign keys are declared using on delete cascade. What is the effect of the instruction delete from Corporation where id-15?
LUNCH SALES Days of Week Lunch Sold Qty Unit Price Total Sold Monday Chicken 25 15.00 $ 375.00 Monday Pork 15 20.00 $ 300.00 Monday Fish 20 25.00 $ 500.00 Tuesday Mutton 15 23.00 $ 345.00 Tuesday Fish 30 25.00 $ 750.00 Wednesday Chicken 55 15.00 $ 825.00 Thursday Turkey 45 18.00 $ 810.00 Friday Turkey 60 18.00 $ 1,080.00 Saturday Chicken 15 15.00 $ 225.00 Saturday Mutton 45 23.00 $ 1,035.00 Saturday Fish 55 25.00 $ 1,375.00 Saturday Turkey 50 18.00 $ 900.00 Saturday Pork 20 20.00 $ 400.00 Sunday Fish 55 25.00 $ 1,375.00 Sunday Mutton 35 23.00 $ 805.00 Sunday Chicken 30 15.00 $ 450.00 #NAME? Fruit # of Days Sold Total Sold Sum of Total Sold Chicken Mutton Fish Turkey Pork Instructions: (Fill in the columns of the "Calculations Table") 1.…
Look up student MAJOR and ROOM information based on the student NAME. Enter formula into B2. 1 NAME MAJOR ROOM 2 58 3 4 NAME MAJOR ROOM 5 $1 CIS DBH 6 S2 7 3 A/F DBH A/F DBH 8 $4 мом SCI 9 S5 мом DBH 10 56 CIS SCI 11 S7 CIS DBH 12 S8 A/F 13 S9 мом 14 S10 CIS Size Color Price Item T. 15 Size L T M 16 Color R. 17 Price 28 H. 29 30 XL R. 18
The following table shows the student grades for Q1 and Q2 assessment activities. Calculate the mean and mode for Q1 and Q2 grades Calculate the range and standard deviation for Q1 grades and Q2 grades Student Number Q1 Grade Q2 Grade Total student Grade 1 85 79 164 2 96 85 181 3 84 76 160 4 75 76 151 5 64 94 158 6 83 83 166 7 92 92 184 8 74 71 145 9 67 81 148 10 81 93 174 11 93 72 165
Is the following table in First Normal Form? If so, how would you get it into first normal form. SalesPerson/Product table Order Number Product Number Salesperson ID SalesPerson Name Commission Percentage Year of Hire Department Number Department Name Product Name Unit Price Quantity 137 19440 15 Baker 10 1995 73 Commercial Sales Hammer 17.50 473 24013 Saw 26.25 170 26722 Pliers 11.50 688 186 16386 7 Adams 15 2001 59 Home Sales Wrench 12.95 1745 19440 Hammer 17.50 2529
- Find the employee in each department who makes the highest salary in their departments
Normalize the following table to the 3rd Normal form: Student Student Phone Course Term Grade Instructor Instructor Phone Lauren Fernell 555-7771 MIS 350 F12 A Hess 555-2222 Lauren Fernell 555-7771 MIS 372 F12 B Sarker 555-2224 Lauren Fernell 555-7771 MIS 426 F12 A Fuller 555-2227 Lauren Fernell 555-7771 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 350 F12 A Hess 555-2222 Brigit Schnieder 555-2215 MIS 375 F12 B+ Wells 555-2228 Brigit Schnieder 555-2215 MIS 372 F12 A Sarker 555-2224 Brigit Schnieder 555-2215 MIS 374 F12 B Clay 555-2221 Jackie Judson 555-1245 MIS 350 F12 A Hess 555-2222 Jackie Judson 555-1245 MIS 372 F12 B+ Sarker 555-2224 How many tables did you create after normalizing the table? List each of…