Design
From: Arne Jonsson <arne.b.jonsson_at_telia.com>
Date: Fri, 28 Sep 2001 20:18:23 GMT
Message-ID: <3bb4d9b2.190568847_at_news1.telia.com>
Some tables in a database are needed to keep track of four physical objects. One of these objects can come in one of three shapes. Shape A has three attributes, shape B two and shape C has only one. Itīs about how and where they are stored. Is it better to have one mothertable for Object and three childs for the different shapes, or can I have one for all of them wiht some fields optional?
Grateful for some advice.
Arne J Received on Fri Sep 28 2001 - 22:18:23 CEST
Date: Fri, 28 Sep 2001 20:18:23 GMT
Message-ID: <3bb4d9b2.190568847_at_news1.telia.com>
Some tables in a database are needed to keep track of four physical objects. One of these objects can come in one of three shapes. Shape A has three attributes, shape B two and shape C has only one. Itīs about how and where they are stored. Is it better to have one mothertable for Object and three childs for the different shapes, or can I have one for all of them wiht some fields optional?
Grateful for some advice.
Arne J Received on Fri Sep 28 2001 - 22:18:23 CEST