[thelist] Sponsorship Table Design Question

Scott Brady evolt at scottbrady.net
Thu Feb 6 16:22:01 CST 2003


I think this one got lost in the crowd.

Any suggestions?

Scott
---------- Original Message ----------------------------------
From: "Scott Brady" <evolt at scottbrady.net>
Reply-To: thelist at lists.evolt.org
Date:  Wed, 5 Feb 2003 18:34:59 -0700

>I'm working on a conference registration site and one of the applications
>will allow sponsors to sign up (and pay) online.
>
>I'm trying to make the data as dynamic as possible, but am wondering what
>would be the best way to design the sponsorship_type tables.
>
>Here are the basic requirements:
>1) Each type can have at most 5 sponsors
>2) There are 7 types:
>
>Diamond:  covers the entire week
>Platinum:  each sponsor can choose a day's lunch to sponsor (M-Th)
>Gold: covers the entire week
>Silver: covers the entire week
>Partner: covers the entire week
>Cyber Cafe:  covers a single day (Sun - Th), but each sponsor can buy
>multiple days
>A/V Services: covers a single day (M - Th), but each sponsor can buy
>multiple days
>
>I'm trying to figure out how to do the sponsorship_type table.  If the Cyber
>Cafe one didn't have "Sunday" listed, then I could just have a "fullweek"
>flag. If not "fullweek" then each sponsor chooses a day. Or something like
>that.
>
>This will be on a SQL Server 2000 database with coding done in ColdFusion.
>
>Any ideas?
>
>Thanks!
>-------------------------------------------
>Scott Brady
>http://www.scottbrady.net






More information about the thelist mailing list