what is your idea for my database design? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

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.

All Forums

General SQL Server Forums

Database Design and Application Architecture

what is your idea for my database design?

Author

Topic

sepidar.902
Starting Member

3 Posts

Posted - 2012-09-25 : 23:16:23

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

277 Posts

Posted - 2012-09-28 : 10:08:14

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

sepidar.902
Starting Member

3 Posts

Posted - 2012-09-28 : 13:21:21

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

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2012-09-28 : 13:42:11

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

sepidar.902
Starting Member

3 Posts

Posted - 2012-10-03 : 04:50:13

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.

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2012-10-03 : 08:44:24

you are welcome

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources