The following table consists of training data from an employee database. The data have been generalized. For example, "31 : : : 35" for age represents the age range of 31 to 35. For a given row entry, count represents the number of data tuples having the values for department, status, age, and salary given in that row. Let status be the class label attribute. department status age salary соunt sales senior 31...35 46K...50K 30 sales junior 26...30 26K...30K 40 sales junior 31...35 31K...35K 40 systems junior 21...25 46K...50K 20 systems senior 31...35 66K...70K 5 systems junior 26...30 46K...50K 3 systems senior 41...45 66K...70K 3 marketing senior 36...40 46K...50K 10 marketing junior 31...35 41K...45K 4 secretary senior 46...50 36K...40K 4 secretary junior 26...30 26K...30K 6

The following table consists of training data from an employee database. The data have been generalized. For example, "31 : : : 35" for age represents the age range of 31 to 35. For a given row entry, count represents the number of data tuples having the values for department, status, age, and salary given in that row. Let status be the class label attribute. department status age salary соunt sales senior 31...35 46K...50K 30 sales junior 26...30 26K...30K 40 sales junior 31...35 31K...35K 40 systems junior 21...25 46K...50K 20 systems senior 31...35 66K...70K 5 systems junior 26...30 46K...50K 3 systems senior 41...45 66K...70K 3 marketing senior 36...40 46K...50K 10 marketing junior 31...35 41K...45K 4 secretary senior 46...50 36K...40K 4 secretary junior 26...30 26K...30K 6

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: Table: ENROLL Table: PREREQUISITE Table: PROFESSOR EMP NUM 103 104 105 106 110 CLASS_CODE 10014…

A: Given diagrams contains six tables and the table names with their attributes are: CLASS (Class_code,…

Q: 4. In a company, employees involved in many projects, and each project may have many employees…

A: Please refer below for your reference:

Q: J. K. Does this relation contain a transitive dependency? If so, what is it? Redesign the relation…

A: SOLUTION -From the given table we have given a table PROJECT with ProductId, EmployeeName,…

Q: What is the difference between group data and ungroup data and can you provide example to see the…

A: What is the difference between group data and ungroup data and can you provide example to see the…

Q: Problem 82 Write a query to display the lowest book cost in the system (Figure P7.82).

A: Aggregate Functions: SQL has some built-in functions and they are called as aggregate functions.…

Q: Task 4: As a part of marketing strategy, the Marketing team continuously conducting an advertising…

A: Actually, database is a used to stores the data.

Q: Consider the following table in a relational database. Last Name Rank Room Shift Smith Manager 234…

A: A candidate key is an attribute or set of attribute which can identify all tuple uniquely.

Q: Customer ID Name Address Phone Card Password Usernam number number Employee

A: ERD diagram is given below

Question

The following table consists of training data from an employee database. The data have been generalized.
For example, "31 : : : 35" for age represents the age range of 31 to 35. For a given row entry, count
represents the number of data tuples having the values for department, status, age, and salary given in that
row. Let status be the class label attribute.
department status
age
salary
соunt
sales
senior
31...35
46K...50K 30
sales
junior 26...30
26K...30K
40
sales
junior 31...35
31К..35K 40
systems
junior 21...25
46K...50K 20
systems
senior
31...35
66K...70K
5
systems
junior 26...30
46K...50K
3
systems
senior
41...45
66K...70K
3
marketing
senior
36...40
46K...50K
10
marketing
junior 31...35
41K...45K
4
secretary
senior
46...50
36K...40K
4
secretary
junior 26...30
26K...30K
6
(a) How would you modify the basic decision tree algorithm to take into consideration the count of each
generalized data tuple (i.e., of each row entry)?
(b) Use your algorithm to construct a decision tree from the given data.
(c) Given a data tuple having the values "systems," "26 ... 30," and "46–50K" for the attributes department,
age, and salary, respectively, what would a na'ive Bayesian classification of the status for the tuple be?

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 2 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

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?
Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).
Composite datatypes can only have multi row &multi column values in them Answers: Yes No
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…
Build a relational model for the following ER schema