Task

Create a table to store addresses.

You may assume that all the addresses to be stored will be located in the USA.   As such, you will need (in addition to a field holding a unique identifier) a field holding the street address, a field holding the city, a field holding the state code, and a field holding the zipcode.   Choose appropriate types for each field.

For non-database languages, show how you would open a connection to a database (your choice of which) and create an address table in it. You should follow the existing models here for how you would structure the table.




-- Import module
local sql = require("ljsqlite3")
 
-- Open connection to database file
local conn = sql.open("address.sqlite")
 
-- Create address table unless it already exists
conn:exec[[
CREATE TABLE IF NOT EXISTS address(
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  street TEXT NOT NULL, 
  city TEXT NOT NULL, 
  state TEXT NOT NULL, 
  zip TEXT NOT NULL)
]]
 
-- Explicitly close connection
conn:close()