create table Cars (
	ID int identity primary key,
	Name nvarchar(255) not null,
	BHP int not null,
	ID_Owner int
);

create table Owners (
	ID int identity primary key,
	FirstName nvarchar(255) not null,
	LastName nvarchar(255) not null
);

create table Addresses (
	ID int identity primary key,
	Street nvarchar(255) not null,
	HouseNumber nvarchar(255) not null,
	City nvarchar(255) not null,
	ZIPCode nvarchar(255) not null,
	ID_Owner int not null
);


alter table Cars add foreign key (ID_Owner) references Owners(ID);
alter table Addresses add foreign key (ID_Owner) references Owners(ID);