Re: Table Schema

Eric Kaplan <tobycraftse_at_yahoo.com> wrote in news:srbeu3tj8lpgkat30icrkr4d8bp8c94hju_at_4ax.com:

> I have a group of TV listing data need to map into database tables.
>
> Data looks like following:
> http://www.oniva.com/upload/1356/crew.jpg
>
> I want to create a table for productionCrew of each TV program
>
> the data is like -
> crew -> programID -> member
> -> member
> -> member ... etc
> -> programID -> member
> -> member
> -> member ... etc
> -> programID -> member
> -> member
> -> member ... etc
> ... etc
>
> above are data from productionCrew of all TV program, for each
> programID we have a list of members.
>
> Should I merge all member into a big string?
> Or should I use 2 tables to store the Crew data?
>
> If i use 2 tables, how the fields / column will look like?

The data should be placed in Third Normal Form Received on Sun Mar 23 2008 - 23:14:02 CDT