Java Advanced Database Code Review

Author name - Yvonne Peng
Program name - Shoe Stores

Epicodus Java 2015 Summer Class week 4 CodeReview
Write a program to list out local shoe stores and the brands of shoes they carry.
Make a Store class and a Brand class.

1. In PSQL:
2. CREATE DATABASE shoes;
3. CREATE TABLE stores (id serial PRIMARY KEY, name varchar);
4. CREATE TABLE brands (id serial PRIMARY KEY, name varchar);
5. CREATE TABLE brands_stores (id serial PRIMARY KEY, brand_id int, store_id int);
6. CREATE DATABASE shoes_test WITH TEMPLATE shoes;

1. Download this repository files to your computer.
   
2. Navigate to the folder directory.
   
3. Open command prompt in Windows or terminal in Mac.
   
4. If you don't have PostgreSQL installed in your computer, check out this link and follow the instruction.
5. Create a database: "shoes" in your computer.
   
6. Run the following command "psql shoes < shoes.sql"
   
7. Run the following command "Gradle run". (If you have not installed Gradle, check out the Gradle website )
   
8. Open your internet browser and navigate to http://localhost:4567/
   
9. The webpage would load automatically. You can manage your own local shoes store!!