search for: 3nf

I just have a few questions about join tables. From my understanding the following applies (correct me if I''m wrong): 1.Join tables are always named with the names of the two associated tables, in alphabetical order, separated by an underscore. 2.The foreign key fields are named with the name of the table they are referencing, with _id appended. 3.The foreign key is referencing a

Well, I understand what they do and how, I just don''t get why! It seems to me that any time you would have this relationship between two tables...they should be one table! Agile Rails book gives what seems to me to be a lame example for this. They use the example of an "invoice" and an "order". An invoice belongs to an order and an order has one invoice. Seems

...ources/rsync/ Perhaps this may be added to the resources section of the rsync site? Regards, Glen Scott. -- --- Design Solution Limited http://www.designsolution.co.uk Tel: +44 (0)1502 513008 Fax: +44 (0)870 460 2518 The Old Chapel, Commodore Road, Oulton Broad, Suffolk, NR32 3NF, UK ---

This is more of a design issue I''m wrestling with, and was wondering what other people are doing. I have a products table with status values of In Stock, Out of Stork or Discontinued. This is unlikely to change any time soon. Approach A, is to have thses actual values in the status column, at least the meaning is very apparent, yet querying for products with a specific status could

Hey guys, I''m putting together an app with user profiles, and each user will be able to update a section called ''quick stats''. This will involve lots of drop down lists with options like ''hair colour'', ''height'', ''Location'' etc etc. The way I m thinking about doing it is to create new table for each group of options

I''ve been struggling a bit trying to figure out the best way to design/implement a system with authentication/authorization, and was hoping some of you may be able to offer some advice.. At the moment, I have a system with 4 different types of users - clients, administrators, sales_reps, and public_users. I''m using "Authorizing Users with Roles" from the Rails Recipes

I am trying to decide between two different database architectures for an application to manage properties. For capturing the property features, I have two options: a single model/table with all the features as fields, or a set of joined models - property, feature, feature data. (see attached ERD diagram) OPTION A Properties name address has_pool has_doorman has_etc. (a bunch of values, not all

Performace hits? Integration with existing applications? Security? Bugs? Memory use? -Ben Lisbakken -- Posted via http://www.ruby-forum.com/.

...lO8uSVbKJgfAIhJhsHhvQyDvoLg1mQ0gJLwmGh1iEpRbRRYX6tyi0Fa1txfqabCJu UEsUtRVFrFhssRWktGi/Itivai2a+f/u7BJN69fO3d85555z7uvcM3dnhhgRWSlCEvnbVrZ2Uhpd A83rQH7bujXqrs631kH+gMg09tudS1YGH/64hsicS6T8ZsmKDd9+3ncxgg7+RiTJHe2tiz+1Fkwm sl1Am0kdUGSttG4lsl+O+uiOlWtuyvgLn4C6GMO6YlVbKxvO4qgHUbesbL2pU95i/QHqYdTVG1pX th+3NF+HekTUO1d1rdGr6ReoP4j65Z03tnfOHXjpQ9R/TZSqQ8dQxGUlE2WAjyUODcdsD1AekK88 QnmylzB//SyAdelnB5bqHwi74PyvaIUZGSDaR0+wpfQEHaQX2QW0eor6qJd+TTlUTz+ijXQvbcNI C6C5g+aiKNDfy/L0XiqlhxDTh+gIfK+jTXSAslmu/iFtpq3SMbTaSuk0impoNq2iu9g1+lpqppPy rVSO+N9AnSyiB/W79Xv0n9LPqE/6tf4ldiaf2lCO6B8pv9P/QCVo8QPaTSfZPSlPkx+jROD5Y7q...

...DYSYwMx/hKOgnZnmNNsjJ83J42Ba+QTz7ktY Au4Wz1dayTPNWWkva8ErOYM4566okKPSk1bLnFehnOEeY3R95aYw7Rks0up8XzndY4q8Kgbz xe8B0qC9INX7apz5MhtbFznDPUYOl864pKVdjphyIFZja0J60vJV1thUVh+VVhdF+jq6l0iD 9up+DSxxFE54hUlzKHL2tJwujnjriaWCYOsNQkVZz05aemxopwcFn6Vd/it92o1yzrJMOXKr JR+vnOrj517yG3/wqR/9tc8snrz7+35z94+/fue/OfVv3nfG2ZdffvlXvvKVhx9++LHHHtN9 2oPdMqfiyuqIiv9gVzq01wa31QEejbtBL5QqoJ3vjl5KiSXgXJrpydk5+MwOfDSi6yvqmCau hNIuCCdRPu1VQDtRFHxopxtDKYMUvx0WIfZgy+S8LAQnRCS4LfmgXf2QbSdMQbs+EKuxlfO7 HvNpSmsbzLiIPpNvYyxYF2n5mlFoL2sUDvbYJUJ7GqE5r6kI2tPam7NFVWGUc0K7s2vlQLt0 j9GTPQl8bTvUDe3atUtw+3v+686X/PI5rZdd1vrlKxd/87pj3/SlH33...

...m`HLqL zK#)NIU-C(}*Q^NOZeJU_?Uh}(n_ZW<p`N&5`OUo~m)ng^`B8$z^`7Pv1sC&osPorY zjn#qNoI}Jnmk?oSjDP>6Sw=;s&8+!&#fnge;`!|uCOI!dcV|{ml)s+lu32TwRJ4~f zlhucO_g)xKpDG7*2e|G-O63)4Z0A5>D4<S!EN!H={pf7-$v1pl;}Y>Vu_)>^N>In6 z3J*my6!kjWuxhZkij$rxkHZ2JS7T5Y-Hg(~<BQ=hmxeBWk^EJo_3NF;YbQG2iEHHU z;3(`(bm}%8Ip8ui;@lk=w;-H;5DxRF@%D!`g8ST%!6}y$F0b9PZ)SXVzP5w at xP~r0 zl&f9LB1P<cVhD;R0ps%-srwI4?oQ@?Z}1B*&1Q=vz%K2?EC%j^Klly?<>W&|@e{dy z at 9|zd<HLO}6(Rm6m#pG*YR03Xy*>p0sh^i4>^2DFRy<!Ownh=XHxHj*_qG)x&YZth z?;ZV>06T#N!onXSlVYt)2&>6b%n^rMzG0...