Murali Tirupati wrote in post #960320: > Hi, > > Why the data is redundant, ids there any relation behind that. > > Mercedes CL63 why in two times is there any factor to distinguish in > between than type and Brand?
Good catch. I was too focused on the proximate question. More advice for the OP, then: your DB contains repetition. That's virtually always a bad thing. The process of removing this repetition is called *normalization*. You should always (except for a few special cases) normalize your schema to Third Normal Form (3NF) at a bare minimum, and usually to 5NF. Yes, I know I'm throwing around jargon. Read about DB normalization (the Wikipedia articles are excellent) and apply it religiously. 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.
