drop table authors;

create table authors (
	author char(30) primary key,
	born date,
	died date,
	nationality char(30)
);

start transaction;

insert into authors values ('Paul DuBois','1950-07-18','1993-11-10','french');
insert into authors values ('David Hunter','1970-07-02',null,'british');
insert into authors values ('Paul Deitel','1984-01-23',null,'american');
insert into authors values ('Bruce Eckel','1977-06-08','2016-07-16','american');
insert into authors values ('Ken Arnold','1981-05-13',null,'american');
insert into authors values ('Randal Schwartz','1980-04-22',null,'german');
insert into authors values ('Larry Wall','1980-10-07',null,'american');
insert into authors values ('Joseph Hall','1963-08-18','2001-02-13','british');
insert into authors values ('Kevin Dick','1952-09-10',null,'british');
insert into authors values ('Josh Peck','1968-11-23',null,'american');
insert into authors values ('Mark Grand','1963-09-25',null,'french');
insert into authors values ('Dean Wampler','1967-02-20','1999-01-16','american');
insert into authors values ('Johan Vromans','1950-05-11','1995-06-26','dutch');
insert into authors values ('Michael Brundage','1985-05-02',null,'canadian');
insert into authors values ('Arthur Goldman','1966-02-03',null,'german');

commit;

