To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.db.brictionaryOpen lugnet.db.brictionary in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Database / Brictionary / 105
104  |  106
Subject: 
Re: Online LEGO Inventory Database
Newsgroups: 
lugnet.db.brictionary
Date: 
Thu, 10 Feb 2000 19:48:42 GMT
Viewed: 
3044 times
  
Steve Bliss wrote in message ...
In lugnet.db.brictionary, Steve Hodge wrote:

In lugnet.db.brictionary, Steve Bliss writes:

Yep.  A better approach may be modeling a set of properties.  So a plate • with
holes in it could have both the Technic and Plate properties.  This would • avoid
requiring a hierarchical classification (is that redundant?) system.

Yeah, I agree. One of the other threads had come to the same conclusion • and
are curently trying to decide exactly which properties would be necessary.

Having a good list of properties at the start is a good idea, but don't
hard-code specific properties into the schema.  It's just a many-to-many
relation between parts and properties.  Assuming a relational approach.

It will be a relational database, and I tend to remove all hard codings
possible.
I will be designing the schema later today, and posting it for everyone to
rip apart =)
--Eric



Message is in Reply To:
  Re: Online LEGO Inventory Database
 
(...) Having a good list of properties at the start is a good idea, but don't hard-code specific properties into the schema. It's just a many-to-many relation between parts and properties. Assuming a relational approach. Steve (25 years ago, 10-Feb-00, to lugnet.db.brictionary)

9 Messages in This Thread:


Entire Thread on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact
    

Custom Search

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR