Subject:
|
Re: A Technic set DB outline
|
Newsgroups:
|
lugnet.admin.database
|
Date:
|
Mon, 30 Nov 1998 03:40:18 GMT
|
Reply-To:
|
lpien@ctp.IWANTNOSPAM&stopspam&.com
|
Viewed:
|
654 times
|
| |
|
|
Jim Hughes wrote:
Disclaimer: I am not a DBA but I do know enough SQL to be dangerous.
Interesting. I comment on this as if it were a logical DB design. Do
you have a downloadable schema (for erwin or whatever?)
Some comments:
Is recno designed to get round the set number not being unique? I'd
prefer to see it called "set ID" or similar.
Theme table seems empty.
MinifigTable. Will this just index into images. For Technic that's fine,
but for real minifigs it may be better to model the parts separately, so
a minifig is comprised of a torso, arms, legs, hands, head, hairpiece,
etc.
Also, the dates are derived data. Drop them. Instead, have the sets
reference minifigs via a minifig-set association table, This then allows
you to derive the intro and disco dates.
Set Table.
What do the indexterms in the set table do?
I would rather see the set names in a separate table. 8 fields is too
many for most
Are the intro and disco dates by "model year"? How do you capture mid
year intros? For a set stated to be available Jun 99, do you put in May
because that's when it was orderable from S@H??
Both the element and minifigs need to be done with intermediate
associations.
Color is totally derivable from elements if modeled correctly, unless
this is noting the "sense" of the model color.
Instructions should be a separate table instead of carrying three slots.
I feel this is a very good start!
--
Larry Pieniazek http://my.voyager.net/lar
For me: No voyager e-mail please. All snail-mail to Ada, please.
- Posting Binaries to RTL causes flamage... Don't do it, please.
- Stick to the facts when posting about others, please.
- This is a family newsgroup, thanks.
|
|
Message has 1 Reply:
 | | Re: A Technic set DB outline
|
| Larry: Thanks for your comments, this is exactly the type of discussion I hoped posting this would generate: (...) Yes. (...) It is. I am still trying to figure out how to put themes and subthemes into a table. (...) This makes alot more sense than (...) (26 years ago, 30-Nov-98, to lugnet.admin.database)
|
Message is in Reply To:
| | A Technic set DB outline
|
| Hi: First, thanks for everyone's help with my earlier database question. Here is a new one: does anyone have a Lego database in a true relational format (with all of the normalization, etc)? I have come up with an outline that will hold all of the (...) (26 years ago, 30-Nov-98, to lugnet.admin.database)
|
9 Messages in This Thread:
 
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
Active threads in Database
|
|
|
|
|
|
