create unique index edind

on editors (ed id)

create index ednmind

on editors (ed lname, ed fname)

create unique index teind

on titleditors (ed id, title id)

create index rstidind on roysched (title id) go

insert into authors

values(409-56-7008, Bennet, Abraham,

415 658-9932, 6223 BatemanSt., Berkeley, CA, 94705)

insert into authors

values (213-46-8915, Green, Marjorie,

415 986-7020, 309 63rd St. #411, Oakland, CA, 94618)

insert into authors

valuesC238-95-7766, Carson, Cheryl,

415 548-7723, 589 Darwin Ln., Berkeley, CA, 94705)

insert into authors

values(998-72-3567, Ringer, Albert,

801 826-0752, 67 Seventh Av., Salt Lake City, UT, 84152) go

insert into authors

values(899-46-2035, Ringer, Anne,

801 826-0752, 67 Seventh Av., Salt Lake City, UT, 84152) go

insert into authors

values(722-51-5454, DeFrance, Michel,

219 547-9982, 3 Balding Pi., Gary, IN, 46403)

insert into authors

values(807-91-6654, Panteley, Sylvia,

301946-8853, 1956 Arlington Pi., Rockville, MD, 20853) go

insert into authors

values(893-72-1158, McBadden, Heather,

707 448-4982, 301 Putnam, Vacaville, CA, 95688)

insert into authors

values(724-08-9931, Stringer, Dirk,

415 843-2991, 5420 Telegraph Av., Oakland, CA, 94609) go

insert into authors

values(274-80-939r, Straight, Dick,

415 834-2919, 5420 College Av., Oakland, CA, 94609)

insert into authors

values!756-30-739Г, Karsen, Livia,

415 534-9219, 5720 McAuley St., Oakland, CA, 94609) go

insert into authors

values(724-80-9391, MacFeather, Stearns,

415 354-7128, 44 Upland Hts., Oakland, CA, 94612)

insert into authors

values(427-17-2319, Dull, Ann,

415 8367128, 3410 Blonde St., Palo Alto, CA, 94301) go

insert into authors

values(672-71-3249, Yokomoto, Akiko,

415 935-4228, 3 Silver Ct., Walnut Creek, CA, 94595)

insert into authors

values(267-41-2394, 0 Leary, Michael,

408 286-2428, 22 Cleveland Av. #14, San Jose, CA, 95128) go

insert into authors

values!472-27-2349, Gringlesby, Burt,

707 938-6445, PO Box 792, Covelo, CA, 95428)

insert into authors

values!527-72-3246, Greene, Morningstar,

615 297-2723, 22 Graybar House Rd., Nashville, TN, 37215) go

insert into authors

values!172-32-1176, White, Johnson,

408 496-7223, 10932 Bigge Rd., Menlo Park, CA, 94025) go

insert into authors

values!712-45-1867, del Castillo, Innes,

615 996-8275, 2286 Cram Pi. #86, Ann Arbor, MI, 48105)

insert into authors

values!846-92-7186, Hunter, Sheryl,

415 836-7128, 3410 Blonde St., Palo Alto, CA, 94301) go

insert into authors

values!486-29-1786, Locksley, Chastity,

415 585-4620, 18 Broadway Av., San Francisco, CA, 94130) go

insert into authors

values!648-92-1872, Blotchet-Halls, Reginald,

503 745-6402, 55 Hillsdale Bl., Corvallis, OR, 97330)

insert into authors

values!341-22-1782, Smith, Meander,

913 843-0462, 10 Misisipi Dr., Lawrence, KS, 66044)

insert into publishers

values!0736, New Age Books, 1 1st St,Boston, MA)

insert into publishers

values{0877, Binnet & Hardley,2 2nd Ave., Washington, DC) go

insert into publishers

values (1389, Algodata Infosystems, 3 3rd Dr.,Berlceley, CA) go

insert into roysched values(BU1032, 0, 5000, .10) go

insert into roysched values(BUl032, 5001, 50000, .12) go

insert into roysched values(PC1035, 0, 2000, .10) go

insert into roysched values(PC1035, 2001, 4000, .12) go

insert into roysched values(PC1035, 4001, 50000, .16) go

insert into roysched values(BU2075, 0, 1000, .10) go

insert into roysched values(BU2075, 1001, 5000, .12) go

insert into roysched values(BU2075, 5001, 7000, .16) go

insert into roysched values(BU2075, 7001, 50000, .18) go

insert into roysched values{PS9999, 0, 50000, .10) go

insert into roysched values(PS2091, 0, 1000, .10) go

insert into roysched values{PS2091, 1001, 5000, .12) go

insert into roysched values(PS209r, 5001, 50000, .14) go

insert into roysched values(PS2106, 0, 2000, .10) go

insert into roysched values(PS2106, 2001, 5000, .12) go

insert into roysched