Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2002-11-07 : 10:40:16
|
| Hello,I am trying to find an article that shows how to create a good Network database model. The Network model is a model that was developed in-between the Hieratical model and the relational database model. The main problem of Hierarchical structure is that a parent can have multiple children but a child cannot have multiple parents.(This makes it impossible to handle many-to many relationship without creating redundancy). Fortunately I know that the Network model is a type of hierarchical model where a child can have more that one parent. It’s exactly the type of structure I need. But I do not know how to implement it because I cannot find cannot find any article on it. Can somebody please tell me how to structure this type of model, or where I could find a good article on the subject? Thank you.Eugène |
|
|
r937
Posting Yak Master
112 Posts |
Posted - 2002-11-07 : 12:06:40
|
| it's been years since i drew network schema diagrams (see [url]http://r937.com/20020514.cfm[/url])i believe what you're looking for is a Person record, related to a RelatedTo record via two sets -- ParentOf and ChildOfactually, it's completely analagous to the same structure in a relational schemaunless you're actually building a network database, you can get what you want in a relational database using the same many-to-many relationship table as you would currently use between two tables, except the two tables are one and the same (if you know what i mean)rudy |
 |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2002-11-08 : 11:21:59
|
| Hello Rudy,I really liked you stamp, where can I order one? (Just joking) It’s just a bit surprising for me to see the architectural tools that where used just a few years back! (I was not doing database design in those years). In a more serious manner, thanks for the advice. I will do my design using a relational model.Have a nice day.Fred. |
|
|
|
|
|
|
Network Hierarchical database design