To use the cloud-based Azure Database for PostgreSQL, create an an account for yourself and then do the following.
Configure a database management instance as specified in the Quickstart tutorial but choosing cheaper, low-performance options — try to get the estimated cost in the right column down to around $15–20/month, which your Azure for Students account can handle for the rest of the semester (and beyond). We suggest setting the following non-default alternatives:
Review and create the service.
You can monitor your expenses on your Azure for Students “Subscription” page. To save student credits for future courses, you can tear down this database instance when your labs 7–9 and homework 3 have been graded, or, at the latest, by the end of the semester.
Create the monopoly database as follows.
export
commands (with your password edited in) into your
cloud shell session.
psql
in the cloud shell
session.Cut/paste the contents of this SQL command file into the cloud shell session. This builds the monopoly database from scratch.
SELECT * FROM Player;
You should now be set to continue with the lab exercises.
You could consider using the VS Code PostgreSQL extension to connect to your database, which allows you to work with your database locally, within VScode.