In this exercise, learners/lecturers will write queries that create a database and a simple table in that database. Learners will then test their queries by pushing them to their GitHub repo and checking the output from automated tests.
Using the
create-database.sqlfile, write a query that creates a database calledSimpleDB.Still using
create-database.sql, add a query that creates a table inSimpleDBcalledcustomers, that has attributes for customer name and address.
Push your changes back to your assignment GitHub repo. Remember to try to make your commits atomic and your commit messages descriptive.
Check either the Actions tab or classroom Assignments tab to see if you have completed the exercise successfully. You should score full marks if all tests have passed.
