DDL in PostgreSQL

I made the DDL for the HR Database using the Physical ERD normalized to 3NF.

I used PostgreSQL.

I created the employee_history table with the CREATE TABLE command, I added primary key and all the atrributes:

Then I added constraints to the table for adding the foreing keys with ALTER TABLE: