Re: understand basics - multiple cars in a database - selection of one

David Johnston wrote
> cars-properties

Note that typically "properties" of an object/entity are modeled as
attributes/columns on the entity table.

cars [ carid serial, car_make text, car_model text, car_year text]

as opposed to separate tables. That main reason for this is that each
property has a specific data type to which correct values must conform. A
generic "cars-properties" table would require that all property values be
stored as text.

Note that it is also valid to define cars like:

cars [ carid serial, car_properties hstore|json ]

so that the properties are a simple key-value table. A combination of both
can work as well.

This is where "Database Design" comes into play and as mentioned many
excellent books exist on the topic. Once you have a design you then develop
whatever UI elements that are needed to properly interact with it. While UI
is most important there is ample room for layering and facade-ing that
settling for a known sub-optimal database design will likely be painful in
the long-run.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/understand-basics-multiple-cars-in-a-database-selection-of-one-tp5790571p5790597.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.