ALTER TABLE DimCountryCode
ALTER COLUMN CountryNumericCode int NOT NULL

ALTER TABLE DimCountryCode
ADD CONSTRAINT PK_DimCountryCodeCountryNumericCode
PRIMARY KEY NONCLUSTERED(CountryNumericCode)

ALTER TABLE DimDate
ADD CONSTRAINT PK_DateRelation
PRIMARY KEY NONCLUSTERED(DateRelation)

ALTER TABLE DimPowerPlant
ALTER COLUMN Id int NOT NULL

ALTER TABLE DimPowerPlant
ADD CONSTRAINT PK_DimPowerPlantId
PRIMARY KEY NONCLUSTERED(Id)

ALTER TABLE FactNuclearPowerPlant
ALTER COLUMN Id int NOT NULL

ALTER TABLE FactNuclearPowerPlant
ALTER COLUMN CountryNumericCode int NOT NULL

ALTER TABLE FactNuclearPowerPlant
ADD CONSTRAINT PK_DFactNuclearPowerPlanttId
PRIMARY KEY NONCLUSTERED(Id)

ALTER TABLE FactNuclearPowerPlant
ADD CONSTRAINT FK_CountryNumericCode_DimCountryCode_CountryNumericCode
FOREIGN KEY(CountryNumericCode) references DimCountryCode(CountryNumericCode)

ALTER TABLE FactNuclearPowerPlant
ADD CONSTRAINT FK_Id_DimPowerPlant_Id
FOREIGN KEY(Id) references DimPowerPlant(Id)

ALTER TABLE FactNuclearPowerPlant
ADD CONSTRAINT FK_DimNppConstructionStartAt_DimDate_DateRelation
FOREIGN KEY(DimNppConstructionStartAt) references DimDate(DateRelation)

ALTER TABLE FactNuclearPowerPlant
ADD CONSTRAINT FK_DimNppOperationalFrom_DimDate_DateRelation
FOREIGN KEY(DimNppOperationalFrom) references DimDate(DateRelation)

ALTER TABLE FactNuclearPowerPlant
ADD CONSTRAINT FK_DimNppOperationalTo_DimDate_DateRelation
FOREIGN KEY(DimNppOperationalTo) references DimDate(DateRelation)