CREATE TABLE Authors (Author_Id CHAR(4), Name CHAR(25), URL CHAR(80))
INSERT INTO Authors VALUES ('ARON', 'Aronson, Larry', 'www.interport.net/~laronson/Homepage.html')
INSERT INTO Authors VALUES ('ARPA', 'Arpajian, Scott', '')
INSERT INTO Authors VALUES ('BEBA', 'Bebak, Arthur', 'db.www.idgbooks.com/database/book/isbn/about-author.tmpl?query=1-56884-645-2')
INSERT INTO Authors VALUES ('BRAN', 'Brandon, Bill', '')
INSERT INTO Authors VALUES ('BROW', 'Brown, Mark', '')
INSERT INTO Authors VALUES ('CAST', 'Castro, Elizabeth', 'www.peachpit.com/peachpit/meetus/authors/elizabeth.castro.html')
INSERT INTO Authors VALUES ('CEAR', 'Cearly, Kent', '')
INSERT INTO Authors VALUES ('CHIN', 'Chin, Francis', '')
INSERT INTO Authors VALUES ('CHU1', 'Chu, Kenny', '')
INSERT INTO Authors VALUES ('DOWN', 'Downing, Troy', 'found.cs.nyu.edu/downing/index.html')
INSERT INTO Authors VALUES ('DUNT', 'Duntemann, Jeff', '')
INSERT INTO Authors VALUES ('EWRI', 'Erwin, Mike', '')
INSERT INTO Authors VALUES ('EVAN', 'Evans, Tim', '')
INSERT INTO Authors VALUES ('FOUS', 'Foust, Jeff', '')
INSERT INTO Authors VALUES ('FOX1', 'Fox, David', 'found.cs.nyu.edu/dfox/index.html')
INSERT INTO Authors VALUES ('GAIT', 'Gaither, Mark', '')
INSERT INTO Authors VALUES ('GRAH', 'Graham, Ian', 'www.utirc.utoronto.ca/personnel/i_graham.html')
INSERT INTO Authors VALUES ('GROV', 'Groves, Dawn', 'www.skycat.com/~dawng/dawn.html')
INSERT INTO Authors VALUES ('HARR', 'Harris, Stuart', 'www.esnet.com/~sirrah/www/')
INSERT INTO Authors VALUES ('HASS', 'Hassinger, Sebastian', '')
INSERT INTO Authors VALUES ('JAME', 'James, Steve', 'www.lanw.com/sjbio.htm')
INSERT INTO Authors VALUES ('JUNG', 'Jung, John', '')
INSERT INTO Authors VALUES ('KARP', 'Karpinski, Richard', '')
INSERT INTO Authors VALUES ('KENN', 'Kennedy, Bill', 'www.ora.com/www/item/html.author.html')
INSERT INTO Authors VALUES ('KERV', 'Kerven, David', '')
INSERT INTO Authors VALUES ('KIDD', 'Kidder, Gayle', 'w3.thegroup.net/~zoom/author.html')
INSERT INTO Authors VALUES ('KNAU', 'Knauss, Greg', '')
INSERT INTO Authors VALUES ('KRCM', 'Krcma, Marianne', '')
INSERT INTO Authors VALUES ('LEJE', 'LeJeune, Urban', 'www.charm.net/~lejeune/')
INSERT INTO Authors VALUES ('LEMA', 'Lemay, Laura', 'slack.lne.com/lemay/index.html')
INSERT INTO Authors VALUES ('MEGA', 'Megan, Robert', '')
INSERT INTO Authors VALUES ('MOR1', 'Morris, Bruce', '')
INSERT INTO Authors VALUES ('MOR2', 'Morris, Mary', '')
INSERT INTO Authors VALUES ('MUL1', 'Mullen, Robert', '')
INSERT INTO Authors VALUES ('MUL2', 'Muller, Nathan', 'www.ddx.com/authtoc.html')
INSERT INTO Authors VALUES ('MUSC', 'Musciano, Chuck', 'www.ora.com/www/item/html.author.html')
INSERT INTO Authors VALUES ('NEOU', 'Neou, Vivian', '')
INSERT INTO Authors VALUES ('PARK', 'Parker, Elisabeth', '')
INSERT INTO Authors VALUES ('POWE', 'Powell, James', 'scholar.lib.vt.edu/jpowell/')
INSERT INTO Authors VALUES ('RAND', 'Randall, Neil', 'randall.uwaterloo.ca/')
INSERT INTO Authors VALUES ('RAY1', 'Ray, Deborah', 'db.www.idgbooks.com/database/book/isbn/about-author.tmpl?query=1-56884-990-7')
INSERT INTO Authors VALUES ('RAY2', 'Ray, Eric', 'db.www.idgbooks.com/database/book/isbn/about-author.tmpl?query=1-56884-990-7')
INSERT INTO Authors VALUES ('READ', 'Ready, Kevin', 'www.browserbydesign.com/book/main/about.htm')
INSERT INTO Authors VALUES ('RECK', 'Recker, Mimi', '')
INSERT INTO Authors VALUES ('SAVO', 'Savola, Tom', '')
INSERT INTO Authors VALUES ('SCHA', 'Scharf, Dean', '')
INSERT INTO Authors VALUES ('SCHE', 'Schengili, Keith', '')
INSERT INTO Authors VALUES ('SMIT', 'Smith, Bud', 'db.www.idgbooks.com/database/book/isbn/about-author.tmpl?query=1-56884-645-2')
INSERT INTO Authors VALUES ('SOSI', 'Sosinsky, Barrie', '')
INSERT INTO Authors VALUES ('STAU', 'Stauffer, Todd', '')
INSERT INTO Authors VALUES ('TAYL', 'Taylor, Dave', 'www.intuitive.com:80/taylor/')
INSERT INTO Authors VALUES ('TITT', 'Tittel, Ed', 'www.lanw.com/etbio.htm')
INSERT INTO Authors VALUES ('WARN', 'Warner, Janine', 'www.browserbydesign.com/book/main/about.htm')
INSERT INTO Authors VALUES ('ZAKO', 'Zakour, John', '')
SELECT * FROM Authors