Re: Table Schema

On Mar 24, 12:43 am, Eric Kaplan <tobycraf..._at_yahoo.com> wrote:
> 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 -

Apparently you don't fully understand the nature of your data. Each 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 Received on Mon Mar 24 2008 - 08:29:31 CDT