LISTING 2: Code That Creates and Populates 
the WeekDays Auxiliary Table

CREATE TABLE WeekDays
(
  dayname VARCHAR(9) NOT NULL PRIMARY KEY,
  dayid   INT        NOT NULL UNIQUE
)

INSERT INTO WeekDays VALUES('Sunday', 1)
INSERT INTO WeekDays VALUES('Monday', 2)
INSERT INTO WeekDays VALUES('Tuesday', 3)
INSERT INTO WeekDays VALUES('Wednesday', 4)
INSERT INTO WeekDays VALUES('Thursday', 5)
INSERT INTO WeekDays VALUES('Friday', 6)
INSERT INTO WeekDays VALUES('Saturday', 7)