I am working on a career fair managment script and ran into a inquiry i guess while desiging my database
I have three tables: Fair, Company, Sponsorship
Fair contains information about the fair like registration dates
Company contains company information
Sponsorship contains pricing and various sponsorship levels aval
The sponsorship levels and options can vary from fair to fair but don't always, so I stored them in their own table. Company Sponsorship levels also vary from fair to fair.
Would it be better to reference all these in a simple fair_company_sponsorship table
or would it be better in the long run to go fair_company fair_sponsorship and company_sponsorship (all those tables are references to the int pk)
EDIT: after i posted this I realized my table logic was somewhat invalid as two different sponsorships for the same company in the company_sponsorship gives me no information as to what fair it belongs in
