INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Afrikaans');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Albanian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Arabic');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Armenian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Basque');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Bengali');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Bulgarian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Catalan');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Cambodian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Chinese');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Croatian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Czech');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Danish');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Dutch');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'English');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Estonian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Fiji');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Finnish');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'French');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Georgian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'German');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Greek');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Gujarati');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Hebrew');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Hindi');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Hungarian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Icelandic');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Indonesian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Irish');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Italian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Japanese');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Javanese');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Korean');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Latin');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Latvian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Lithuanian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Macedonian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Malay');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Malayalam');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Maltese');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Maori');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Marathi');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Mongolian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Nepali');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Norwegian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Persian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Polish');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Portuguese');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Punjabi');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Quechua');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Romanian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Russian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Samoan');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Serbian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Slovak');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Slovenian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Spanish');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Swahili');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Swedish');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Tamil');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Tatar');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Telugu');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Thai');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Tibetan');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Tonga');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Turkish');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Ukrainian');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Urdu');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Uzbek');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Vietnamese');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Welsh');

INSERT INTO NSCC_LANGUAGE
VALUES (Language_ID_Seq.nextval, 'Xhosa');



INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Academic and Career Connections', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Addictions Community Outreach', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Adult Learning Program', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'African Canadian Transition Program', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Aircraft Maintenance Engineer (Avionics)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Aircraft Maintenance Engineer (Mechanical)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Aircraft Maintenance Engineer (Structures)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'American Sign Language/English Interpretation', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Applied Media and Communication Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Architectural Engineering Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Automotive Collision Repair and Refinishing', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Automotive Service and Repair', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Automotive Service Advisor', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Baking and Pastry Art', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Behavioural Interventions', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Boulanger and Baking Art', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Bricklaying Masonry', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Building Systems Technician (HVACandR)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Business Administration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Business Administration - Accounting Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Business Administration - Financial Services Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Business Administration - Investment Management Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Business Administration - Management Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Business Administration - Marketing Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Business Administration - Software and Information Management Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Cabinetmaking', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'CAD Technician - Mechanical', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Carpentry', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Civil Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Community Disability Supports', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Computer Electronics Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Construction Management Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Continuing Care', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Cooking', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Cosmetology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Culinary Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Deaf Studies', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Dental Assisting - Level II', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Diesel Repair – Industrial and Marine', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Digital Animation', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Drafting – Architectural', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Early Childhood Education', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Electrical - Construction and Industrial - Diploma', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Electrical - Construction and Industrial - Certificate', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Electrical Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Electro Mechanical Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Electronic Engineering Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Electronic Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Energy Sustainability Engineering Technology (ESET)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'English for Academic Purposes (EAP)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Environmental Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Esthetics', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Funeral and Allied Health Services', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Funeral Arranging and Directing', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Gas Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geographic Sciences', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geographic Sciences - Cartography Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geographic Sciences - Community and Environmental Planning Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geographic Sciences - Geographic Information Systems (GIS) Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geographic Sciences - Remote Sensing Technology Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geographic Sciences – Advanced Diploma', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geographic Sciences – Advanced Diploma - Geographic Information Systems (GIS) Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geographic Sciences – Advanced Diploma - GIS for Business Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geographic Sciences – Advanced Diploma - Remote Sensing Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Geomatics Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Graphic and Print Production', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Graphic Design', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Health Information Management (HIM)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Heavy Duty Equipment /Truck and Transport Repair – Certificate', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Heavy Duty Equipment /Truck and Transport Repair – Diploma', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Heavy Equipment Operator', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Heritage Carpentry', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Horticulture and Landscape Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Horticulture and Landscape Technology - Landscape Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Horticulture and Landscape Technology - Operations Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Resource Management', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Services', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Services - Child and Youth Care Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Services - Community Services Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Services - Correctional Services Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Services - Disability Supports and Services Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Services - Educational Support Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Services - Non-profit Leadership Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Services - Open Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Human Services - Therapeutic Recreation Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Industrial Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Industrial Instrumentation', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Industrial Mechanical', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Information Technology (IT)', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Information Technology (IT) - Database Management Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Information Technology (IT) - Programming Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Information Technology (IT) - Systems Management/Networking Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Information Technology (IT) - Web Development Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Interactive and Motion Graphics', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Interactive and Motion Graphics - 3D Modeling and Motion Capture Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Interactive and Motion Graphics - Flash Interactive Media Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Interactive and Motion Graphics - Game Design Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Interactive and Motion Graphics - Visual Effects Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'International Business', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Law and Security', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Library and Information Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Machining', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Marine - Industrial Rigging', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Marine Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Marine Geomatics', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Marine Navigation Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Mechanical Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Medical Laboratory Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Medical Office Administration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Medical Transcription', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Mental Health Recovery and Promotion', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Metal Fabrication', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Mi''kmaw Health and Wellness', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Motorcycle and Power Products Repair', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Music Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Music Business', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Natural Resources Environmental Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Occupational Health and Safety', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Occupational Therapy and Physiotherapy Assistant', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Office Administration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Office Administration - Software and Information Management', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Oil Heat Systems Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Paralegal Services', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Pharmacy Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Photography', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Pipe Trades', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Plumbing', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Power Engineering Technology', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Practical Nursing', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Process Operations – 4th Class Power Engineering', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Public Relations', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Radio and Television Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Radio and Television Arts - Broadcast Journalism Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Radio and Television Arts - Radio Performance and Studio Production Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Radio and Television Arts - Television Production Concentration', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Recording Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Recreation Leadership', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Refrigeration and Air Conditioning', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Refrigeration and Air Conditioning - Geothermal', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Screen Arts', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Steamfitting/Pipefitting', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Survey Technician', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Tourism Management', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Utility Line Work-Construction and Maintenance', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Welding', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Welding – Certified', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Welding Inspection and Quality Control', 1);

INSERT INTO NSCC_PROGRAM
VALUES (Program_ID_Seq.nextval, 'Wood Products Manufacturing Technology', 1);





INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 1, 6);

INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 1, 2);

INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/05/10 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 0, 8);

INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/05/09 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 1, 1);

INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 1, 4);

INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/06/01 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 1, 3);

INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 1, 5);

INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/06/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 1, 7);

INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 1, 9);

INSERT INTO NSCC_APPLICATION
values (Application_ID_Seq.nextval, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25, 1, 10);






INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Akerley Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Annapolis Valley Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Burridge Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Cumberland Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Institute of Technology Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Kingstec Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Lunenburg Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Marconi Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Pictou Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Shelburne Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Strait Area Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Truro Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Waterfront Campus');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Aviation Institute');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Centre of Geographic Sciences (COGS)');

INSERT INTO NSCC_CAMPUS
VALUES (Campus_ID_Seq.nextval, 'Nautical Institute and School of Fisheries');





INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,3,4,5);
INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,4,5,6);
INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,5,6,7);
INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,6,7,8);
INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,7,8,9);
INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,8,9,10);
INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,9,10,1);
INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,10,1,2);
INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,1,2,3);
INSERT INTO NSCC_Program_Choice values (1,Program_Choice_ID_Seq.nextval,2,3,4);
INSERT INTO NSCC_Program_Choice values (2,Program_Choice_ID_Seq.nextval,3,5,5);
INSERT INTO NSCC_Program_Choice values (2,Program_Choice_ID_Seq.nextval,4,14,6);




--Payment_ID, Application_ID, Payment date, amount
INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 4, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);

INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 6, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);

INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 5, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);

INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 2, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);

INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 10, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);

INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 8, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);

INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 7, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);

INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 3, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);

INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 1, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);

INSERT INTO NSCC_PAYMENT
VALUES (Payment_ID_Seq.nextval, 9, TO_DATE('2003/05/06 21:02:44', 'yyyy/mm/dd hh24:mi:ss'), 25);