Dani Dani wrote in post #960786: > Wow, great, thank you. > > So to summarize, I'll have to create a table holding "companies", then > each record in each table should have a "company_id" pointing to the > associated company in the companies table ?
Well, not necessarily in each table. For example, suppose you have a system where documents belong to users, and users belong to companies. You need a company_id on the users table, but you don't need one on the documents table, because the company_id can be deduced from the user_id (by looking to see which company the user belongs to). > > By the way Brian, what do you mean by NF in the "strip away NF > criteria..." sentance ?. > > Regards, > Dani At this point, I would strongly advise you to read about relational database design and normalization. The Wikipedia articles on DB normalization are excellent. Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
