Figure 2 The PEOPLE table CREATE TABLE PEOPLE ( PERSONID INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, VERSION INT NOT NULL, FRSTNAM CHAR(25) NOT NULL, LSTNAM CHAR(25) NOT NULL, DOB DATE NOT NULL, GENDER CHAR(1) NOT NULL, CNTRY INT NOT NULL );
CREATE TABLE PEOPLE ( PERSONID INT GENERATED ALWAYS AS IDENTITY PRIMARY KEY, VERSION INT NOT NULL, FRSTNAM CHAR(25) NOT NULL, LSTNAM CHAR(25) NOT NULL, DOB DATE NOT NULL, GENDER CHAR(1) NOT NULL, CNTRY INT NOT NULL );