I've inherited an ancient Access database that I've migrated to MS SQL. Have a question about how to improve a particular table.The table contains records for lodging establishments. Each row represents a particular establishment, and there are dozens and dozens of columns. Among these columns are over a dozen that name various activities available in the area where the establishment is located. Each activity has its own separate column, and the values are set to true or false. I sense there is a better way to handle this.The table will be queried with a web form, and among the form components will be checkboxes for each of these activities. What would be the best schema for the table? Should I create another table for activities (each activity being a row), and join it to the original table?Or is there a smarter way to handle this? I have not been asked to make any changes but this seems like a good opportunity to improve the database (and learn some things myself about how to design a relational database properly).
Here's the schema of the existing table (I've imported it from Access into SQL 2005 but haven't altered anything yet):
/****** Object: Table [dbo].[MaineInnMembers] Script Date: 08/25/2010 14:31:45 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[MaineInnMembers](
[ID] [int] NOT NULL,
View Complete Post