Table Schema

From: Eric Kaplan <tobycraftse_at_yahoo.com>
Date: Sun, 23 Mar 2008 20:35:17 -0800
Message-ID: <srbeu3tj8lpgkat30icrkr4d8bp8c94hju@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? Received on Sun Mar 23 2008 - 23:35:17 CDT

Original text of this message