mysql> show tables; +------------------------+ | Tables_in_Catalog_Work | +------------------------+ | COLLEGEWIDE_REQ | | CORE_REQ | | COURSES | | DEGREES | | DEPARTMENTS | | DIVISIONS | | DOUBLEFLAGS | | GENERAL_REQ | | LEVELS | | MAJORS | | MAJOR_REQ | | MINORS | | MINOR_REQ | | SCHOOLS | | TRANSFER_REQ | | USERS | +------------------------+ mysql> describe SCHOOLS; +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | SchoolID | int(11) | | PRI | NULL | auto_increment | | SchoolName | varchar(100) | | | | | +------------+--------------+------+-----+---------+----------------+ INSERT INTO SCHOOLS (SchoolName) VALUES ('Arts and Sciences'); mysql> describe DIVISIONS; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | DivisionID | int(11) | | PRI | NULL | auto_increment | | DivisionName | varchar(100) | | | | | | SchoolID | int(11) | YES | | NULL | | +--------------+--------------+------+-----+---------+----------------+ INSERT INTO DIVISIONS (DivisionName, SchoolID) VALUES ('Natural Science and Mathematics', '1'); mysql> describe DEPARTMENTS; +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | DepartmentID | int(11) | | PRI | NULL | auto_increment | | DepartmentName | varchar(100) | | | | | | DivisionID | int(11) | YES | | NULL | | +----------------+--------------+------+-----+---------+----------------+ INSERT INTO DEPARTMENTS (DepartmentName, DivisionID) VALUES ('Computer Science', '1'); mysql> describe DEGREES; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | DegreeID | int(11) | | PRI | NULL | auto_increment | | DegreeName | varchar(100) | | | | | | DegreeCode | varchar(5) | | | | | | TotalCredits | int(11) | | | 0 | | | LiberalArts | int(11) | | | 0 | | +--------------+--------------+------+-----+---------+----------------+ INSERT INTO DEGREES (DegreeName, DegreeCode, TotalCredits, LiberalArts) VALUES ('Bachelor of Science', 'B.S.', '120', '60' ); mysql> describe DOUBLEFLAGS; +----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | DoubleFlagName | varchar(100) | | | | | +----------------+--------------+------+-----+---------+----------------+ INSERT INTO DOUBLEFLAGS (DoubleFlagName) VALUES ('Single Major'); mmysql> describe MAJORS; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | MajorID | int(11) | | PRI | NULL | auto_increment | | MajorName | varchar(100) | | | | | | MajorCode | char(3) | | | | | | DoubleFlagID | int(11) | | | 0 | | | DegreeID | int(11) | | | 0 | | +--------------+--------------+------+-----+---------+----------------+ INSERT INTO MAJORS (MajorName, MajorCode, DoubleFlagID, DegreeID) VALUES ('Computer Science', 'CSC', '1', '1' ); Notes: DoubleFlag - 1, default for single major, 2 for double major (e.g. Natural Science and Mathematics - there are a few of those on teh catalog) mysql> describe MAJOR_REQ; +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | Credits | int(11) | | | 0 | | | CourseList | varchar(255) | | | | | | MajorID | int(11) | YES | | NULL | | +------------+--------------+------+-----+---------+----------------+ INSERT INTO MAJOR_REQ (Credits, Courses, MajorID) VALUES ('4', '1', '1'); INSERT INTO MAJOR_REQ (Credits, Courses, MajorID) VALUES ('3', '6,12,17', '1'); Notes: - You need to take 3 credits from courseIDs 6,12,7 mysql> DESCRIBE LEVELS; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | LevelName | varchar(100) | | | | | +-----------+--------------+------+-----+---------+----------------+ INSERT INTO LEVELS (LevelName) VALUES ('Lower'); mysql> DESCRIBE COURSES; +-----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+----------------+ | CourseID | int(11) | | PRI | NULL | auto_increment | | CourseNumber | varchar(5) | | | | | | CourseNumberNew | varchar(5) | | | | | | CourseName | varchar(100) | | | | | | CourseLetter | varchar(5) | YES | | NULL | | | CourseCode | varchar(12) | | | | | | Credits | int(11) | | | 0 | | | LevelID | int(11) | | | 0 | | | CrossList | varchar(255) | YES | | NULL | | | PreReqList | varchar(255) | YES | | NULL | | | CoReqList | varchar(255) | YES | | NULL | | | PostReqList | varchar(255) | YES | | NULL | | | DepartmentID | int(11) | YES | | NULL | | | MajorID | int(11) | YES | | NULL | | +-----------------+--------------+------+-----+---------+----------------+ INSERT INTO COURSES (CourseNumber, CourseNumberNew, CourseName, CourseLetter, CourseCode, Credits, LevelID, DepartmentID, MajorID) VALUES ('012', '0', 'Introduction to Computer Science', 'N','CSC 012N', '4', '1', '1', '1'); Notes: - Level is 1 for Lower, 2 for Upper Issues: - We added CourseCode - the entire CSC 071N, which should help in processing mysql> describe MINORS; +------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+----------------+ | MinorID | int(11) | | PRI | NULL | auto_increment | | MinorName | varchar(100) | | | | | | MinorCode | char(3) | | | | | | NotAvailableList | varchar(100) | | | | | +------------------+--------------+------+-----+---------+----------------+ INSERT INTO MINORS (MinorName, MinorCode, NotAvailableList) VALUES ('Computer Science', 'CSC', '1,2'); Notes: - NotAvailableList is a coma delimited list of MajorIDs to which the minor is not available mysql> describe MINOR_REQ; +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | Credits | int(11) | | | 0 | | | CourseList | varchar(255) | | | | | | MinorID | int(11) | YES | | NULL | | +------------+--------------+------+-----+---------+----------------+ INSERT INTO MINOR_REQ (Credits, CourseList, MinorID) VALUES ('4', '1', '1'); mysql> describe COLLEGEWIDE_REQ; +-----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | CreditsRequired | int(11) | | | 0 | | | CourseList | varchar(255) | | | | | +-----------------+--------------+------+-----+---------+----------------+ INSERT INTO COLLEGEWIDE_REQ (CreditsRequired, CourseList) VALUES ('3', '55'); Notes: - You need to take 3 credits from courseIDs 55 mysql> describe TRANSFER_REQ; +-----------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | TransferCredits | int(11) | | | 0 | | | CoreRequired | int(11) | | | 0 | | +-----------------+---------+------+-----+---------+----------------+ INSERT INTO TRANSFER_REQ (TransferCredits, CoreRequired) VALUES ('10', '33'); mysql> describe CORE_REQ; +-----------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | CreditsRequired | int(11) | | | 0 | | | CourseList | varchar(255) | | | | | +-----------------+--------------+------+-----+---------+----------------+ INSERT INTO CORE_REQ (CreditsRequired, CourseList) VALUES ('3', '33'); UPDATE CORE_REQ SET CreditsRequired = 3 WHERE ID = 1; Notes: - I made an error so why not show you the update query as well :) mysql> describe GENERAL_REQ; +-------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+----------------+ | ID | int(11) | | PRI | NULL | auto_increment | | Description | varchar(255) | | | | | +-------------+--------------+------+-----+---------+----------------+ INSERT INTO GENERAL_REQ (Description) VALUES ('In order to graduate a student needs a GPA of 2.0 or higher.'); mysql> describe USERS; +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | UserID | int(11) | | PRI | NULL | auto_increment | | UserName | varchar(50) | | | | | | Password | varchar(50) | | | | | | Name | varchar(50) | | | | | +----------+-------------+------+-----+---------+----------------+ INSERT INTO USERS (UserName,Password,Name) VALUES ('george','test','George');