That's obvious.

I'm trying to write a generic...

Instead of simply removing the (un)original article and breaking Internet's continuity, could you post links to the articles it was plagiarizing?

That means you want to be in the senior management!

Yelena,

What's the significance of "4" in the title? Does that that mean "a low peon below Database Administrators 1-3"?

Sergiy,

I disagree. Business rules should not dictate how you name database objects.

Michael,

Do you really like typing all these underscores? Couldn't you get away with camel case? To me, tOrderItem, OrderItemID, PK_tOrderItem look much more readable.

Yes, the empty files will cause multiple GOs. But these don't hurt!

We keep every object in a separate file, as created originally by "Generate script". So for each table I have 4 files: .tab with field definition, .kci for primary key,...

it was <tablename>ID , but the browser ate the tablename in angle brackets

Order(ID,CustomerID,...)

LineItem(ID,OrderID,ProductID,Quantity,...)

View: Order with LineItemCount:

SELECT o.ID, o.CustomerID, ..., Count(l.ID) AS LineItemCount

FROM Order o INNER JOIN LineItem l ON o.ID=l.OrderID

GROUP BY o.ID, o.CustomerID, ...

This way the programmer doesn't have to calculate the...

Usually when people speak about master-child relationship, they mean one-to-many. For example, one purchase order contains many line items. Obviously, in this case you couldn't use the PONumber as the...