Search
InstantDoc ID
GO

Browse By: Author | Issue

May 20, 2003 01:20 PM

How Many's Too Many?

In database design, the right relationship is everything
Rating: (0)
Jeffrey Bane
SQL Server Magazine
InstantDoc ID #38656
Were the job of the modern database administrator and developer limited to coding SQL and ensuring good backups, we'd probably all sleep better and have more time to pursue such satisfying hobbies as Thursday night karaoke or hacking the OS of our Furbies. But alas, we must also implement efficient databases in the first place. This task is one of the least enviable in the database world because in no place can you do more good or cause more harm than in designing and implementing a database.

Tho...

...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

Compare Member Benefits

Add a Comment

To datagod: you might find this article of interest too!
Diana May
Sr Technical Editor

[November 2006]
Implementing Supertypes and Subtypes
Why, how, and when
By: Michelle A. Poolet
Solutions by Design
InstantDoc #93241
From the November 2006 edition of SQL Server Magazine

Diana4/19/2007 4:26:54 PM

Loved the article! I have used the super/sub relationships many times without knowing there was an actual official terminology.

William4/17/2007 2:06:22 PM

First of all, good article. But I do have a question. In figure 6, the furniture, trucks and computers subtypes have their PKs named after their types (i.e. FurnitureID, TruckID, etc); however, on figure 1 the subtypes inherited their supertype's PK name (i.e. VehicleID). In the past, I've struggled to decide which format to use, mostly taking the former case, what rules do you adhere to when deciding whether to name the subtypes PK based on their type or based on their supertype's name?

csantos 5/28/2003 9:40:56 AM

The zip file doesn't have the CreateAndPopulateDBs.sql script file. Can it be posted on the FTP site?

tester5/28/2003 9:38:04 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.