You are working in a specific company as a data analyst. This company has an available position for country manager and new person applied for this position. He/She has been working for 3 years as a country manager in another company and his/her salary is 133,000$. HR sent you the positions' salary dataset and ask you if he/she deserve the 133,000$? Consider his/her level on 5.5. 1. Download the attached dataset. 2. Predict the new country manager's salary using the following: a. Simple linear regression. b. Polynomial linear regression. c. Support vector regression. 3. Write or show screenshot of the prediction results. 4. Visualize the simple linear regression result (show screenshot). 5. Visualize the polynomial linear regression results (show screenshot). 6. Visualize the support vector regression results (show screenshot). 7. Based on the scenario question, write your opinion about every model's result.

You are working in a specific company as a data analyst. This company has an available position for country manager and new person applied for this position. He/She has been working for 3 years as a country manager in another company and his/her salary is 133,000$. HR sent you the positions' salary dataset and ask you if he/she deserve the 133,000$? Consider his/her level on 5.5. 1. Download the attached dataset. 2. Predict the new country manager's salary using the following: a. Simple linear regression. b. Polynomial linear regression. c. Support vector regression. 3. Write or show screenshot of the prediction results. 4. Visualize the simple linear regression result (show screenshot). 5. Visualize the polynomial linear regression results (show screenshot). 6. Visualize the support vector regression results (show screenshot). 7. Based on the scenario question, write your opinion about every model's result.

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

Similar questions

The Driver Relationship team wants to analyze drivers and their car usages in InstantRide for the month October. Thus, they want to focus on each driver and respective car allocation occurred. In more detail, the team requires the DRIVER_ID and the CAR_ID with their usage counts as the TOTAL column for the travels occurred in the month of October. Since the team wants to also learn the total number of the travels by the drivers you need to use GROUP BY ROLLUP functionality.
SQL Help The Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information: Car ID Month Day Count You need to create a summary table using the WITH ROLLUP modifier and grouped by the specific column names, listed above, and send the data back to the team. Query the frequency of each car's use by month and day
I need help with this question. writting code Question: The management also wants you to run descriptive statistics for the relative skill of the Bulls from 1996-1998. Calculate descriptive statistics including the mean, median, variance, and standard deviation for the relative skill of the assigned team. The dataframe for the assigned team is called assigned_team_df. The variable 'elo_n' respresent the relative skill of the teams. Your statistics should be rounded to two decimal places.
Read the data into a DataFrame with ID as the index. Convert the “Hired” column into Date/Time data type Create a new column with years of experience with the company at present without rounding. Create a new Boolean column for senior status with employees with at least 10 years of experience as senior and others are not. Create a new column for longevity pay equal to $150 per whole year of experience in the company. Create a list of column names for each data type in the DataFrtame.
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…
Task 2: The Driver Relationship team wants to arrange workshops and education materials to the drivers. However, the team wants to create clusters of the drivers based on their experience in InstantStay. To collect these detail, you will need to create a SQL function called DRIVER_STATUS to determine the level of the driver as follows: MASTER: more than 4 travels PRO: more than 2 travels ROOKIE: 2 or less travels In addition, run the function to verify it works as expected and send them back the driver levels. Task: Create the DRIVER_STATUS function to create clusters of drivers based on experience.
The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.
How to Write a sequence of SQL Statements that include a Stored Trigger to Create an Audit Trail for Updating and Deleting Rows in a Table in your version of the Sales Rep - Customer - Invoice Database. Write a Stored Trigger linked updating a table row in the Enterprise Contracting Company Database. Enterprise Contracting Company Database Write a Stored Trigger linked deleting a table row in the Enterprise Contracting Company Database For each Trigger, a copy of the row before the update or delete operation should be placed in one or more audit tables that keep track of the history of the data. Your Script must contain SQL Statements that Test and Verify that the Triggers are working correctly. A Delete Statement removing one or more rows from a table An Update Statement changing one or more rows from a table CREATE TABLE Statement to create your version of the audit table storing the versions of the data before being deleted or updated SELECT Statements visually…
You have a table that contains the following fields: Last Name, First Name, Street, City, State, and Postal Code. There are 50,000 records in the table. What indexes would you create for the table? You have a table that contains the following fields: Book ISBN Number, Book Title, Author Last Name, Author First Name, Publication Year, and Publisher Name. There are 75,000 records in the table. What indexes would you create for the table?
A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number • Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale The average price of a computer was sold by the retailer In which months less than 100 computers were sold
please use sql to answer the following question and erd and code from the last test (tesk 3) have been providing and it connects to task 4 as well the code is shown below CREATE PROCEDURE PROD_ADD_SP( product_name IN VARCHAR2, description IN VARCHAR2 , image_filename IN VARCHAR2, price IN NUMBER , active_status IN NUMBER) ASBEGIN INSERT INTO BB_PRODUCT VALUES(product_name, description, image_filename, price, active_status);END PROD_ADD_SP; 1EXECUTE PROD_ADD_SP.execute('Roasted Blend','Well-balancedmix of roasted beans, a medium body','roasted.jpg',9.50,1); 2 select * from BB_PRODUCT; Task 4: Adding Descriptions for Order Status Codes When a shopper returns to the Web site to check an order’s status, information from the BB_BASKETSTATUS table is displayed. However, only the status code is available in the BB_BASKETSTATUS table, not the status description. We also need Description of order status. Create a function named STATUS_DESC_SF that accepts a stage ID and returns the…
One of the tables that resulted from the DBA denormalizing some of the data in the TAL Distributors database so as to boost performance is as follows: Which field or fields in the Customer table (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum, RepName) are responsible for the table no longer being in third normal form? In this scenario, what does the normal form of the denormalized table look like?