revamped createTables.sql to reflect complete design decisions