publishers table

publishers is defined as follows:

create table publishers
(pub_id char(4) not null,
pub_name varchar(40) not null,
city varchar(20) null,
state char(2) null)

Its primary key is pub_id:

sp_primarykey publishers, pub_id

Its pub_idrule rule is defined as:

create rule pub_idrule
as @pub_id in 
("1389", "0736", "0877", "1622", "1756")
or @pub_id like "99[0-9][0-9]"

Table A-1 lists the contents of publishers:

**Table A-1: publishers table**
pub_id	pub_name	city	state
0736	New Age Books	Boston	MA
0877	Binnet & Hardley	Washington	DC
1389	Algodata Infosystems	Berkeley	CA