Foreign Key Referential Integrity

See more:

SQL

server

Hi,

I have four tables which goes like this,

Customer(CustomerID INT, Name Varchar(10))
Supplier(SupplierID INT, Name Varchar(10))
Employee(EmployeeID INT, Name Varchar(10))

Address(AddressID INT, Street Varchar(10), City Varchar(10))

Here Customer, Supplier and Employee tables each will have a foreign key relationship with Address table. How do I build a relationship between Address table and others table so that I can maintain referential integrity.

Please help!!!

Thanks in advance