Hello, thank you for the reply, you will see below 3 different statements i have written above what statements goes with what tables.

Firstly the Address Table

CREATE TABLE [dbo].[Address](

[AddressID] [int] IDENTITY(1,1)...