ComprehensionThe following table represents the number of employees working in different departments of a pharmaceutical company over a period of five years. Study the data and answer the questions that follow. Years Production Marketing Corporate Accounts Research2007 150 25 50 45 752008 225 40 45 62 702009 450 65 30 90 732010 470 73 32 105 702011 500 80 35 132 742012 505 75 36 130 75 Question 1/2MandatoryUnderstanding Data TablesIn which of the following departments did the number of employees remain the same during the years 2007 and 2012?ProductionCorporateResearchNone of the above

Understanding Data TablesIn which of the following years did each department have a large number of employees than it did in the immediately preceding year?2010201220092011

Direction: The table shown below shows the data of a management college and the number of students admitted each year in college. Go through the following data and answer the following questions.YearTotal Number of StudentsFinanceMarketingOperationsIT20114001001059510020123857889110108201336098999073201436588768711420153756513576992016380959595952017400989778127 HideIn which of the following years, the increase in number of students over the previous year was maximum?2014201520162017

Find the following table EmployeeDetails, with the attributes EmployeeID, EmpName, Designation, Salary, DeptNo. You are assigned to a task of providing the solution to the operations department by writing the query which displays the employeeID and the Designation of all the employees whose Salaries are more than the Salary of employees designated as ManagerC

Write queries for the following tables:T1 ( Empno, Ename , Salary, Designation)T2 (Empno, Deptno.)(1) Display the Deptno in which Employee Seeta is working.(2) Display Empno, Ename, Deptno.

8.7 The following table consists of training data from an employee database. The data havebeen 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 fordepartment, status, age, and salary given in that row.department status age salary countsales senior 31 . . . 35 46K . . . 50K 30sales junior 26 . . . 30 26K . . . 30K 40sales junior 31 . . . 35 31K . . . 35K 40systems junior 21 . . . 25 46K . . . 50K 20systems senior 31 . . . 35 66K . . . 70K 5systems junior 26 . . . 30 46K . . . 50K 3systems senior 41 . . . 45 66K . . . 70K 3marketing senior 36 . . . 40 46K . . . 50K 10marketing junior 31 . . . 35 41K . . . 45K 4secretary senior 46 . . . 50 36K . . . 40K 4secretary junior 26 . . . 30 26K . . . 30K 6Let status be the class label attribute.(a) How would you modify the basic decision tree algorithm to take into considerationthe 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 theattributes department, age, and salary, respectively, what would a na¨ıve Bayesianclassification of the status for the tuple be?