Assignment_4_Cleaning_Data_Set_Instructions

Task 3: The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVE_DRIVERS, from the DRIVERS and TRAVELS tables which contains the following fields: DRIVER_ID CHAR(5) (Primary key) DRIVER_FIRST_NAME VARCHAR(20) DRIVER_LAST_NAME VARCHAR(20) DRIVER_DRIVING_LICENSE_ID VARCHAR(10) DRIVER_DRIVING_LICENSE_CHECKED BOOL DRIVER_RATING FLOAT SQL Database Test: Create a new table to store information on active drivers Test Query: SELECT * FROM ACTIVE_DRIVERS   Expected Results: DRIVER_ID DRIVER_FIRST_NAME DRIVER_LAST_NAME DRIVER_DRIVING_LICENSE_ID DRIVER_DRIVING_LICENSE_CHECKED DRIVER_RATING 2001 Willie Butler 1874501 1 4.4 2002 Justin Howard 1953853 1 4.8 2003 Anthony Walker 1735487 1 3.5   Task 4: The Driver Relationship team wants to have quick…

Task 3: The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVE_DRIVERS, from the DRIVERS and TRAVELS tables which contains the following fields: DRIVER_ID CHAR(5) (Primary key) DRIVER_FIRST_NAME VARCHAR(20) DRIVER_LAST_NAME VARCHAR(20) DRIVER_DRIVING_LICENSE_ID VARCHAR(10) DRIVER_DRIVING_LICENSE_CHECKED BOOL DRIVER_RATING FLOAT ANSWER IN MYSQL PLEASE

Task 9:The StayWell property management team wants to add two additional properties and run some simulation tests relating to market coverage. Add the following properties to the PROPERTY table: However, the team does not want this data in the database once they complete their operations. You need to create a transaction with the changes rolled back.

MySql Workbench CREATE TABLE students (  id INT PRIMARY KEY,  first_name VARCHAR(50),  last_name VARCHAR(50),  age INT,  major VARCHAR(50),  faculty VARCHAR(50)); CREATE TABLE location (  id INT PRIMARY KEY,  name VARCHAR(50),  rooms INT); CREATE TABLE faculty (  id INT PRIMARY KEY,  name VARCHAR(50),  department_id INT); 1. List last name of all students whose first name is longer than 4 letters in ascending order accordingto the last name. Duplicated rows should be removed from the output.2. Count the total number of rooms in Location.3. Find the number of students in each major.4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...

Use the iloc() function to extract the first 20 features of the dataframe har_train. Save this new dataframe to first_twenty. Next, using the seaborn library create a heatmap for the correlation matrix. First you have to create the correlation matrix from the pandas dataframe (save it in a dataframe called corr) and then plot it using seaborn with these customizations: Set the seaborn style to white. Generate a mask using np.triu(np.ones_like()) with the dtype as boolean to only show the lower triangle of the correlation matrix. Save it in a variable called mask. Set up the figure with matplotlib with figsize=(11,9). Use fig, ax = ... Generate a custom diverging colormap for the heatmap with the arguments (220, 10, as_cmap=True). Save it in a variable called cmap. Draw the heatmap with the mask and correct aspect ratio, using the arguments corr, mask=mask, cmap=cmap, vmax=.3, center=0, square=True, linewidths=.5, cbar_kws={"shrink": .5}). Finally, use fig.tight_layout() just before…

Project 3 Details:This project is based on eight tables (AIRPORT, FLIGHT, DEPARTURES, PASSENGER,RESERVATION, EQUIP_TYPE, PILOTS, and TICKET) that contain data about the Belle Airlines. Downloadand use data in Project 3 zip file for this project.Some Background on Belle AirlinesBelle Airlines is a regional carrier that operates primarily in the southwestern United States. At thepresent time, Belle Airlines operates its own reservation information system. To simplify our analysis,we will assume that all reservations on Belle Airlines flights are placed through Belle Airlines employees.Flights are not booked through travel agents and Belle Airlines does not participate in industry-widereservations services. Each flight is assigned a unique flight number and has its own set of flightcharacteristics (ie. flight number, origin, destination, departure time, arrival time, meal code, base fare,mileage between origin and destination, and number of changes in time zone between the origin…

Normalize the Index metadata connection and explain why you think it would be slower to use.

The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVE_DRIVERS, from the DRIVERS and TRAVELS tables which contains the following fields: DRIVER_ID CHAR(5) (Primary key)DRIVER_FIRST_NAME VARCHAR(20)DRIVER_LAST_NAME VARCHAR(20)DRIVER_DRIVING_LICENSE_ID VARCHAR(10)DRIVER_DRIVING_LICENSE_CHECKED BOOLDRIVER_RATING FLOAT

The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVE_DRIVERS, from the DRIVERS and TRAVELS tables which contains the following fields: DRIVER_ID CHAR(5) (Primary key) DRIVER_FIRST_NAME VARCHAR(20) DRIVER_LAST_NAME VARCHAR(20) DRIVER_DRIVING_LICENSE_ID VARCHAR(10) DRIVER_DRIVING_LICENSE_CHECKED BOOL DRIVER_RATING FLOAT   The code is supposed to look something like this but I'm getting an error  CREATE TABLE ACTIVE_DRIVERS(   DRIVER_ID CHAR(5) NOT NULL,   DRIVER_FIRST_NAME VARCHAR(20) NULL,    DRIVER_LAST_NAME VARCHAR(20) NULL,   DRIVER_DRIVING_LICENSE_ID VARCHAR(10) NULL,    DRIVER_DRIVING_LICENSE_CHECKED BOOL NULL,    DRIVER_RATING FLOAT NULL ) as select D.DRIVER_ID, D.DRIVER_FIRST_NAME, D.DRIVER_LAST_NAME, D.DRIVER_DRIVING_LICENSE_ID,…

Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.

Help understanding / installing phpmyadmin and if i need wamp server aswell and where to copy and paste this code in order to create a database

Create a new dataset called "life_exp_2" using subset() with the following variables: life expectancy, polio vaccination, measles vaccination, obesity 9-15 year old's, basic water, alcohol consumption, and current healthcare spending. Use View() and str) to check if you obtained all the relevant variables in the new dataset.

The Driver Relationship team wants to update the driving license id of an active driver: Driver ID: 2003, New Driving License ID: 1735488 In addition, the team wants to do the update over the VIEW and also want to see the actual change in the DRIVERS table. Task   Update a driver's record using the ACTIVE_DRIVERS VIEW.