SQL By Design: The Circular Reference

Rating:

(0)

Michelle A. Poolet

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.

ARTICLE TOOLS

Want to use this article? Click here for options!

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

Already a Professional Member? Please log in now:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Very easy to follow and read. Thanks

andrea_vngs 8/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?

Robert 6/9/2004 6:00:21 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

Business Process Automation - Managing Cost in Your Enterprise
A EBooks by Network Automation

Special Report: Perspectives on SQL Server Sprawl
A Essential Guides by PolyServe

Preparing Your Infrastructure for the SQL Server 2008 Upgrade
A EBooks by HP

How to Select the Right Search Solution for Your Business
A Podcasts by BA-Insight

Fax Service keeps stopping

Hello, first post. I have a question I need some help with, I haven't been able to find anything to match my criteria elsewhere yet. But anyway, in ou...

Network Engineer Position In New York City
cannot preview DOC file
Can SQL 2005 Standard Be Installed on SBS 2003?

GOOGLE LINKS

eBooks

Playbook for a Virtualized Datacenter | During challenging times, optimizing the IT infrastructure becomes imperative. Many organizations are looking to extend their virtualization efforts to encompass the entire datacenter. Get a step-through of your technology options and more.

White Papers

As the advances in USB devices have made them invaluable to most business users’, they have also exposed organizations to enormous risks. Learn how to easily enforce device/port control and data encryption policies without requiring new infrastructure and additional admin overhead.

WEB SEMINARS

Is Flexible Lockdown Possible? Join Darren Mar-Elia for this free web webinar exploring the various methods you should consider to protect and control your desktops while also understanding the impact on the end user community.
View Seminar On-Demand.

eLearning Series

Windows IT Pro brings the experts direct to you to share their real-world perspective, experience, and expertise. During each event, three sessions stream in real time, allowing you to learn, to ask questions, and to get solutions.
Upcoming event: SQL Server Consolidation