Repository files navigation

Creates a small database tablecalleddog. This table,dog, has been normalized to 3NF.Two new tables have been added,breedLookup andcolorLookup.Creates a new tabledog_expanded that joinsdog,breedLookup andcolorLookup. Added clustered indexes ondog.breedId anddog.colorId. Turneddog_expanded into a view with animplicit index ondog_expanded.id. Using an common table expression with the aggregate functionCOUNT, create a new viewbreed_count. All output normallyseen in a terminal will be injava-srv/log which will dump to the screen. The project may seem to hang but the logs from the container must be written to the project this can take up to 3 min.

• groovy
• bazel
  • log4j
  • postgres driver

• l.gcr.io/google/bazel:latest
• postgres

sudo ./install.sh -uCreates java-srv/log

sudo ./install.sh -dRemoves java-srv/log

sudo ./install.sh -h

https://github.com/htorun/dbtableprinter