asp.net - Best way to model page attribute data onto different database tables -

I am developing the website (using asp.net-mvc) with the SQL Server 2005 database. I have several database tables that run content pages for the site e.g. I have a table called activity:

  activity ----------- ID name  

so for each activity record , There should be a related 'activity' page and it applies to other tables eg. Location and person etc. For SEO purposes, I want to allow additional information storage for pages like html meta title / response / keyword information and possibly even page content.

I am considering two main options to do this:

1) To include additional areas to keep this additional information, the activity, location and individual table Modify

or

2) Create one page infographic table for all the information in one place, then add a PageInfoID field to the above tables

What are the pros and cons of these methods and no one can do the same And how?

(One choice I can think of for 2 options is that you can not really implement 1: 1 relationship, so you can theoretically record a pageinfo rack activity record and any person records.

If I can suggest ... about this SEO thing May be wrong in.

Instead of trying to pack each page, better search results from the page With the addition of meta-data in addition to the object 'per activity' object, I think that you should put only 'activity' data in the page with clean, meaning, valid XHTML and CSS. Which part of each page is of the highest importance and according to the index / rank.

In addition, try to add these 'page meta' objects to the domain model Your system will Ijain shall cause conceptual problems (and really practical) of all kinds, and it certainly will confuse users who will struggle to understand that the title of the activity in accordance with a title page title. Let the bots come to your keywords from your content, do not try to do it yourself - such super-optimization will really end and better page ranking than this.