Rewrite the following read csv method to index columns 1 and 3.Then sort the indexes.Then write the statements that will locate the Pool club use:examclub = pd. read_csv ("exama.csv")examclub0123456789Member Join Date Club UsePoolTim Berners-LeePool Leonard KleinrockGolf Charles BabbageGolfKonrad ZuseSpaSteve WozniakSpaSteve JobsGolfAda LovelaceJohn Atanasoff2020-01-012020-01-022020-01-032020-02-012020-03-022020-04-032020-01-012020-01-022020-03-022020-04-03Member Name Member LevelGoldSilverBronzeSilverBronzeGoldBronzeSilverBronzeGoldSpaPoolGolfAlan TuringBill GatesDues Paid Dues Owed5250.0456.04406.01200.08661.0300.07075.0100.02524.02000.02793.02890.07172.01030.06362.0789.05982.01738.07917.0287.0

Read the "exama.csv" file using pd.read_csv() method and store it in a variable named examclub. Use…

Rewrite the following read csv method to index columns 1 and 3. Then sort the indexes. Then write the statements that will locate the Pool club use : examclub = pd.read_csv ("exama.csv") examclub 0 1 2 3 4 5 6 7 8 9 Member Join Date Club Use 2020-01-01 2020-01-02 2020-01-03 2020-02-01 2020-03-02 2020-04-03 2020-01-01 2020-01-02 2020-03-02 2020-04-03 Pool Tim Berners-Lee Pool Leonard Kleinrock Golf Charles Babbage Golf Konrad Zuse Steve Wozniak Steve Jobs Ada Lovelace John Atanasoff Alan Turing Bill Gates Spa Spa Golf Member Name Member Level Dues Paid Dues Owed Gold 5250.0 456.0 Silver 4406.0 1200.0 Bronze 8661.0 300.0 Silver 7075.0 100.0 Bronze 2524.0 2000.0 Gold 2793.0 2890.0 Bronze 7172.0 1030.0 Silver 6362.0 789.0 Bronze 5982.0 1738.0 Gold 7917.0 287.0 Spa Pool Golf

Rewrite the following read csv method to index columns 1 and 3. Then sort the indexes. Then write the statements that will locate the Pool club use : examclub = pd.read_csv ("exama.csv") examclub 0 1 2 3 4 5 6 7 8 9 Member Join Date Club Use 2020-01-01 2020-01-02 2020-01-03 2020-02-01 2020-03-02 2020-04-03 2020-01-01 2020-01-02 2020-03-02 2020-04-03 Pool Tim Berners-Lee Pool Leonard Kleinrock Golf Charles Babbage Golf Konrad Zuse Steve Wozniak Steve Jobs Ada Lovelace John Atanasoff Alan Turing Bill Gates Spa Spa Golf Member Name Member Level Dues Paid Dues Owed Gold 5250.0 456.0 Silver 4406.0 1200.0 Bronze 8661.0 300.0 Silver 7075.0 100.0 Bronze 2524.0 2000.0 Gold 2793.0 2890.0 Bronze 7172.0 1030.0 Silver 6362.0 789.0 Bronze 5982.0 1738.0 Gold 7917.0 287.0 Spa Pool Golf

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

7. Use the UNION operator to generate a result set consisting of three columns from the Products table: Discount status A calculated column that contains a value of DISCOUNTED or FULL PRICE Product_name The product_name column discount_percent The discount_percent column If the product has a discount_percent greater than 0, the Discount_status column should contain a value of DISCOUNTED. Otherwise, it should contain a value of FULL PRICE. Sort the final result set by product_name.
Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order. (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)
Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals. Create a procedure to calculate the VAT. 1 Make sure you are using the following format to change the delimiter for the procedure: DELIMITER $$-- statements --END $$DELIMITER ; Test QueryCALL VATCalculator() Expected Results TRAVEL_ID VAT 5001 1.24 5002 1.64 5003 0.99 5004 2.12 5005 0.89 5006 1.05 5007 0.30 5008 1.51 5009 1.08 5010 1.64
Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the second SMALLINT (INOUT) parameter. The procedure checks the parameter and, if there are no errors, inserts the value into tblPlayers. Documentation of errors Condition Error code No errors 1st param Null or zero len playerID taken 1 proclnsertGame will receive two IN VARCHAR(16) interpreted as
Write a stored procedure named updateUnitsOnOrder(). The updateUnitsOnOrder ()procedure should update the UnitsOnOrder field of those products that are discontinued. It should set the UnitsOnOrder field to 99 for those discontinued products. Hint: There is no need to use cursor processing for this stored procedure.
he Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
Create table statements (file name must be: 1_create_table.txt). Make sure you specify primary keys and foreign keys. Specifying “not null” constraint is optional. Specifying “on delete action” and “on update action” are optional.
WorksOn Database: Employee (EmployeeNumber, EmployeeName, BirthDate, Title, Salary, DepartmentNumber) Project (ProjectNumber, ProjectName, Budget, DepartmentNumber) Department (DepartmentNumber, DepartmentName, ManagerNumber) WorksOn (EmployeeNumber, ProjectNumber, Responsibility, Hours) Questions: 1) Write an SQL query that returns the project number and name for projects with a budget no greater than $1,050,000. 2) Write an SQL query that returns all works on records where hours worked is less than 5 and the responsibility is 'Manager'. 3) Write an SQL query that returns the employees (number and name only) who have a title of 'EE' or 'SA' and make more than $50,000. 4) Write an SQL query that returns the employees (name and salary only) in department 'D1' ordered by decreasing salary. 5) Write an SQL query that returns the departments (all fields) ordered by descending department name.
**In SQL** Write a SELECT statement that returns these columns: InstructorDept The DepartmentName column from the Departments table for a related instructor LastName The LastName column from the Instructors table FirstName The FirstName column from the Instructors table CourseDescription The CourseDescription column from the Courses table CourseDept The DepartmentName column from the Departments table for a related instructor Return one row for each course that’s in a different department than the department of the instructor assigned to teach that course. (Hint: You will need to join the Departments table to both the Instructors table and the Courses table, which will require you to use table aliases to distinguish the two tables.)
Please attach output of this queries CREATE TABLE Employee ( EmployeeID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Gender CHAR(1), BirthDate DATE, Department VARCHAR(50), Position VARCHAR(50), Salary DECIMAL(10, 2) ); Insert 10 records and find out the who's salary is greater than Harry's salary?
Instructor(Instructor_Id, Instructor_Name, specialization, Address,#Department_Id)Department(Department_Id, Department_Name)Course(Course_code, Course_Title,Credit_hours,Contact_hours,#Department_Id)Teaching(#Instructor_Id, #Course_code)a) Express in SQL the following queries:i. Change to 6 the number of contact hours of the course which has thecode “ITDR2104”.ii. Add a new column named instructorLoad of type Number(2) to thetable instructor.iii. List the details of all the courses having a code that starts with“ITDR”. The output should be sorted in descending order by credithours.iv. Find the number of courses taught by the instructor whose name is“Ahmed”.v. List the names of all departments along with the number of coursesoffered by each department.vi. Find the titles of courses, which are taught by the instructor who isnamed “Ahmed”.b) Create a view named instructor_of_DBCourse to contain the details(Instructor_Name, specialization, Address, Department_Id) ofinstructors who teach…
SQL Database Write PL/SQL or T-SQL procedures to accomplish the following tasks: Obtain the first name and last name, separated by a space, of the guide whose number currently is stored in I_GUIDE_NUM. Place these values in the variables I_FIRST_NAME and I_LAST_NAME. Output the contents of I_GUIDE_NUM, I_FIRST_NAME, and I_ LAST_NAME. Obtain the number of persons, customer number, and customer last name for every reservation whose ID currently is stored in I_RESERVATION_ID. Place these values in the variables I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME, respectively. Output the contents of I_NUM_PERSONS, I_CUSTOMER_NUM, and I_LAST_NAME. Add a row to the GUIDE table. Change the last name of the guide whose number is stored in I_GUIDE_NUM to the value currently found in I_LAST_NAME. Delete the guide whose number is stored in I_GUIDE_NUM