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 subquery with the table-value functionfn_breed_count, 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
• bazel
  • log4j
  • ms sql driver

• alpine:edge
• l.gcr.io/google/bazel:latest
• 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