I am creating a database of surveys completed by companys over the last 5 years. The question have varied from year to year. Adding questions some years, and dropping some in other years. each survey is about 800 questions. I had the following tables in mind.
Company(Company,CompanyID,Sector,1999,2000,2001,20 02,2003)---the years are to determin when each company participated
Questions(QuestionNumber, Question description,1999,2000,2001,2002,2003)--Again the years are there to determine which years the questions where asked
Does this seem like a good way to oraganize the data. how would the relationships work. My goal is to be able to analyze the data for a given year(averages, sums, percent responce, etc...), and see trends in the data over several years for any question that have stayed constant. Can anyone Help me? Is this a good design