### Database Schema:
CREATE TABLE PaperAuthor (
	PaperId	INTEGER	NULL,
	AuthorId	INTEGER	NULL,
	Name	TEXT	NULL,
	Affiliation	TEXT	NULL,
	foreign key (AuthorId) references Author (Id),
	foreign key (PaperId) references Paper (Id)
);

CREATE TABLE Author (
	Id	INTEGER	NULL	PRIMARY KEY,
	Name	TEXT	NULL,
	Affiliation	TEXT	NULL
);

CREATE TABLE Paper (
	Id	INTEGER	NULL	PRIMARY KEY,
	Title	TEXT	NULL,
	Year	INTEGER	NULL,
	ConferenceId	INTEGER	NULL,
	JournalId	INTEGER	NULL,
	Keyword	TEXT	NULL,
	foreign key (JournalId) references Journal (Id),
	foreign key (ConferenceId) references Conference (Id)
);

CREATE TABLE Journal (
	Id	INTEGER	NULL	PRIMARY KEY,
	ShortName	TEXT	NULL,
	FullName	TEXT	NULL,
	HomePage	TEXT	NULL
);

CREATE TABLE Conference (
	Id	INTEGER	NULL	PRIMARY KEY,
	ShortName	TEXT	NULL,
	FullName	TEXT	NULL,
	HomePage	TEXT	NULL
);

### User's Query:
Calculate the total average number of papers published from 2002 to 2010 under the conference "Information and Knowledge Engineering".

### Extra Knowledge:
average number of papers refers to DIVIDE(count(id), 9); published from 2002 to 2010 refers to Year BETWEEN 2002 AND 2010; 'Information and Knowledge Engineering' is the FullName of conference;
SELECT CAST(COUNT(T1.Id) AS REAL) / COUNT(DISTINCT T1.Year) FROM Paper AS T1 INNER JOIN Conference AS T2 ON T1.ConferenceId = T2.Id WHERE T2.FullName = 'Information and Knowledge Engineering' AND T1.Year >= 2002 AND T1.Year <= 2010