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. Usinga 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.

Sql server uses self-signed ssl.

• java
• buildr
  • log4j
  • ms sql driver

• alpine:edge
• vanto/apache-buildr:latest-jruby-jdk8
• mcr.microsoft.com/mssql/server:2017-latest-ubuntu

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

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

sudo ./install.sh -h

https://github.com/htorun/dbtableprinter