I was using a database connection in netbeans to connect and run the creation script sql but this was not the project local database. I recreated the database connection in netbeans using JDBC driver to point to C:\Users\Mike\Documents\NetBeansProjects\GitHub\Set_List\Set_List\COSC457-Set_List-DB and ran the creation script again. now the database in the project contains the tables. It may not make sense that the local database for the project wasn't the same one I had created in the Services tab under databases but now for me they are one and the same.