CREATE TABLE Person ( id INTEGER PRIMARY KEY CHECK (id > 0), first_name VARCHAR(15) NOT NULL, second_name VARCHAR(20) NOT NULL, birthdate DATE DEFAULT SYSDATE NOT NULL, mother_id INTEGER CONSTRAINT Person_fk_mother REFERENCES Person, father_id INTEGER CONSTRAINT Person_fk_father REFERENCES Person ); CREATE TABLE Identifier ( nr INTEGER PRIMARY KEY CHECK (nr > 0), person_id INTEGER REFERENCES Person NOT NULL, issue_date DATE NOT NULL, valid_until DATE ); CREATE TABLE Address ( person_id INTEGER REFERENCES Person, start_date DATE NOT NULL, end_date DATE, street VARCHAR(10) NOT NULL, house VARCHAR(5) NOT NULL, room VARCHAR(5), zipcode CHAR(6) NOT NULL, city VARCHAR(10) NOT NULL, PRIMARY KEY (person_id, start_date), CHECK (start_date < end_date or end_date is null) ); CREATE TABLE Marriage ( wife_id INTEGER REFERENCES Person, husband_id INTEGER REFERENCES Person, start_date DATE, end_date DATE, PRIMARY KEY (wife_id, husband_id, start_date), CHECK (start_date < end_date or end_date is null), CHECK (wife_id != husband_id) );