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

//stored procedure create or replace procedure firstthree (my_seqid in varchar2) as cursor c1 is select sname, grade from student s join taken t on s.sid=t.sid where seqid=my_seqid order by grade desc; -- my_sname varchar2(40); my_sname student.sname%TYPE; -- my_grade number(2,1); my_grade taken.grade%TYPE; begin /* clear the my_tmp table */ delete from my_tmp; commit; open c1; for i in 1..3 loop fetch c1 into my_sname, my_grade; exit when c1%notfound; /* in case the number requested */ /* is more than the total */ /* number of enrolled students */ /* display the result */ dbms_output.put_line('name: ' || my_sname || ' ' || 'grade: ' || my_grade); /* put into temporary table */ insert into my_tmp values(my_sname, my_grade); commit; end loop; close c1; end; / -------------- //php <? $connection = oci_connect ("test", "test", "test"); if ($connection == false){ $e = oci_error();…
with it, paste your code in a text file named Student.txt and save it in your task folder. Write the SQL code to create a table called Student. The table structure is summarised in the table below (Note that STU_NUM is the primary key): STU_NUM Attribute Name STU_SNAME STU_FNAME STU_INITIAL STU_STARTDATE COURSE_CODE PROJ_NUM STU STU_S STU_F STU_INITIAL NUM NAME NAME 01 02 Snow John E CHAR(6) After you have created the table in question 1, write the SQL code to enter the first two rows of the table as below: Stark Arya с VARCHAR(15) VARCHAR(15) CHAR(1) DATE CHAR(3) INT(2) Data Type STU_STARTDATE COURSE_ PROJ_ CODE NUM 05-Apr-14 12-Jul-17 201 305 6 11 Assuming all the data in the Student table has been entered as shown below, write the SQL code that will list all attributes for a COURSE_CODE of 305.
( Please answer this question immediately I do not have time ) Use the following table to answer the questions below: Table name: Books Column Name Role Data Type Length Constraint bookID Stores the ID of a book Number 5 Primary key bookTitle Stores the title of a book Varchar2 50 - bookISBN Stores the ISBN of a book Number 13 Cannot be null and duplicated publicationDate Store the publication date of a book Date - Cannot be null bookPrice Stores the price of a book Number 2,2 Cannot be null a. Write in SQL a command that creates the table Books according to the above description b. Write in SQL a statement that adds a new column named publisherID of type Char(10). This column should be defined as a foreign key that relates the table Books to the table Publisher c. Write in SQL a command that deletes the books that are published before 20-Aug-2010 d. Write a SQL query that displays the number of books that are published in the year 2018 e. Write in SQL a…
create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer…
If a particular column is not allowed to be null, what is the result if the column is left empty?
Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code (SALARY, LAST_NAME, STREET, ZIP_CODE) from the EMPLOYEE and ADDRESS tables, sorted by SALARY from largest to smallest. STREET and ZIP_CODE are in the ADDRESS table, while the other fields are in the EMPLOYEE table. The common key is EMPLOYEE_ID.
T-SQL procedure for MICROSOFT SQL SERVER A: obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the content of I_CUSTOMER_NAME and I_CREDIT_LIMIT. HINT use cursor instructions as a template for the problem. Instructions goes as follows CREATE PROCEDURE usp_DISP_REP_CUST @repnum char(2) AS DECLARE@custnum char(3) DECLARE@custname char(35) DECLARE mycursor CURSOR READ_ONLY FOR SELECT CUSTOMER_NUM, CUSTOMER_NAME FROM CUSTOMER WHERE REP_NUM = @repnum OPEN mycursor FETCH NEXT FROM mycursor INTO @custnum, @custname WHILE @@FETCH_STATUS=0 BEGIN PRINT@custnum+' '+@custname FETCH NEXT FROM mycursor INTO @custnum, @custname END CLOSE mycursor DEALLOCATE mycursor
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 Add the four maintenance types to the MAINTENANCE_TYPES table.
Write a stored procedure called sp_apply_discount() that will apply percent discount to books in a subject. The stored procedure takes in 2 parameters, percentDiscount (DECIMAL(8,2)) and subject (VARCHAR(120)). Using these parameters, the stored procedure computes the discount for the book cost and stores it in the FINAL_PRICE field. For example, the following stored procedure call: call sp_apply_discount(0.15, 'Database');would compute 15% percent discount from the book cost in the Database subject category and store it in the FINAL_PRICE column as depicted in this image:
Employee(empno, ename, street, city, mgrssn) work_project(eno, pno, number_of_hours) Write a query and optimize it to find employee name and project number in which they work and who live in "New_york". Identify the type of indexing to be applied on 'empno' in Employee Table.
NVL to replace null value.
Q2: Design Database for the following scenario and Write SQL queries. Create an ERD for the following scenario. Suppose there is a grocery store near your house. Following can be considered for ERD: A grocery store may have more than one employee. A grocery store has exactly one manager. The manager has one or more sales men working under him. Grocery store has more than one portion for the products. • Each product has a barcode, name, expired date. Many customers can busy many products, but each product is bought by only one customer. Each customer will get an invoice for his /her purchase. The bill invoice has an id.