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') ;