CREATE TABLE member  ( member_no        member_no    NOT NULL IDENTITY(1,1),    lastname         shortstring  NOT NULL ,    firstname        shortstring  NOT NULL ,    middleinitial    letter           NULL ,    photograph       image            NULL )CREATE TABLE adult  ( member_no        member_no    NOT NULL ,    street           shortstring  NOT NULL ,    city             shortstring  NOT NULL ,    state            statecode    NOT NULL ,    zip              zipcode      NOT NULL ,    phone_no         phonenumber      NULL ,    expr_date        datetime     NOT NULL )CREATE TABLE juvenile  ( member_no        member_no    NOT NULL ,    adult_member_no  member_no    NOT NULL ,    birth_date       datetime     NOT NULL )

ALTER TABLE member  ADD CONSTRAINT member_ident PRIMARY KEY CLUSTERED     (member_no) ALTER TABLE adult  ADD CONSTRAINT adult_ident PRIMARY KEY CLUSTERED    (member_no) ALTER TABLE juvenile  ADD CONSTRAINT juvenile_ident PRIMARY KEY CLUSTERED       (member_no) 

ALTER TABLE adult  ADD CONSTRAINT adult_member_link FOREIGN KEY (member_no)       REFERENCES member (member_no)ALTER TABLE juvenile  ADD CONSTRAINT juvenile_member_link FOREIGN KEY     (member_no) REFERENCES member (member_no)ALTER TABLE juvenile  ADD CONSTRAINT juvenile_adult_link FOREIGN KEY     (adult_member_no) REFERENCES adult (member_no)