insert into b_tutorial
values ('aaaa1','mon','11','N101','Smith');
insert into b_tutorial
values ('bbbb2','mon','12','N103','Jones');
insert into b_tutorial
values('cccc3','tue','1','N103','Jimbo');

insert into b_assessmentitem
values ('exam','20-NOV-2002',100,50);
insert into b_assessmentitem
values ('a1','10-AUG-2002',60,10);
insert into b_assessmentitem
values('a2','10-SEP-2002',80,18);
insert into b_assessmentitem
values('a3','10-OCT-2002',70,20);
insert into b_assessmentitem
values('wk2','10-JUN-2002',5,1);
insert into b_assessmentitem
values('wk4','20-JUN-2002',5,1);
insert into b_assessmentitem
values('wk6','30-JUN-2002',5,1);

insert into b_a3student(studentid,surname,firstname,username,tutid)
values (2010999, 'Jobsworth','Bill','u0000000','aaaa1');
insert into b_a3student(studentid,surname,firstname,username,tutid)
values (2010123, 'Linux-Guy','Crazy', 'u3950692', 'aaaa1');
insert into b_a3student(studentid,surname,firstname,username,tutid)
values (2222222, 'Persion','Bill','u2222222','bbbb2');
insert into b_a3student(studentid,surname,firstname,username,tutid)
values (3333333, 'Ringwood','Becky','u3333333','bbbb2');
insert into b_a3student(studentid,surname,firstname,username,tutid)
values (4444444, 'Lister','Dave','u4444444','aaaa1');
insert into b_a3student(studentid,surname,firstname,username,tutid)
values (5555555, 'Schlapper-Eccles','Herr Von','u555555','cccc3');
insert into b_a3student(studentid,surname,firstname,username,tutid)
values (6666666, 'Seagoon','Neddie','u6666666','cccc3');
--items for 2010999

insert into b_mark 
values (2010999, 'a1', 40, '9-AUG-2002');
insert into b_mark 
values (2010999, 'a2', 70, '9-SEP-2002');
insert into b_mark
values (2010999, 'a3', 60, '10-OCT-2002');
insert into b_mark 
values (2010999, 'wk2', 3, '10-JUN-2002');
insert into b_mark 
values (2010999, 'wk4', 5, '20-JUN-2002');
insert into b_mark 
values (2010999, 'wk6', 4, '30-JUN-2002');
insert into b_mark 
values(2010999, 'exam', 90, '20-NOV-2002');
--items for 2010123
insert into b_mark 
values (2010123, 'a1', 50, '9-AUG-2002');
insert into b_mark 
values (2010123, 'a2', 69, '9-SEP-2002');
insert into b_mark 
values (2010123, 'a3', 65, '10-OCT-2002');
insert into b_mark 
values (2010123, 'wk2', 4, '10-JUN-2002');
insert into b_mark 
values (2010123, 'wk4', 5, '20-JUN-2002');
insert into b_mark 
values (2010123, 'wk6', 3, '30-JUN-2002');
insert into b_mark
values (2010123, 'exam', 88, '20-NOV-2002');
--items for 2222222
insert into b_mark 
values (2222222, 'a1', 52, '9-AUG-2002');
insert into b_mark 
values (2222222, 'a2', 65, '9-SEP-2002');
insert into b_mark 
values (2222222, 'a3', 63, '10-OCT-2002');
insert into b_mark 
values (2222222, 'wk2', 3, '10-JUN-2002');
insert into b_mark 
values (2222222, 'wk4', 5, '20-JUN-2002');
insert into b_mark 
values (2222222, 'wk6', 5, '30-JUN-2002');
insert into b_mark
values (2222222, 'exam', 87, '20-NOV-2002');
--items for 3333333
insert into b_mark 
values (3333333, 'a1', 52, '9-AUG-2002');
insert into b_mark 
values (3333333, 'a2', 61, '9-SEP-2002');
insert into b_mark 
values (3333333, 'a3', 62, '10-OCT-2002');
insert into b_mark 
values (3333333, 'wk2', 4, '10-JUN-2002');
insert into b_mark 
values (3333333, 'wk4', 5, '20-JUN-2002');
insert into b_mark 
values (3333333, 'wk6', 3, '30-JUN-2002');
insert into b_mark
values (3333333, 'exam', 87, '20-NOV-2002');
--items for 4444444
insert into b_mark 
values (4444444, 'a1', 49, '9-AUG-2002');
insert into b_mark 
values (4444444, 'a2', 61, '9-SEP-2002');
insert into b_mark 
values (4444444, 'a3', 62, '10-OCT-2002');
insert into b_mark 
values (4444444, 'wk2', 3, '10-JUN-2002');
insert into b_mark 
values (4444444, 'wk4', 5, '20-JUN-2002');
insert into b_mark 
values (4444444, 'wk6', 3, '30-JUN-2002');
insert into b_mark
values (4444444, 'exam', 87, '20-NOV-2002');
--items for 5555555
insert into b_mark 
values (5555555, 'a1', 57, '9-AUG-2002');
insert into b_mark 
values (5555555, 'a2', 65, '9-SEP-2002');
insert into b_mark 
values (5555555, 'a3', 65, '10-OCT-2002');
insert into b_mark 
values (5555555, 'wk2', 3, '10-JUN-2002');
insert into b_mark 
values (5555555, 'wk4', 3, '20-JUN-2002');
insert into b_mark 
values (5555555, 'wk6', 5, '30-JUN-2002');
insert into b_mark
values (5555555, 'exam', 84, '20-NOV-2002');
--items for 6666666
insert into b_mark 
values (6666666, 'a1', 59, '9-AUG-2002');
insert into b_mark 
values (6666666, 'a2', 61, '9-SEP-2002');
insert into b_mark 
values (6666666, 'a3', 63, '10-OCT-2002');
insert into b_mark 
values (6666666, 'wk2', 3, '10-JUN-2002');
insert into b_mark 
values (6666666, 'wk4', 1, '20-JUN-2002');
insert into b_mark 
values (6666666, 'wk6', 5, '30-JUN-2002');
insert into b_mark
values (6666666, 'exam', 83, '20-NOV-2002');