SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 what is your idea for my database design?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sepidar.902
Starting Member

Iran
3 Posts

Posted - 09/25/2012 :  23:16:23  Show Profile  Reply with Quote
hello people

i want to group my products and projects in my accounting software that every group may contain some other groups and some products for unknown depth.
see bellow:


or this chart to understand more.
please tell me what is your solution.
thank you very much.

xhostx
Constraint Violating Yak Guru

USA
277 Posts

Posted - 09/28/2012 :  10:08:14  Show Profile  Reply with Quote
Is is NOT clear what you want to achieve!!
Are you on the stage of Modeling your Logical design? or designing Entity relation diagram. Tells us more about the scenario if you need help.

--------------------------
Joins are what RDBMS's do for a living
Go to Top of Page

sepidar.902
Starting Member

Iran
3 Posts

Posted - 09/28/2012 :  13:21:21  Show Profile  Reply with Quote
quote:
Originally posted by xhostx

Is is NOT clear what you want to achieve!!
Are you on the stage of Modeling your Logical design? or designing Entity relation diagram. Tells us more about the scenario if you need help.


thanks alot for your reply.
if it possible for you, Please tel me your idea about Modeling my Logical design and designing ERD.
thank you very much.
--------------------------
Joins are what RDBMS's do for a living

Go to Top of Page

xhostx
Constraint Violating Yak Guru

USA
277 Posts

Posted - 09/28/2012 :  13:42:11  Show Profile  Reply with Quote
well, it will be hard for me to provide you with a good example because you never provided any scenario (example).Anyways, it sounds to me like you have Parent <> Child on the Tree model you provided.

This link
http://www.pure-performance.com/2009/03/managing-hierarchical-data-in-sql/
may give you an idea of how you can reference a Child attribute to its parent attribute.
Keep in mind the heritage concept while modeling you data (maybe specific to your case)



--------------------------
Joins are what RDBMS's do for a living
Go to Top of Page

sepidar.902
Starting Member

Iran
3 Posts

Posted - 10/03/2012 :  04:50:13  Show Profile  Reply with Quote
quote:
Originally posted by xhostx

well, it will be hard for me to provide you with a good example because you never provided any scenario (example).Anyways, it sounds to me like you have Parent <> Child on the Tree model you provided.

This link
http://www.pure-performance.com/2009/03/managing-hierarchical-data-in-sql/
may give you an idea of how you can reference a Child attribute to its parent attribute.
Keep in mind the heritage concept while modeling you data (maybe specific to your case)



--------------------------
Joins are what RDBMS's do for a living



thanks alot my dear friend.
it's OK.

Edited by - sepidar.902 on 10/03/2012 04:52:12
Go to Top of Page

xhostx
Constraint Violating Yak Guru

USA
277 Posts

Posted - 10/03/2012 :  08:44:24  Show Profile  Reply with Quote
you are welcome

--------------------------
Joins are what RDBMS's do for a living
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000