Re: Table Schema

From: Eric Kaplan <tobycraftse_at_yahoo.com>
Date: Sun, 23 Mar 2008 21:43:59 -0800
Message-ID: <4qfeu3hp9v0n6mbpbn81920nd8tlfju5h7@4ax.com>

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 Received on Mon Mar 24 2008 - 00:43:59 CDT