Write a script that adds an index to the AP database for the zip code field in t

Question

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.

Explanation / Answer

use AP;
drop index AP.zip_index;
drop table AP.members;
drop table AP.members_group;
drop table AP.groups;

create index AP.zip_index on AP.Vendors(zip_code);

create table AP.members(
member_id int primary key,
First_Name varchar(200),
Last_Name varchar(200),
Address varchar(1000),
city varchar(1000),
state varchar(1000),
phone varchar(10)
);

create table AP.groups(
group_id int primary key,
group_name varchar(1000));

create table AP.members_group(
member_id int foreign key references members(member_id),
group_id int foreign key references groups(group_id));

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.