Skip to content

Latest commit

 

History

History
23 lines (12 loc) · 1.3 KB

README.md

File metadata and controls

23 lines (12 loc) · 1.3 KB

Simple SQL Exercise

points bar

GitHub Classroom Workflow

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.

Exercise 1

  1. Using the create-database.sql file, write a query that creates a database called SimpleDB.

  2. Still using create-database.sql, add a query that creates a table in SimpleDB called customers, that has attributes for customer name and address.

    UML diagram

  3. Push your changes back to your assignment GitHub repo. Remember to try to make your commits atomic and your commit messages descriptive.

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


References