Hello everybody,

To see how the biggest software company in the world (probably) constructs a database (object naming, etc.), i took a look at the Microsoft Office Project Server 2003 database. I was shoked to see that there is no FK in the database. And the database has over 200 tables.

Does anybody know why?

defiant.

They do not want you to figure out how it is built inside. There are FK's, but they are not declared. Their front end it almost bullet proof enough that they do not break rules. The FK's in other tables do not have the same field names eithe (bummer), but if you know your project well enough, you can crack the code.



Sal