public void convertToSQL() {
		
		sqlString = new ArrayList<String>();
		
		sqlString.add("START TRANSACTION;");
		
		for (Workplace w : workplaces){
			String workplace = 
					"INSERT INTO workplace (workplaceid, workplace_name)" +
							"VALUES (" 
							+ w.getWorkplaceid() + ", "
							+ "\"" + w.getWorkplaceName() + "\""	
							+");";
			sqlString.add(workplace);
			if (w.getWorkplaceType() == 0) {
				String ward = "INSERT INTO ward (workplaceid)"+"VALUES (" + w.getWorkplaceid() + ");";
				sqlString.add(ward);
			}
			else {
				String clinic = "INSERT INTO clinic (workplaceid)"+"VALUES (" + w.getWorkplaceid() + ");";
				sqlString.add(clinic);
			}
		}
		
		for (Specialization s : specList) {
			String spec = 
					"INSERT INTO specialization (specializationid, specialization_name)" +
							"VALUES ("
							+ s.getIndex() + ", "
							+ "\"" + s.getName() + "\""							
							+");";
			sqlString.add(spec);
		}

		int employeeIndex = 1;
		
		for (Person p : persons) {
			
			String employee = 
					"INSERT INTO employee (employeeid, first_name, last_name, telephone_number, date_of_employment)" +
							"VALUES (" 
							+ employeeIndex + ", "
							+ "\"" + p.getFirstName() + "\"" + ", " 
							+ "\"" + p.getLastName() + "\"" + ", " 
							+ "\"" + p.getPhone() + "\"" + ", "
							+ "\"" + p.getDOE() + "\""  							
							+");";

			sqlString.add(employee);
			
			String title = "";
			String doc_spec = "";
			String nurse_spec = "";
			
			if (p.getTitle() == 0) {
				title = "INSERT INTO doctor (employeeid) VALUES (" + employeeIndex + ");";
				sqlString.add(title);
				
				for (Specialization s : p.getSpecs()) {
					doc_spec = "INSERT INTO doctor_specialization(employeeid, specializationid) VALUES (" + employeeIndex + ", " + s.getIndex() + ");";					
				}
				sqlString.add(doc_spec);				
			}
			else if (p.getTitle() == 1) {
				title = "INSERT INTO nurse (employeeid) VALUES (" + employeeIndex + ");";
				sqlString.add(title);

				for (Specialization s : p.getSpecs()) {
					nurse_spec = "INSERT INTO nurse_specialization(employee_id, specialization_id) VALUES (" + employeeIndex + ", " + s.getIndex() + ");";
				}
				sqlString.add(nurse_spec);
			}
			else {
				title = "INSERT INTO assistant_nurse (employeeid) VALUES (" + employeeIndex + ");";
				sqlString.add(title);
			}
			
			String workplace = "INSERT INTO employee_workplace (employeeid, workplaceid) VALUES (" + employeeIndex + ", " + p.getWorkplace().getWorkplaceid()+");";
			sqlString.add(workplace);
			
			employeeIndex++;			
		}		
		sqlString.add("COMMIT;");		
	}