SQL tables and relationships

[johnsocb]

I posted a question a few days ago about documenting a complex db. Anyway since then I have found some tools that have helped me with this process. To make a long story short I am at odds with this db that I trying to get to know.

This db has 77 tables and NO PRIMARY KEY or FOREIGN KEYS???
All of the tables are INDEPENDENT. It has many stored procedures and functions. How can this be? By all means I am not a SQL / DB guru but I am lost. Is it possible that this SQL db has been normalized beyond reason? I can tell you one thing this application runs like a dream and is a .net app like I have never seen.
Can any db or SQL guru's explain to me what is going on here??

Thanks
Baffled

[willakawill]

I posted a question a few days ago about documenting a complex db. Anyway since then I have found some tools that have helped me with this process. To make a long story short I am at odds with this db that I trying to get to know.

This db has 77 tables and NO PRIMARY KEY or FOREIGN KEYS???
All of the tables are INDEPENDENT. It has many stored procedures and functions. How can this be? By all means I am not a SQL / DB guru but I am lost. Is it possible that this SQL db has been normalized beyond reason? I can tell you one thing this application runs like a dream and is a .net app like I have never seen.
Can any db or SQL guru's explain to me what is going on here??

Thanks
Baffled

Hi. I guess all of the joins are run in code which is not unusual. All done in SQL.