Write a script that adds an index to the AP database for the zip code field in the Vendors table. Write a script that contains the CREATE TABLE statements needed to implement the following design in the EX database: These tables provide for members of an association, and each member can be registered in one or more groups within the association. The member_id and group_id columns ate the primary keys of the Marten and Groups tables, and these columns are foreign keys in the Members_groups table. Include any constraints or default values that you think are necessary. Include statements to drop the tables if they already exist