Cross Table References

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "doverj via SQLMonster.com" <u42617@uwe>
Date: Thu, 03 Apr 2008 20:18:18 GMT

I'm curious about theory of cross table references. I understand the need
but I'm wondering best practices. Specifically, should Cross-tables only be
made up of foreign keys or is it possible to have other columns?

For example, would this be an acceptable solution.
Borrower (BorrowerID)
LoanType (LoanTypeID)
CrossTable (BorrowerID, LoanTypeID, LoanScore, LoanValue)

Or should cross-table only be made up of keys.
Borrower (BorrowerID)
LoanType (LoanTypeID)
CrossTable (BorrowerID, LoanTypeID)

Thank you.

--
Message posted via http://www.sqlmonster.com

.

Next by Date: Cross Table References
Next by thread: Cross Table References
Index(es):
- Date
- Thread

Relevant Pages

Re: Cross Table References
... Specifically, should Cross-tables only ... made up of foreign keys or is it possible to have other columns? ... CrossTable (BorrowerID, LoanTypeID, LoanScore, LoanValue) ...
(microsoft.public.sqlserver.datawarehouse)
Cross Table References
... Specifically, should Cross-tables only be ... made up of foreign keys or is it possible to have other columns? ... CrossTable (BorrowerID, LoanTypeID, LoanScore, LoanValue) ...
(microsoft.public.sqlserver.datawarehouse)