CS377: Database Design - Introduction to Databases (3 Points)

Developed by Professor Tralie and Professor Mongan.

Exercise Goals

The goals of this exercise are:

1. To become familiar with the basic structure of a database
2. To write a SQL statement

Modify the MyFirstStatement.sql file to insert the number 42 into the table, and then to retrieve it.

Enter your Ursinus netid before clicking run. This is not your ID number or your email. For example, my netid is wmongan (non Ursinus students can simply enter their name to get this to run, but they won't get an e-mail record or any form of credit).

Netid

Clicking Run below will check your work and, if it passes, will submit your work automatically. You must be connected to the VPN for submission to be successful! You will receive a copy of your code via e-mail, so you'll know that it was submitted if you receive that e-mail! VPN access requires Multi-Factor Authentication, which sends you a code when you log into the network. Instructions on configuring these for your account can be found here.

MyFirstStatement.sql

-- TODO: insert a value into the mytable database table -- TODO: retrive the value from the table -- HINT: The answer is [{"columns":["a"],"values":[[42]]}]

Setup.sql

CREATE TABLE mytable (a int);

Output