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 and a non-clustered index fordog_expanded.id. Turneddog_expanded into a view with animplicit index ondog_expanded.id. Using a case statement 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.

Uses liquibase migration tool to augmentthe schema.

• java
• liquibase
• maven
  • log4j
  • mysql driver

• maven:3-openjdk-17
• mariadb:latest
• webdevops/liquibase:mysql

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

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

sudo ./install.sh -h

• Java code based on