Mangai Neelavannan

Craft 3 insert statements to populate data

Sqlfiddle link: http://sqlfiddle.com/#!9/9b025b

  • May 20, 2018 at 5:57 PM
  • Visible to public
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')
;