LISTING 2: Normalized Table Schema

CREATE TABLE NormTempSamples
( siteid     VARCHAR(10) NOT NULL,
  sampleno   INT         NOT NULL,
  temperature INT         NOT NULL,
  PRIMARY KEY(siteid, sampleno) )