authors table

authors is defined as follows:

create table authors
(au_id id not null,
au_lname varchar(40) not null,
au_fname varchar(20) not null,
phone char(12) not null,
address varchar(40) null,
city varchar(20) null,
state char(2) null,
country varchar(12) null,
postalcode char(10) null,
unique nonclustered (au_id))

Its nonclustered index for the au_lname and au_fname columns is defined as:

create nonclustered index aunmind
on authors (au_lname, au_fname)

The phone column has the following default:

create default phonedflt as "UNKNOWN"
sp_bindefault phonedft, "authors.phone"

The following view uses authors:

create view titleview
as
select title, au_ord, au_lname,
price, num_sold, pub_id
from authors, titles, titleauthor
where authors.au_id = titleauthor.au_id
and titles.title_id = titleauthor.title_id

Table B-2 lists the contents of authors:

Table B-2: authors table

au_id

au_lname

au_fname

phone

address

city

state

country

postalcode

172-32-1176

White

Johnson

408 496-7223

10932 Bigge Rd.

Menlo Park

CA

USA

94025

213-46-8915

Green

Marjorie

510 986-7020

309 63rd St. #411

Oakland

CA

USA

94618

238-95-7766

Carson

Cheryl

510 548-7723

589 Darwin Ln.

Berkeley

CA

USA

94705

267-41-2394

O’Leary

Michael

408 286-2428

22 Cleveland Av. #14

San Jose

CA

USA

95128

274-80-9391

Straight

Dick

510 834-2919

5420 College Av.

Oakland

CA

USA

94609

341-22-1782

Smith

Meander

913 843-0462

10 Mississippi Dr.

Lawrence

KS

USA

66044

409-56-7008

Bennet

Abraham

510 658-9932

6223 Bateman St.

Berkeley

CA

USA

94705

427-17-2319

Dull

Ann

415 836-7128

3410 Blonde St.

Palo Alto

CA

USA

94301

472-27-2349

Gringlesby

Burt

707 938-6445

PO Box 792

Covelo

CA

USA

95428

486-29-1786

Locksley

Chastity

415 585-4620

18 Broadway Av.

San Francisco

CA

USA

94130

527-72-3246

Greene

Morningstar

615 297-2723

22 Graybar House Rd.

Nashville

TN

USA

37215

648-92-1872

Blotchet-Halls

Reginald

503 745-6402

55 Hillsdale Bl.

Corvallis

OR

USA

97330

672-71-3249

Yokomoto

Akiko

415 935-4228

3 Silver Ct.

Walnut Creek

CA

USA

94595

712-45-1867

del Castillo

Innes

615 996-8275

2286 Cram Pl. #86

Ann Arbor

MI

USA

48105

722-51-5454

DeFrance

Michel

219 547-9982

3 Balding Pl.

Gary

IN

USA

46403

724-08-9931

Stringer

Dirk

510 843-2991

5420 Telegraph Av.

Oakland

CA

USA

94609

724-80-9391

MacFeather

Stearns

510 354-7128

44 Upland Hts.

Oakland

CA

USA

94612

756-30-7391

Karsen

Livia

510 534-9219

5720 McAuley St.

Oakland

CA

USA

94609

807-91-6654

Panteley

Sylvia

301 946-8853

1956 Arlington Pl.

Rockville

MD

USA

20853

846-92-7186

Hunter

Sheryl

415 836-7128

3410 Blonde St.

Palo Alto

CA

USA

94301

893-72-1158

McBadden

Heather

707 448-4982

301 Putnam

Vacaville

CA

USA

95688

899-46-2035

Ringer

Anne

801 826-0752

67 Seventh Av.

Salt Lake City

UT

USA

84152

998-72-3567

Ringer

Albert

801 826-0752

67 Seventh Av.

Salt Lake City

UT

USA

84152