Talk About Network



Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Java Databases > Table schema
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 3685 of 3747
 Post > Topic >>

Table schema

by Eric Kaplan <tobycraftse@[EMAIL PROTECTED] > Mar 23, 2008 at 08:34 PM

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?




 4 Posts in Topic:
Table schema
 Eric Kaplan <tobycraft  2008-03-23 20:34:17 
Re: Table schema
 Lew <lew@[EMAIL PROTEC  2008-03-24 08:08:34 
Re: Table schema
 Roedy Green <see_websi  2008-03-24 14:45:20 
Re: Table schema
 Eric Kaplan <tobycraft  2008-03-24 13:58:57 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan12V112 Wed May 14 22:14:30 CDT 2008.