Skip to content

Latest commit

 

History

History
9 lines (5 loc) · 831 Bytes

README.md

File metadata and controls

9 lines (5 loc) · 831 Bytes

DatabaseTrends

##Analysis of Postgres database using JDBC SQL queries and gnuplot, graphviz, and LaTeX APIs

Part1.java contains code to query the databse via JDBC, extract information with a SQL query, and use a gnuplot API to display supplies sales by region. Part1.png is the corresponding output of the Java program to gnuplot.

Part2.java contains code to query the database via JDBC, extract information with a SQL query, and use a graphviz API to display trade relationships between regions. Part2.png is the correspoding output of the Java program to graphviz.

Part3.java contains ode to query the database via JDBC, extract information with a SQL query, and use a LaTeX API to generate purchase orders for the minimum price of items in the database. Part3.pdf is the corresponding output of the Java program to LaTeX.