INSERT INTO PROGRAM_OF_STUDY
VALUES
(1, 'BS', 'Bachelor of Science'),
(2, 'AA', 'Associate in Arts Degree'),
(3, 'AAS', 'Associate in Applied Science Degree'),
(4, 'CTP', 'Career Training Programs'),
(5, 'PSAV', 'Post Secondary Adult Vocational'),
(6, 'ABE', 'Adult Basic Education')
;
INSERT INTO DISCIPLINE
VALUES
(1, 'S0170', 'Accounting', 120, 'CREDIT'),
(1, 'S0070', 'Biology', 120, 'CREDIT'),
(1, 'S0060', 'Nursing', 121, 'CREDIT'),
(1, 'S0120', 'Criminal Justice', 120, 'CREDIT'),
(2, '11190', 'English', 36, 'CREDIT'),
(3, '60010', 'Accounting Applications Certificate', 27, 'CREDIT'),
(2, '11200', 'Environmental Science', 36, 'CREDIT'),
(2, '11250', 'Humanities', 36, 'CREDIT'),
(4, '50700', 'Automotive Service Technology I', 1050, 'CLOCK'),
(4, '50060', 'Carpentry', 1200, 'CLOCK')
;
INSERT INTO STUDENT
VALUES
(2, 'S1', 'Jackie', 'Perez'),
(1, 'S2', 'Miguel', 'Williams'),
(1, 'S3', 'Page', 'Fletcher'),
(3, 'S4', 'Ryan', 'Fergusson'),
(2, 'S5', 'Martin', 'Walker'),
(2, 'S6', 'Thomas', 'Davis'),
(4, 'S7', 'Rose', 'Page'),
(4, 'S8', 'Anderson', 'White'),
(3, 'S9', 'Jonas', 'Hall'),
(2, 'S10', 'Mary', 'Hayes'),
(1, 'S11', 'Ann', 'Fletcher'),
(2, 'S12', 'Eliott', 'Carpenter'),
(1, 'S13', 'Arnold', 'Harvey')
;