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:
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 |