RE: DB - data model guidelines, suggestions?

Hi

>From first thoughts it would seem that you could do the following
splits. You could have a table that contains all the different types of
notching styles, another for the available log species, another for the
available foundation materials etc. If you have any field which could
have multiple values then you may want to create a relational table just
for those values. Therefore you would have one entry in the structure
table with an ID and then in the other table you have say x number of
entries that relate to that ID. Anyway hope this helps...

Later,
Mr Brett
 
"That's a pain that will surely linger, and that's no lie"
- Ed Grimely
-----Original Message-----
From: owner-hwg-techniques(at)hwg.org [mailto:owner-hwg-techniques(at)hwg.org]
On Behalf Of Tenley Shewmake
Sent: Saturday, 22 June 2002 10:35 PM
To: HWG Techniques
Subject: DB - data model guidelines, suggestions?

Hi All,

I'll soon be creating my first relational database to display a list of 
one of a kind log structures, each with a link to a feature page for 
each building. My only previous experience is manipulating a text file 
that contained a "categories" field, but only one line per item.

Each structure has at least 30 pieces of information related to it, from

   square footage, log notching style, date of construction, date of 
acquisition, log size, log species, foundation material, video clip and 
pictures ...

Users may want to sort by building size, log size, date of construction 
and other criteria (I'll query the site owner and staff to get a feel 
for this).

Off the top of my head I cannot see where to split the information into 
multiple tables. Theoretically 2 buildings could be identical except for

name/ID. If these were permanently located buildings, as for a real 
estate site, I could see that adding a table of school districts or 
nearby public parks would be useful.

Ideas, suggestions, websites welcomed.

Thanks in Advance,

Tenley

Tenley Shewmake, Webmaster Alterra Furniture
http://www.awebresource.com/furniture/
ts(at)awebresource.com

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA