CREATE TABLE address (personID INT, streetNumber VARCHAR(255), streetName VARCHAR(255), city VARCHAR(255), zip VARCHAR(255));
CREATE TABLE person (personID INT, firstname VARCHAR(255), lastName VARCHAR(255), job VARCHAR(255), phone VARCHAR(255), email VARCHAR(255));
CREATE TABLE product (productID INT, title VARCHAR(255), size VARCHAR(255), price INT));
CREATE TABLE orders (productID INT, title VARCHAR(255), quantity INT, price NUMERIC(8,2));
