CREATE TABLE CONTACTS11
    (
    ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
    FIRST_NAME VARCHAR(50),
    LAST_NAME VARCHAR(50),
    TITLE VARCHAR(50),
    NICKNAME VARCHAR(50)
    );

    CREATE TABLE EMAIL_ADDRESSES11
    (
    ADDRESS_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
    ID INTEGER NOT NULL ,
    ADDRESS VARCHAR(50),
    DISPLAY_FORMAT SMALLINT,
    MAIL_FORMAT SMALLINT
    );
    
    ALTER TABLE EMAIL_ADDRESSES11
       ADD CONSTRAINT EMAIL_ADDRESSES11_PK Primary Key (
      ADDRESS_ID);

    ALTER TABLE CONTACTS11
       ADD CONSTRAINT CONTACTS11_PK Primary Key (
      ID);


ALTER TABLE EMAIL_ADDRESSES11
   ADD CONSTRAINT CONTACTS11_FK Foreign Key (ID)
   REFERENCES CONTACTS11 (ID);
   
INSERT INTO CONTACTS11 (FIRST_NAME, LAST_NAME, TITLE, NICKNAME)
       VALUES  	('Jake', 'Roberts', 'Mr.', '"The Snake"'), 
               	('Andre', '', 'Mr.', '"The Giant"');   
   

INSERT INTO EMAIL_ADDRESSES11 (ID, ADDRESS, DISPLAY_FORMAT, MAIL_FORMAT)
       VALUES  	(1, 'snake@ifpwafcad.com', 2, 3),
                (2, 'bobo@ifpwafcad.com', 1, 2),
                (1, 'jake@ifpwafcad.com', 1, 3),
                (2, 'haha@ifpwafcad.com', 2, 2);