When I try to design relation database using MSSQL Server 2008, I find that the MSSQL Server 2008 allow designer can create two relationships with one direction from a table to other table (for example, I have two table A an B, I can create two relationship from table A to table B with key from table A map with some field in table B). Please let me know in the real-world, do we need some relationships between two tables like that?
Many Thanks,
John.