PreparedStatement createMarksT = conn.prepareStatement(
	         "CREATE TABLE Marks("+
	         	"year							INTEGER, CHECK((year > 1800) AND (year < 2020)),"+
	         	"mark							INTEGER,"+
	         	"notes							CHAR(100),"+
	         	"typeID							INTEGER NOT NULL,"+
	         	"moduleID 						INTEGER NOT NULL,"+
	         	"studentID						INTEGER NOT NULL,"+
	            "FOREIGN KEY(moduleID) REFERENCES Module(moduleID),"+
	            "FOREIGN KEY(studentID) REFERENCES Student(studentID)"+
	         	");"
	         	);
	         createMarksT.execute();
	         System.out.println("Marks table created");

	         String addMarks="";
	         for(int b=1; b<101; b++) {
	        	 addMarks = addMarks+"INSERT INTO Marks VALUES (2014, " +
	        	 ((Integer)(1+randy.nextInt(100))).toString() +
	        	 ", " + "'Notes '," + ((Integer)(randy.nextInt(3))).toString() +
	        	 ", " + ((Integer)(1+randy.nextInt(100))).toString() +
	        	 ", " + ((Integer)(b)).toString() + ");";
	         }

	         PreparedStatement addMarksT = conn.prepareStatement(addMarks);
	         addMarksT.execute();

	         PreparedStatement alterMarksT = conn.prepareStatement(
	         "ALTER TABLE Marks ADD CONSTRAINT marks_Key UNIQUE (studentID, moduleID);");
	         alterMarksT.execute();