1)

Creating an index to zip code column of table vendor

CREATE INDEX zip_index

ON Vendor (zip_code);

2)

Creating table members, groups and members_groups as shown in ERD.

CREATE TABLE members

(

               member_id                                      INT NOT NULL,

               first_name                                        VARCHAR(20),

               last_name                                         VARCHAR(20),

               address                                              VARCHAR(50),

               city                                                      VARCHAR(15),

               state                                                   CHAR(2),

               phone                                                 VARCHAR(2),

               PRIMARY KEY (member_id)

);

CREATE TABLE groups

(

group_id                                           INT NOT NULL,

group_name                                    VARCHAR(20),

               PRIMARY KEY (group_id)

);

CREATE TABLE members_groups

(

               member_id                                       INT NOT NULL,

               group_id                                            INT NOT NULL,

               PRIMARY KEY (member_id, group_id),

               FOREIGN KEY (member_id) REFERENCES members (member_id),

               FOREIGN KEY (group_id) REFERENCES groups (group_id)

);