Reference no: EM13333146

create database DB2GAME;
connect to DB2GAME;

CREATE TABLE marks (
year integer not null,
course_code character(7) not null,
student_id character(7) not null,
midterm integer not null,
final integer not null,
unique (year, course_code, student_id));

COMMENT ON TABLE marks IS 'Contains the midterm and final marks of students in Computer Science and Engineering courses during the years 2004 - 2006';

LOAD FROM "C:\db2game\marks.csv" of del insert into marks (year, course_code, student_id, midterm, final);

CREATE TABLE log (
date date not null,
month character(5) not null,
week integer not null,
tutor_student_id character(7) not null,
hours dec(3,2) not null,
tutee_student_id character(7) not null,
unique (date, tutor_student_id, tutee_student_id));
COMMENT ON TABLE log IS 'Contains the information of each tutoring session';
LOAD FROM "C:\db2game\log.csv" of del insert into log (date, month, week, tutor_student_id, hours, tutee_student_id);

CREATE TABLE tutors (
student_id character(7) not null primary key,
given_name character(15) not null,
family_name character(15) not null,
course_code character(7) not null,
hourly_wage dec(4, 2) not null,
status character(10));
COMMENT ON TABLE tutors IS 'Contains the information of each tutor in the company';
LOAD FROM "C:\db2game\tutors.csv" of del insert into tutors (student_id, given_name, family_name, course_code, hourly_wage, status);