-- AV Peterson  18-07-1999
-- Change Unit to Course  22-07-2002

-- Enrolment( StudentId, CourseCode, Mark, Grade )

CREATE TABLE Enrolment
(
  StudentId NUMBER(7),
  CourseCode VARCHAR(8),
  Year NUMBER(4),
  Mark NUMBER(3),
  Grade VARCHAR(6),
  CONSTRAINT Enrolment_pk PRIMARY KEY (StudentId, CourseCode, Year),
  CONSTRAINT Enrolment_Student_fk
    FOREIGN KEY (StudentId) REFERENCES Student(StudentId),
  CONSTRAINT Enrolment_Course_fk
    FOREIGN KEY (CourseCode) REFERENCES Course(CourseCode)
)
/

-- Copy data from comp2400.Enrolment

INSERT INTO Enrolment
  SELECT *
  FROM comp2400.Enrolment
/