 | |
#1
 
| |||
| |||
|
Re: Table Schema -
03-23-2008
, 10:14 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? |
#2
| |||
| |||
|
|
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? |
#3
| |||
| |||
|
|
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
| |||
| |||
|
|
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? |
#5
| |||
| |||
|
#6
| |||
| |||
|
|
The data should be placed in Third Normal Form |
#7
| |||
| |||
|
|
The data should be placed in Third Normal Form |
#8
| |||
| |||
|
|
The data should be placed in Third Normal Form |
#9
| |||
| |||
|
|
The data should be placed in Third Normal Form |
#10
| |||
| |||
|
|
How to organize the fields in Third Normal Form give the following data?http://www.oniva.com/upload/1356/crew.jpg ============================ crew -> programID -> member * * * * * * * * * * * * * * * *-> member * * * * * * * * * * * * * * * *-> member .... etc * * * * *-> programID *-> member * * * * * * * * * * * * * * * *-> member * * * * * * * * * * * * * * * *-> member .... etc * * * * *-> programID *-> member * * * * * * * * * * * * * * * *-> member * * * * * * * * * * * * * * * *-> member .... etc * * * * * ... etc ============================ Each member -> role + first name + last name The data should be placed in Third Normal Form- Hide quoted text - - Show quoted text - |
program has a cast/crew, but members of one program's cast/crew could
also be working on, or have worked on, any number of other programs.
Possibly you should start with the people (cast/crew) and build a
table for that data (for example CAST_CREW), assigning a CAST_ID to
each person, which would be unique. Then you could build a table of
your programs (TV_PROGRAMS), associating the relevant CAST_IDs to
each. The role played would be contained in the table of program
data, rather than being associated with the actor in the cast_crew
table.
I won't do any more for you as this appears to be homework. However,
if you get confused, post what you have designed here and you'll
likely get helpful pointers.
David Fitzjarrell
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.