Relationship between two tables

Hi,
We can create more than one
relationship between two tables. Could you tell me a situation where we nee
d two relationships between two tables?
ThanksSay you have a customers table and a table that represents a transaction bet
ween two customers holding two columns with a customer id. The referencing t
able would need to have two foreign keys pointing on the customerid
--
BG, SQL Server MVP
www.SolidQualityLearning.com
"Chrissi" <anubisofthydeath@.hotmail.com> wrote in message news:OM$bER0VFHA
.1404@.TK2MSFTNGP09.phx.gbl...
Hi,
We can create more than one
relationship between two tables. Could you tell me a situation where we nee
d two relationships between two tables?
Thanks|||Hi
You can have that kind of relationship but it violates 2nd and 3rd Normal
Forms:
For Eg:
Table_Student
Name Subject-ID Room-Number
Table_Class Room
Subject-ID Subject-Desc Room-Number
was this your question?
best Regards,
Chandra
http://chanduas.blogspot.com/
http://www.examnotes.net/gurus/default.asp?p=4223
---
"§Chrissi§" wrote:

>|||> You can have that kind of relationship but it violates 2nd and 3rd Normal
Not necessarily. Suppose we have the following
Create Table Employees
(
Id Int Primary Key
, LastName VarChar(25)
, FirstName VarChar(25)
)
Create Table ManagerStaff
(
Id Int Primary Key
, ManagerId Int References Employee(Id)
, SubordinateId Int References Employee(Id)
, StartDate DateTime
, EndDate DateTime
)
I have two relationships to the Employees table yes this is still normalized
to
third normal form.
Thomas

ReInstalling Katmai.

I cannot reinstall Katmai.
Somehow, I created a situation where Management Studio could not connect to reporting services. Being unable to diagnose why, I decided to uninstall and reinstall. I had installed everything. After running about 10 uninstalls, I went to C:/Program Files/ and blasted the whole Microsoft SQL Server tree. I went to the registry and did the same thing in HKLM/Software/Microsoft/Microsoft SQL Server.
I rebooted. The error message: An instance with the same name is already installed on this computer. I'm guessing the setup program detected MSSQLSERVER in some registry key, and not another instance, but if I knew which one, I wouldn't be posting to this forum.

It may be that Control Panel|Administrative Tools|Services has an SQL Server(InstanceName) entry.
sql