July 01, 1999 05:01 PM

SQL By Design: The Circular Reference

Rating: (0)
SQL Server Magazine
InstantDoc ID #5448
Come around to better database design
This month, instead of starting with an idea and creating a model to support the concept, I'll analyze a poor design construct: a situation I call the circular reference. A circular reference is a recursive condition in which one table references a second table, which in turn references the first table.

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Very easy to follow and read. Thanks

Paola8/24/2009 8:30:58 PM


This is interesting, I have a table representing phases of construction. My problem is phase A and B need to be completed before phase C, and when C is completed phases D and E can begin. I established a one/many to one/many relationship table, but it's circular back to the phase table. Recommendation?

ROBERT6/9/2004 6:00:21 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS