Removed SQL string definitions - they are directly included in calls to connect.
Connections use localhost instead of 127.0.0.1.
Renamed attributes in the two existing dimensions such that 'id' is the surrogate key and memberid/locationid refers to the original id.
Removed the two for loops that ensured the elements in the location and member dimensions.
Added the product dimension.
Added the date and time dimensions.
Included an SQL statement for properly retrieving member info.
Applied the new member sql query such that the member dimension is ensured separately.