Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456

Stairway to Database Design - STEP 1: Data Elements Expand / Collapse
Author
Message
Posted Wednesday, July 10, 2013 9:40 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:53 AM
Points: 2,268, Visits: 1,326
John Mitchell-245523 (7/10/2013)
Ross McMicken (7/10/2013)
What's the conversion factor from pallet to liters?

There isn't one, because they're different entities and therefore should not be stored in the same column. If you do as you suggest, you'll end up with something that looks like an EAV table. Some people are comfortable with that; others think that EAVs should be avoided at all costs. You'll make up your own mind, of course.

John


I look at this a a rule of logic. If something can be standardized as far say as weight then it is standardized. If it is not possible, it is not possible.

And as far as EAVs they might be useful but only under certain conditions. I have not found one yet, but have entertained the idea as well as what use to be called a data heap before that we redefined.



Not all gray hairs are Dinosaurs!
Post #1472211
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse