populate_courses.sql

-- Populate course table
INSERT INTO course VALUES (
    1, 'CSCI', 6221, 'SW Paradigms', 3,
    12121212, NULL, NULL
);

INSERT INTO course VALUES (
    2, 'CSCI', 6461, 'Computer Architecture', 3,
    10101010, NULL, NULL
);

INSERT INTO course VALUES (
    3, 'CSCI', 6212, 'Algorithms', 3,
    12121212, NULL, NULL
);

INSERT INTO course VALUES (
    4, 'CSCI', 6220, 'Machine Learning', 3,
    12121212, NULL, NULL
);

INSERT INTO course VALUES (
    5, 'CSCI', 6232, 'Networks 1', 3,
    12121212, NULL, NULL
);

INSERT INTO course VALUES (
    6, 'CSCI', 6233, 'Networks 2', 3,
    14141414, 5, NULL
);

INSERT INTO course VALUES (
    7, 'CSCI', 6241, 'Database 1', 3,
    10101010, NULL, NULL
);

INSERT INTO course VALUES (
    8, 'CSCI', 6242, 'Database 2', 3,
    14141414, 7, NULL
);

INSERT INTO course VALUES (
    9, 'CSCI', 6246, 'Compilers', 3,
    12121212, 2, 3
);

INSERT INTO course VALUES (
    10, 'CSCI', 6260, 'Multimedia', 3,
    12121212, NULL, NULL
);

INSERT INTO course VALUES (
    11, 'CSCI', 6251, 'Cloud Computing', 3,
    10101010, 2, NULL
);

INSERT INTO course VALUES (
    12, 'CSCI', 6254, 'SW Engineering', 3,
    12121212, 1, NULL
);

INSERT INTO course VALUES (
    13, 'CSCI', 6262, 'Graphics 1', 3,
    12121212, NULL, NULL
);

INSERT INTO course VALUES (
    14, 'CSCI', 6283, 'Security 1', 3,
    10101010, 3, NULL
);

INSERT INTO course VALUES (
    15, 'CSCI', 6284, 'Cryptography', 3,
    10101010, 3, NULL
);

INSERT INTO course VALUES (
    16, 'CSCI', 6286, 'Network Security', 3,
    12121212, 14, 5
);

INSERT INTO course VALUES (
    17, 'CSCI', 6325, 'Algorithms 2', 3,
    12121212, 3, NULL
);

INSERT INTO course VALUES (
    18, 'CSCI', 6339, 'Embedded Systems', 3,
    10101010, 2, 3
);

INSERT INTO course VALUES (
    19, 'CSCI', 6384, 'Cryptography 2', 3,
    12121212, 15, NULL
);

INSERT INTO course VALUES (
    20, 'ECE', 6241, 'Communication Theory', 3,
    12121212, NULL, NULL
);

INSERT INTO course VALUES (
    21, 'ECE', 6242, 'Information Theory', 2,
    10101010, NULL, NULL
);

INSERT INTO course VALUES (
    22, 'MATH', 6210, 'Logic', 2,
    10101010, NULL, NULL
);