INSERT INTO COURSE
( COURSE_ID, COURSE_NAME )
VALUES
( 1, 'Computing ( Software Engineering )' );


INSERT INTO MODULE
( MODULE_ID, MODULE_NAME )
VALUES
( 1, 'Case Studies In Software Design' );
INSERT INTO MODULE
( MODULE_ID, MODULE_NAME )
VALUES
( 2, 'Formal Software Development' );
INSERT INTO MODULE
( MODULE_ID, MODULE_NAME )
VALUES
( 3, 'Management Of IT Projects' );
INSERT INTO MODULE
( MODULE_ID, MODULE_NAME )
VALUES
( 4, 'Network And System Security' );
INSERT INTO MODULE
( MODULE_ID, MODULE_NAME )
VALUES
( 5, 'Professional Studies' );
INSERT INTO MODULE
( MODULE_ID, MODULE_NAME )
VALUES
( 6, 'Business Modelling For Internet Based Technology' );
INSERT INTO MODULE
( MODULE_ID, MODULE_NAME )
VALUES
( 7, 'Intelligent Systems' );
INSERT INTO MODULE
( MODULE_ID, MODULE_NAME )
VALUES
( 8, 'Advanced Databases' );


INSERT INTO STUDENT
( STUDENT_ID, FIRST_NAME, LAST_NAME, USERNAME, PASSWORD, EMAIL_ADDRESS, MOBILE_NUMBER, TUTOR_GROUP, COURSE_YEAR, COURSE_ID )
VALUES
( 1, 'Karl', 'Moore', 'kdmoore', 'password', 'karl.d.moore@student.shu.ac.uk', '447879400124', 'S', 4, 1 );
INSERT INTO STUDENT
( STUDENT_ID, FIRST_NAME, LAST_NAME, USERNAME, PASSWORD, EMAIL_ADDRESS, MOBILE_NUMBER, TUTOR_GROUP, COURSE_YEAR, COURSE_ID )
VALUES
( 2, 'Karl', 'Austin', 'kpaustin', 'password', 'k.p.austin@student.shu.ac.uk', '', 'S', 4, 1 );
INSERT INTO STUDENT
( STUDENT_ID, FIRST_NAME, LAST_NAME, USERNAME, PASSWORD, EMAIL_ADDRESS, MOBILE_NUMBER, TUTOR_GROUP, COURSE_YEAR, COURSE_ID )
VALUES
( 3, 'Robert', 'Sawyer', 'rpsawyer', 'password', 'r.p.sawyer@student.shu.ac.uk', '', 'S', 4, 1 );
INSERT INTO STUDENT
( STUDENT_ID, FIRST_NAME, LAST_NAME, USERNAME, PASSWORD, EMAIL_ADDRESS, MOBILE_NUMBER, TUTOR_GROUP, COURSE_YEAR, COURSE_ID )
VALUES
( 4, 'Emmanuel', 'Onafowokan', 'password', 'eonafowokan', 'e.onafowokan@student.shu.ac.uk', '', 'S', 4, 1 );


INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 1, 'Ian', 'Morrey', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 2, 'Mehmet', 'Ozcan', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 3, 'Paul', 'Parry', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 4, 'Mike', 'Gibson', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 5, 'Richard', 'Hill', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 6, 'Paul', 'Crowther', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 7, 'Susan', 'Curtis', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 8, 'Peter', 'Lake', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 9, 'Babak', 'Akhgar', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 10, 'Almerindo', 'Graziano', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 11, 'Andrew', 'Heath', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 12, 'Chris', 'Bates', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 13, 'Pete', 'Collingwood', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 14, 'Andrew', 'Dearden', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 15, 'Jawad', 'Siddiqi', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 16, 'Dave', 'Parsons', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 17, 'Frances', 'Slack', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 18, 'Stephen', 'Broadbridge', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 19, 'Carl', 'Davies', '', '' );
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 20, 'Henry', 'Nyongesa', '', '' ); 
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 21, 'Marcos', 'Rodrigues', '', '' ); 
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 22, 'Samir', 'Al Khayatt', '', '' ); 
INSERT INTO TUTOR
( TUTOR_ID, FIRST_NAME, LAST_NAME, USERNAME, EMAIL_ADDRESS )
VALUES
( 23, 'Andy', 'Bisset', '', '' );


INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 1, 14, 'Security System UML Part 1', '12-10-2002' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 2, 13, 'Security System Implementation Part 2', '12-12-2002' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 3, 13, 'Distributed Objects', '12-02-2003' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 4, 14, 'Swing', '28-03-2003' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 10, 1, 'Catalogue Part 1', '28-01-2003' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 20, 3, 'Easy Buys Poster Presentation', '08-12-2002' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 30, 10, 'Scribe Notes', '28-03-2003' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 31, 10, 'Mini Project', '28-02-2003' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 40, 17, 'Professional Issues Report', '12-10-2002' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 41, 17, 'Final Year Project', '11-04-2003' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 50, 5, 'Assignment 1', '12-02-2003' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 60, 21, 'Assignment 1', '15-03-2003' );
INSERT INTO ASSIGNMENT 
( ASSIGNMENT_ID, MARKED_BY, ASSIGNMENT_NAME, DEADLINE )
VALUES
( 70, 6, 'Assignment 1', '04-04-2003' );


INSERT INTO COURSE_MODULE
( MODULE_ID, COURSE_ID, COURSE_YEAR )
VALUES
( 1, 1, 4 );
INSERT INTO COURSE_MODULE
( MODULE_ID, COURSE_ID, COURSE_YEAR )
VALUES
( 2, 1, 4 );
INSERT INTO COURSE_MODULE
( MODULE_ID, COURSE_ID, COURSE_YEAR )
VALUES
( 3, 1, 4 );
INSERT INTO COURSE_MODULE
( MODULE_ID, COURSE_ID, COURSE_YEAR )
VALUES
( 4, 1, 4 );
INSERT INTO COURSE_MODULE
( MODULE_ID, COURSE_ID, COURSE_YEAR )
VALUES
( 5, 1, 4 );
INSERT INTO COURSE_MODULE
( MODULE_ID, COURSE_ID, COURSE_YEAR )
VALUES
( 6, 1, 4 );
INSERT INTO COURSE_MODULE
( MODULE_ID, COURSE_ID, COURSE_YEAR )
VALUES
( 7, 1, 4 );
INSERT INTO COURSE_MODULE
( MODULE_ID, COURSE_ID, COURSE_YEAR )
VALUES
( 8, 1, 4 );


INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 1, 1 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 1, 2 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 1, 3 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 1, 4 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 2, 10 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 3, 20 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 4, 30 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 4, 31 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 5, 40 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 5, 41 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 6, 50 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 7, 60 );
INSERT INTO MODULE_ASSIGNMENT
( MODULE_ID, ASSIGNMENT_ID )
VALUES
( 8, 70 );


INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 1, 12 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 1, 13 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 1, 14 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 1, 15 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 2, 1 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 2, 2 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 3, 3 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 3, 23 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 4, 10 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 4, 11 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 4, 22 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 5, 16 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 5, 17 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 6, 4 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 6, 5 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 6, 9 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 7, 20 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 7, 21 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 8, 6 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 8, 7 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 8, 8 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 8, 18 );
INSERT INTO MODULE_TUTOR
( MODULE_ID, TUTOR_ID )
VALUES
( 8, 19 );