SQL/JAVA

ORACLE

CSC 355 Database Systems

Part 1. JDBC Programming (50 points) Consider the following table Part (from SSBM schema benchmark https://www.cs.umb.edu/~poneil/StarSchemaB.PDF)

create table part (

p_partkey integer not null,

p_name varchar(22) not null,

p_mfgr varchar(6) not null,

p_category varchar(7) not null,

p_brand1 varchar(9) not null,

p_color varchar(11) not null,

p_type varchar(25) not null,

p_size integer not null,

p_container varchar(10) not null

);

alter table part

add primary key (p_partkey);

*

*

RAW DATA BELOW:

import java.util.Scanner;

public class Main{

public static void main(String args[]){

System.out.println("Hello World!");

Scanner reader = new Scanner(System.in);

System.out.println("Enter a number: ");

int n = reader.nextInt();

System.out.println("The number is "+n);

}

}

*

*

A) Write Java code that will load the Part table from the data file at the link above. Execute the loading code three times (dropping and re-creating the table each time) and time the execution performance.

B) Using Java, choose 20 primary keys at random (i.e., pick random integers in range of p_partkey) and delete these randomly chosen 20 rows

C) Write Java code that will accept an SQL query as user input, execute the query and time it, printing both the runtime and the output the query produced to the screen.