DW ETL/Modeling Issue - SQL help needed

We’ve been tackling a tricky business problem that will be implemented
in SQL.

Students enroll in a particular degree program that requires a list of
classes.
We built a table the processes all the classes a student has taken and
all the classes the student needs to take to complete the degree
program, known as Curriculum Matrix.
Some classes have prerequisites (prereqs), in that the class might
require 1 or 2 prereqs. Sometimes there are optional prereqs.
Example: MATH205 requires MATH100 and (MATH105 OR MATH 110).
Example: ENGLISH200 requires ENGLISH 100

The challenge the business doesn’t want classes in the Curriculum
Matrix that the student hasn’t taken the prereqs.
We have three tables:
1. All the classes a student has taken and needs to take – aka
Curriculum Matrix
2. All the classes that have a prereq
3. All the classes that have the “optional” prereqs – See first
example
We’ve been trying to find a way to inner join these tables so that the
classes requiring prereqs are not included unless the student has the
prereqs.



** this data is from our data warehouse. I know that these are not
tables by definition since we haven’t set a primary key nor a
clustered index **
Thanks in Advance.
Rob

“Curriculum Matrix” DDL:
CREATE TABLE [dbo].[F_BI_STUDENT_CURRIC_MATRIX](
[STUDENT_ID] [char](10) NULL,
[SESSION_ID] [char](6) NULL,
[CLASS_ID] [char](6) NULL,
[NEED] [int] NULL,
[HAVE] [int] NULL
) ON [PRIMARY]


Prereqs:
CREATE TABLE [dbo].[D_BI_Class_prereq](
[UNIQUE_KEY] [varchar](24) NULL,
[CLASS_ID] [char](10) NULL,
[PREREQ_CLASS_ID] [char](10) NULL
) ON [PRIMARY]


“Optional Prereqs”:
CREATE TABLE [dbo].[D_BI_Class_Prereq_Optional](
[UNIQUE_KEY] [varchar](13) NULL,
[CLASS_ID] [char](10) NULL,
[PREREQ_OPTIONAL_CLASS_ID] [char](10) NULL
) ON [PRIMARY]

INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC206',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC206',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC206',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC206',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC206',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC206',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC216',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC216',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC216',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC303',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC303',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC303',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC303',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC303',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC303',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC304',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC304',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC304',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC304',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC304',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC304',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC305',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC305',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC305',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC305',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC307',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC307',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC307',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC307',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC307',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC307',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC317',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC317',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC317',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC317',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC317',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC317',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC350',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC350',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC350',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC350',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC350',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC350',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC401',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC401',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC401',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC401',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC401',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC401',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC403',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC403',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC403',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC403',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC403',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC403',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC410',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC410',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC410',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC410',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC410',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC410',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ACC499',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ACC499',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ACC499',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ACC499',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ACC499',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ACC499',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'BUS100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'BUS100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'BUS100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'BUS100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'BUS100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'BUS100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'CIS105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'CIS105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'CIS105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'CIS105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'CIS105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'CIS105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ECO405',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ECO405',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ECO405',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ECO405',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ECO405',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ECO405',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ENG115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ENG115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ENG115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ENG115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ENG115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ENG115',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ENG215',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ENG215',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ENG215',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ENG215',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ENG215',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ENG215',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'ENG240',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'ENG240',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'ENG240',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'ENG240',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'ENG240',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'ENG240',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'HUM100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'HUM100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'HUM100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'HUM100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'HUM100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'HUM100',0, 1)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'HUM101',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'HUM101',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'HUM101',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'HUM101',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'HUM101',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'HUM101',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'HUM200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'HUM200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'HUM200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'HUM200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'HUM200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'HUM200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'HUM300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'HUM300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'HUM300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'HUM300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'HUM300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'HUM300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'HUM400',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'HUM400',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'HUM400',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'HUM400',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'HUM400',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'HUM400',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'LEG100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'LEG100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'LEG100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'LEG100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'LEG100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'LEG100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'MAT105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'MAT105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'MAT105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'MAT105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'MAT105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'MAT105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'MAT200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'MAT200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'MAT200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'MAT200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'MAT200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'MAT200',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'MAT300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'MAT300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'MAT300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'MAT300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'MAT300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'MAT300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'MAT310',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'MAT310',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'MAT310',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'MAT310',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'MAT310',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'MAT310',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'POL300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'POL300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'POL300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'POL300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'POL300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'POL300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'PSY100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'PSY100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'PSY100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'PSY100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'PSY100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'PSY100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'PSY105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'PSY105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'PSY105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'PSY105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'PSY105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'PSY105',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'SOC100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'SOC100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'SOC100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'SOC100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'SOC100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'SOC100',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200802', N'SOC300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200803', N'SOC300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200804', N'SOC300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200805', N'SOC300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200902', N'SOC300',1, 0)
INSERT INTO F_BI_STUDENT_CURRIC_MATRIX VALUES (N'1295053919',
N'200903', N'SOC300',1, 0)

INSERT INTO D_BI_Class_prereq VALUES (N'ACC105*ACC100', N'ACC105',
N'ACC100')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC110*ACC100', N'ACC110',
N'ACC100')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC115*ACC100', N'ACC115',
N'ACC100')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC200*ACC105', N'ACC200',
N'ACC105')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC205*ACC200', N'ACC205',
N'ACC200')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC208*ACC110', N'ACC208',
N'ACC110')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC210*ACC205', N'ACC210',
N'ACC205')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC215*ACC100', N'ACC215',
N'ACC100')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC220*ACC105', N'ACC220',
N'ACC105')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC225*ACC110', N'ACC225',
N'ACC110')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC297*ACC298', N'ACC297',
N'ACC298')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC300*ACC110', N'ACC300',
N'ACC110')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC304*ACC303', N'ACC304',
N'ACC303')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC305*ACC205', N'ACC305',
N'ACC205')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC310*ACC210', N'ACC310',
N'ACC210')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC315*ACC310', N'ACC315',
N'ACC310')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC320*ACC303', N'ACC320',
N'ACC303')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC325*ACC225', N'ACC325',
N'ACC225')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC400*ACC310', N'ACC400',
N'ACC310')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC401*ACC304', N'ACC401',
N'ACC304')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC402*ACC401', N'ACC402',
N'ACC401')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC403*ACC304', N'ACC403',
N'ACC304')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC404*ACC303', N'ACC404',
N'ACC303')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC405*ACC403', N'ACC405',
N'ACC403')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC410*ACC304', N'ACC410',
N'ACC304')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC415*ACC305', N'ACC415',
N'ACC305')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC561*ACC560', N'ACC561',
N'ACC560')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC562*ACC403', N'ACC562',
N'ACC403')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC563*ACC303', N'ACC563',
N'ACC303')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC564*ACC403', N'ACC564',
N'ACC403')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC566*ACC304', N'ACC566',
N'ACC304')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC568*ACC565', N'ACC568',
N'ACC565')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC569*ACC560', N'ACC569',
N'ACC560')
INSERT INTO D_BI_Class_prereq VALUES (N'ACC570*ACC560', N'ACC570',
N'ACC560')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS112*BUS111', N'BUS112',
N'BUS111')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS205*BUS100', N'BUS205',
N'BUS100')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS213*BUS107', N'BUS213',
N'BUS107')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS250*BUS100', N'BUS250',
N'BUS100')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS290*BUS100', N'BUS290',
N'BUS100')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS310*BUS100', N'BUS310',
N'BUS100')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS325*BUS100', N'BUS325',
N'BUS100')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS335*BUS310', N'BUS335',
N'BUS310')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS405*BUS310', N'BUS405',
N'BUS310')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS407*BUS310', N'BUS407',
N'BUS310')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS409*BUS310', N'BUS409',
N'BUS310')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS505*BUS501', N'BUS505',
N'BUS501')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS511*BUS533', N'BUS511',
N'BUS533')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS518*BUS517', N'BUS518',
N'BUS517')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS519*BUS517', N'BUS519',
N'BUS517')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS522*BUS530', N'BUS522',
N'BUS530')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS527*BUS517', N'BUS527',
N'BUS517')
INSERT INTO D_BI_Class_prereq VALUES (N'BUS538*MAT540', N'BUS538',
N'MAT540')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS108*CIS105', N'CIS108',
N'CIS105')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS111*CIS105', N'CIS111',
N'CIS105')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS113*CIS111', N'CIS113',
N'CIS111')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS115*CIS110', N'CIS115',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS120*CIS115', N'CIS120',
N'CIS115')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS155*CIS110', N'CIS155',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS176*CIS175', N'CIS176',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS177*CIS175', N'CIS177',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS178*CIS176', N'CIS178',
N'CIS176')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS179*CIS175', N'CIS179',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS180*CIS175', N'CIS180',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS181*CIS175', N'CIS181',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS182*CIS175', N'CIS182',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS185*CIS175', N'CIS185',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS187*CIS175', N'CIS187',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS203*CIS175', N'CIS203',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS204*CIS203', N'CIS204',
N'CIS203')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS205*CIS204', N'CIS205',
N'CIS204')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS209*CIS110', N'CIS209',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS210*CIS111', N'CIS210',
N'CIS111')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS212*MAT105', N'CIS212',
N'MAT105')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS220*CIS110', N'CIS220',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS230*CIS105', N'CIS230',
N'CIS105')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS230*CIS107', N'CIS230',
N'CIS107')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS232*CIS178', N'CIS232',
N'CIS178')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS234*CIS232', N'CIS234',
N'CIS232')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS235*CIS110', N'CIS235',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS240*CIS110', N'CIS240',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS241*CIS240', N'CIS241',
N'CIS240')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS242*CIS110', N'CIS242',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS248*CIS110', N'CIS248',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS249*CIS248', N'CIS249',
N'CIS248')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS250*CIS110', N'CIS250',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS251*CIS250', N'CIS251',
N'CIS250')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS252*CIS234', N'CIS252',
N'CIS234')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS254*CIS252', N'CIS254',
N'CIS252')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS255*CIS255', N'CIS255',
N'CIS255')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS265*CIS242', N'CIS265',
N'CIS242')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS266*CIS265', N'CIS266',
N'CIS265')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS267*CIS111', N'CIS267',
N'CIS111')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS267*CIS242', N'CIS267',
N'CIS242')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS272*CIS181', N'CIS272',
N'CIS181')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS275*CIS110', N'CIS275',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS276*CIS111', N'CIS276',
N'CIS111')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS278*CIS272', N'CIS278',
N'CIS272')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS279*CIS181', N'CIS279',
N'CIS181')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS280*CIS181', N'CIS280',
N'CIS181')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS283*CIS282', N'CIS283',
N'CIS282')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS285*CIS280', N'CIS285',
N'CIS280')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS286*CIS279', N'CIS286',
N'CIS279')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS287*CIS282', N'CIS287',
N'CIS282')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS289*CIS282', N'CIS289',
N'CIS282')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS290*CIS285', N'CIS290',
N'CIS285')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS293*CIS175', N'CIS293',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS300*CIS285', N'CIS300',
N'CIS285')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS301*CIS276', N'CIS301',
N'CIS276')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS302*CIS282', N'CIS302',
N'CIS282')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS303*CIS285', N'CIS303',
N'CIS285')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS304*CIS175', N'CIS304',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS305*CIS276', N'CIS305',
N'CIS276')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS307*CIS110', N'CIS307',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS311*CIS270', N'CIS311',
N'CIS270')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS312*CIS155', N'CIS312',
N'CIS155')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS315*CIS175', N'CIS315',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS317*CIS284', N'CIS317',
N'CIS284')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS318*CIS282', N'CIS318',
N'CIS282')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS319*CIS187', N'CIS319',
N'CIS187')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS320*CIS110', N'CIS320',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS321*CIS155', N'CIS321',
N'CIS155')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS322*CIS305', N'CIS322',
N'CIS305')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS323*CIS305', N'CIS323',
N'CIS305')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS325*CIS265', N'CIS325',
N'CIS265')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS326*CIS242', N'CIS326',
N'CIS242')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS327*CIS325', N'CIS327',
N'CIS325')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS330*CIS270', N'CIS330',
N'CIS270')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS333*CIS175', N'CIS333',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS337*CIS175', N'CIS337',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS345*CIS111', N'CIS345',
N'CIS111')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS360*CIS305', N'CIS360',
N'CIS305')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS403*CIS204', N'CIS403',
N'CIS204')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS404*CIS205', N'CIS404',
N'CIS205')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS405*CIS345', N'CIS405',
N'CIS345')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS410*CIS312', N'CIS410',
N'CIS312')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS412*CIS110', N'CIS412',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS415*CIS111', N'CIS415',
N'CIS111')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS423*CIS326', N'CIS423',
N'CIS326')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS427*CIS323', N'CIS427',
N'CIS323')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS430*MAT300', N'CIS430',
N'MAT300')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS434*CIS276', N'CIS434',
N'CIS276')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS435*CIS427', N'CIS435',
N'CIS427')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS444*CIS434', N'CIS444',
N'CIS434')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS445*CIS325', N'CIS445',
N'CIS325')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS445*CIS435', N'CIS445',
N'CIS435')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS450*CIS175', N'CIS450',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS454*CIS444', N'CIS454',
N'CIS444')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS463*CIS305', N'CIS463',
N'CIS305')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS464*CIS444', N'CIS464',
N'CIS444')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS465*CIS305', N'CIS465',
N'CIS305')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS475*CIS415', N'CIS475',
N'CIS415')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS484*CIS305', N'CIS484',
N'CIS305')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS485*CIS110', N'CIS485',
N'CIS110')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS485*CIS465', N'CIS485',
N'CIS465')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS490*CIS415', N'CIS490',
N'CIS415')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS492*CIS325', N'CIS492',
N'CIS325')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS505*CIS175', N'CIS505',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS511*CIS500', N'CIS511',
N'CIS500')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS514*CIS175', N'CIS514',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS516*CIS175', N'CIS516',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS521*CIS500', N'CIS521',
N'CIS500')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS525*CIS500', N'CIS525',
N'CIS500')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS526*CIS500', N'CIS526',
N'CIS500')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS528*CIS500', N'CIS528',
N'CIS500')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS530*MAT300', N'CIS530',
N'MAT300')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS535*CIS530', N'CIS535',
N'CIS530')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS540*CIS500', N'CIS540',
N'CIS500')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS541*CIS270', N'CIS541',
N'CIS270')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS542*CIS270', N'CIS542',
N'CIS270')
INSERT INTO D_BI_Class_prereq VALUES (N'CIS545*CIS270', N'CIS545',
N'CIS270')
INSERT INTO D_BI_Class_prereq VALUES (N'CRJ105*CRJ100', N'CRJ105',
N'CRJ100')
INSERT INTO D_BI_Class_prereq VALUES (N'ECO205*ECO100', N'ECO205',
N'ECO100')
INSERT INTO D_BI_Class_prereq VALUES (N'ECO301*ECO101', N'ECO301',
N'ECO101')
INSERT INTO D_BI_Class_prereq VALUES (N'ECO305*ECO100', N'ECO305',
N'ECO100')
INSERT INTO D_BI_Class_prereq VALUES (N'ECO310*ECO102', N'ECO310',
N'ECO102')
INSERT INTO D_BI_Class_prereq VALUES (N'ECO410*ECO305', N'ECO410',
N'ECO305')
INSERT INTO D_BI_Class_prereq VALUES (N'ECO440*ECO100', N'ECO440',
N'ECO100')
INSERT INTO D_BI_Class_prereq VALUES (N'ECO470*ECO102', N'ECO470',
N'ECO102')
INSERT INTO D_BI_Class_prereq VALUES (N'ECO470*MAT300', N'ECO470',
N'MAT300')
INSERT INTO D_BI_Class_prereq VALUES (N'FIN100*ACC100', N'FIN100',
N'ACC100')
INSERT INTO D_BI_Class_prereq VALUES (N'FIN300*FIN100', N'FIN300',
N'FIN100')
INSERT INTO D_BI_Class_prereq VALUES (N'FIN320*FIN100', N'FIN320',
N'FIN100')
INSERT INTO D_BI_Class_prereq VALUES (N'FIN350*FIN100', N'FIN350',
N'FIN100')
INSERT INTO D_BI_Class_prereq VALUES (N'FIN410*FIN350', N'FIN410',
N'FIN350')
INSERT INTO D_BI_Class_prereq VALUES (N'FIN534*ACC560', N'FIN534',
N'ACC560')
INSERT INTO D_BI_Class_prereq VALUES (N'FIN560*FIN534', N'FIN560',
N'FIN534')
INSERT INTO D_BI_Class_prereq VALUES (N'FIN564*FIN534', N'FIN564',
N'FIN534')
INSERT INTO D_BI_Class_prereq VALUES (N'HSA510*ECO100', N'HSA510',
N'ECO100')
INSERT INTO D_BI_Class_prereq VALUES (N'HSA590*DRP999', N'HSA590',
N'DRP999')
INSERT INTO D_BI_Class_prereq VALUES (N'ITB300*BUS200', N'ITB300',
N'BUS200')
INSERT INTO D_BI_Class_prereq VALUES (N'ITB400*ECO100', N'ITB400',
N'ECO100')
INSERT INTO D_BI_Class_prereq VALUES (N'LAN112*LAN111', N'LAN112',
N'LAN111')
INSERT INTO D_BI_Class_prereq VALUES (N'LEG105*LEG100', N'LEG105',
N'LEG100')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT102*MAT101', N'MAT102',
N'MAT101')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT103*MAT100', N'MAT103',
N'MAT100')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT200*MAT105', N'MAT200',
N'MAT105')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT205*MAT200', N'MAT205',
N'MAT200')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT305*MAT300', N'MAT305',
N'MAT300')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT310*MAT200', N'MAT310',
N'MAT200')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT311*MAT310', N'MAT311',
N'MAT310')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT315*MAT310', N'MAT315',
N'MAT310')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT320*MAT315', N'MAT320',
N'MAT315')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT325*MAT315', N'MAT325',
N'MAT315')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT400*MAT300', N'MAT400',
N'MAT300')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT405*MAT400', N'MAT405',
N'MAT400')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT410*HUM200', N'MAT410',
N'HUM200')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT415*MAT410', N'MAT415',
N'MAT410')
INSERT INTO D_BI_Class_prereq VALUES (N'MAT540*MAT300', N'MAT540',
N'MAT300')
INSERT INTO D_BI_Class_prereq VALUES (N'MKT105*MKT100', N'MKT105',
N'MKT100')
INSERT INTO D_BI_Class_prereq VALUES (N'PAD505*MAT540', N'PAD505',
N'MAT540')
INSERT INTO D_BI_Class_prereq VALUES (N'PAD520*MAT540', N'PAD520',
N'MAT540')
INSERT INTO D_BI_Class_prereq VALUES (N'PAD590*DRP999', N'PAD590',
N'DRP999')
INSERT INTO D_BI_Class_prereq VALUES (N'PSY400*PSY215', N'PSY400',
N'PSY215')
INSERT INTO D_BI_Class_prereq VALUES (N'SEC305*CIS175', N'SEC305',
N'CIS175')
INSERT INTO D_BI_Class_prereq VALUES (N'SEC310*CIS270', N'SEC310',
N'CIS270')
INSERT INTO D_BI_Class_prereq VALUES (N'SEC402*CIS270', N'SEC402',
N'CIS270')
INSERT INTO D_BI_Class_prereq VALUES (N'SEC405*CIS333', N'SEC405',
N'CIS333')
INSERT INTO D_BI_Class_prereq VALUES (N'SEC460*CIS270', N'SEC460',
N'CIS270')
INSERT INTO D_BI_Class_prereq VALUES (N'SOC300*SOC100', N'SOC300',
N'SOC100')
INSERT INTO D_BI_Class_prereq VALUES (N'SOC301*SOC100', N'SOC301',
N'SOC100')
INSERT INTO D_BI_Class_prereq VALUES (N'SOC302*SOC100', N'SOC302',
N'SOC100')
INSERT INTO D_BI_Class_prereq VALUES (N'SOC303*SOC100', N'SOC303',
N'SOC100')
INSERT INTO D_BI_Class_prereq VALUES (N'SOC304*SOC100', N'SOC304',
N'SOC100')
INSERT INTO D_BI_Class_prereq VALUES (N'SOC400*SOC100', N'SOC400',
N'SOC100')

INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC105*ACC100',
N'ACC105', N'ACC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC110*ACC100',
N'ACC110', N'ACC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC115*ACC100',
N'ACC115', N'ACC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC200*ACC105',
N'ACC200', N'ACC105')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC205*ACC200',
N'ACC205', N'ACC200')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC208*ACC110',
N'ACC208', N'ACC110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC210*ACC205',
N'ACC210', N'ACC205')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC215*ACC100',
N'ACC215', N'ACC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC220*ACC105',
N'ACC220', N'ACC105')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC225*ACC110',
N'ACC225', N'ACC110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC297*ACC298',
N'ACC297', N'ACC298')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC300*ACC110',
N'ACC300', N'ACC110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC304*ACC303',
N'ACC304', N'ACC303')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC305*ACC205',
N'ACC305', N'ACC205')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC310*ACC210',
N'ACC310', N'ACC210')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC315*ACC310',
N'ACC315', N'ACC310')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC320*ACC303',
N'ACC320', N'ACC303')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC325*ACC225',
N'ACC325', N'ACC225')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC400*ACC310',
N'ACC400', N'ACC310')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC401*ACC304',
N'ACC401', N'ACC304')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC402*ACC401',
N'ACC402', N'ACC401')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC403*ACC304',
N'ACC403', N'ACC304')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC404*ACC303',
N'ACC404', N'ACC303')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC405*ACC403',
N'ACC405', N'ACC403')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC410*ACC304',
N'ACC410', N'ACC304')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC415*ACC305',
N'ACC415', N'ACC305')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC561*ACC560',
N'ACC561', N'ACC560')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC562*ACC403',
N'ACC562', N'ACC403')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC563*ACC303',
N'ACC563', N'ACC303')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC564*ACC403',
N'ACC564', N'ACC403')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC566*ACC304',
N'ACC566', N'ACC304')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC568*ACC565',
N'ACC568', N'ACC565')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC569*ACC560',
N'ACC569', N'ACC560')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ACC570*ACC560',
N'ACC570', N'ACC560')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS112*BUS111',
N'BUS112', N'BUS111')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS205*BUS100',
N'BUS205', N'BUS100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS213*BUS107',
N'BUS213', N'BUS107')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS250*BUS100',
N'BUS250', N'BUS100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS290*BUS100',
N'BUS290', N'BUS100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS310*BUS100',
N'BUS310', N'BUS100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS325*BUS100',
N'BUS325', N'BUS100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS335*BUS310',
N'BUS335', N'BUS310')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS405*BUS310',
N'BUS405', N'BUS310')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS407*BUS310',
N'BUS407', N'BUS310')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS409*BUS310',
N'BUS409', N'BUS310')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS505*BUS501',
N'BUS505', N'BUS501')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS511*BUS533',
N'BUS511', N'BUS533')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS518*BUS517',
N'BUS518', N'BUS517')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS519*BUS517',
N'BUS519', N'BUS517')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS522*BUS530',
N'BUS522', N'BUS530')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS527*BUS517',
N'BUS527', N'BUS517')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'BUS538*MAT540',
N'BUS538', N'MAT540')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS108*CIS105',
N'CIS108', N'CIS105')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS111*CIS105',
N'CIS111', N'CIS105')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS113*CIS111',
N'CIS113', N'CIS111')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS115*CIS110',
N'CIS115', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS120*CIS115',
N'CIS120', N'CIS115')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS155*CIS110',
N'CIS155', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS176*CIS175',
N'CIS176', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS177*CIS175',
N'CIS177', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS178*CIS176',
N'CIS178', N'CIS176')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS179*CIS175',
N'CIS179', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS180*CIS175',
N'CIS180', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS181*CIS175',
N'CIS181', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS182*CIS175',
N'CIS182', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS185*CIS175',
N'CIS185', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS187*CIS175',
N'CIS187', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS203*CIS175',
N'CIS203', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS204*CIS203',
N'CIS204', N'CIS203')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS205*CIS204',
N'CIS205', N'CIS204')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS209*CIS110',
N'CIS209', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS210*CIS111',
N'CIS210', N'CIS111')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS212*MAT105',
N'CIS212', N'MAT105')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS220*CIS110',
N'CIS220', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS230*CIS105',
N'CIS230', N'CIS105')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS230*CIS107',
N'CIS230', N'CIS107')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS232*CIS178',
N'CIS232', N'CIS178')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS234*CIS232',
N'CIS234', N'CIS232')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS235*CIS110',
N'CIS235', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS240*CIS110',
N'CIS240', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS241*CIS240',
N'CIS241', N'CIS240')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS242*CIS110',
N'CIS242', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS248*CIS110',
N'CIS248', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS249*CIS248',
N'CIS249', N'CIS248')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS250*CIS110',
N'CIS250', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS251*CIS250',
N'CIS251', N'CIS250')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS252*CIS234',
N'CIS252', N'CIS234')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS254*CIS252',
N'CIS254', N'CIS252')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS255*CIS255',
N'CIS255', N'CIS255')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS265*CIS242',
N'CIS265', N'CIS242')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS266*CIS265',
N'CIS266', N'CIS265')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS267*CIS111',
N'CIS267', N'CIS111')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS267*CIS242',
N'CIS267', N'CIS242')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS272*CIS181',
N'CIS272', N'CIS181')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS275*CIS110',
N'CIS275', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS276*CIS111',
N'CIS276', N'CIS111')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS278*CIS272',
N'CIS278', N'CIS272')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS279*CIS181',
N'CIS279', N'CIS181')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS280*CIS181',
N'CIS280', N'CIS181')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS283*CIS282',
N'CIS283', N'CIS282')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS285*CIS280',
N'CIS285', N'CIS280')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS286*CIS279',
N'CIS286', N'CIS279')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS287*CIS282',
N'CIS287', N'CIS282')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS289*CIS282',
N'CIS289', N'CIS282')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS290*CIS285',
N'CIS290', N'CIS285')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS293*CIS175',
N'CIS293', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS300*CIS285',
N'CIS300', N'CIS285')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS301*CIS276',
N'CIS301', N'CIS276')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS302*CIS282',
N'CIS302', N'CIS282')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS303*CIS285',
N'CIS303', N'CIS285')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS304*CIS175',
N'CIS304', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS305*CIS276',
N'CIS305', N'CIS276')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS307*CIS110',
N'CIS307', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS311*CIS270',
N'CIS311', N'CIS270')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS312*CIS155',
N'CIS312', N'CIS155')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS315*CIS175',
N'CIS315', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS317*CIS284',
N'CIS317', N'CIS284')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS318*CIS282',
N'CIS318', N'CIS282')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS319*CIS187',
N'CIS319', N'CIS187')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS320*CIS110',
N'CIS320', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS321*CIS155',
N'CIS321', N'CIS155')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS322*CIS305',
N'CIS322', N'CIS305')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS323*CIS305',
N'CIS323', N'CIS305')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS325*CIS265',
N'CIS325', N'CIS265')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS326*CIS242',
N'CIS326', N'CIS242')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS327*CIS325',
N'CIS327', N'CIS325')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS330*CIS270',
N'CIS330', N'CIS270')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS333*CIS175',
N'CIS333', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS337*CIS175',
N'CIS337', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS345*CIS111',
N'CIS345', N'CIS111')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS360*CIS305',
N'CIS360', N'CIS305')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS403*CIS204',
N'CIS403', N'CIS204')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS404*CIS205',
N'CIS404', N'CIS205')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS405*CIS345',
N'CIS405', N'CIS345')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS410*CIS312',
N'CIS410', N'CIS312')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS412*CIS110',
N'CIS412', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS415*CIS111',
N'CIS415', N'CIS111')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS423*CIS326',
N'CIS423', N'CIS326')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS427*CIS323',
N'CIS427', N'CIS323')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS430*MAT300',
N'CIS430', N'MAT300')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS434*CIS276',
N'CIS434', N'CIS276')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS435*CIS427',
N'CIS435', N'CIS427')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS444*CIS434',
N'CIS444', N'CIS434')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS445*CIS325',
N'CIS445', N'CIS325')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS445*CIS435',
N'CIS445', N'CIS435')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS450*CIS175',
N'CIS450', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS454*CIS444',
N'CIS454', N'CIS444')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS463*CIS305',
N'CIS463', N'CIS305')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS464*CIS444',
N'CIS464', N'CIS444')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS465*CIS305',
N'CIS465', N'CIS305')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS475*CIS415',
N'CIS475', N'CIS415')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS484*CIS305',
N'CIS484', N'CIS305')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS485*CIS110',
N'CIS485', N'CIS110')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS485*CIS465',
N'CIS485', N'CIS465')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS490*CIS415',
N'CIS490', N'CIS415')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS492*CIS325',
N'CIS492', N'CIS325')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS505*CIS175',
N'CIS505', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS511*CIS500',
N'CIS511', N'CIS500')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS514*CIS175',
N'CIS514', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS516*CIS175',
N'CIS516', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS521*CIS500',
N'CIS521', N'CIS500')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS525*CIS500',
N'CIS525', N'CIS500')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS526*CIS500',
N'CIS526', N'CIS500')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS528*CIS500',
N'CIS528', N'CIS500')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS530*MAT300',
N'CIS530', N'MAT300')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS535*CIS530',
N'CIS535', N'CIS530')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS540*CIS500',
N'CIS540', N'CIS500')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS541*CIS270',
N'CIS541', N'CIS270')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS542*CIS270',
N'CIS542', N'CIS270')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CIS545*CIS270',
N'CIS545', N'CIS270')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'CRJ105*CRJ100',
N'CRJ105', N'CRJ100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ECO205*ECO100',
N'ECO205', N'ECO100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ECO301*ECO101',
N'ECO301', N'ECO101')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ECO305*ECO100',
N'ECO305', N'ECO100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ECO310*ECO102',
N'ECO310', N'ECO102')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ECO410*ECO305',
N'ECO410', N'ECO305')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ECO440*ECO100',
N'ECO440', N'ECO100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ECO470*ECO102',
N'ECO470', N'ECO102')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ECO470*MAT300',
N'ECO470', N'MAT300')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'FIN100*ACC100',
N'FIN100', N'ACC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'FIN300*FIN100',
N'FIN300', N'FIN100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'FIN320*FIN100',
N'FIN320', N'FIN100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'FIN350*FIN100',
N'FIN350', N'FIN100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'FIN410*FIN350',
N'FIN410', N'FIN350')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'FIN534*ACC560',
N'FIN534', N'ACC560')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'FIN560*FIN534',
N'FIN560', N'FIN534')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'FIN564*FIN534',
N'FIN564', N'FIN534')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'HSA510*ECO100',
N'HSA510', N'ECO100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'HSA590*DRP999',
N'HSA590', N'DRP999')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ITB300*BUS200',
N'ITB300', N'BUS200')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'ITB400*ECO100',
N'ITB400', N'ECO100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'LAN112*LAN111',
N'LAN112', N'LAN111')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'LEG105*LEG100',
N'LEG105', N'LEG100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT102*MAT101',
N'MAT102', N'MAT101')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT103*MAT100',
N'MAT103', N'MAT100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT200*MAT105',
N'MAT200', N'MAT105')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT205*MAT200',
N'MAT205', N'MAT200')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT305*MAT300',
N'MAT305', N'MAT300')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT310*MAT200',
N'MAT310', N'MAT200')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT311*MAT310',
N'MAT311', N'MAT310')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT315*MAT310',
N'MAT315', N'MAT310')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT320*MAT315',
N'MAT320', N'MAT315')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT325*MAT315',
N'MAT325', N'MAT315')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT400*MAT300',
N'MAT400', N'MAT300')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT405*MAT400',
N'MAT405', N'MAT400')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT410*HUM200',
N'MAT410', N'HUM200')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT415*MAT410',
N'MAT415', N'MAT410')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MAT540*MAT300',
N'MAT540', N'MAT300')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'MKT105*MKT100',
N'MKT105', N'MKT100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'PAD505*MAT540',
N'PAD505', N'MAT540')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'PAD520*MAT540',
N'PAD520', N'MAT540')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'PAD590*DRP999',
N'PAD590', N'DRP999')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'PSY400*PSY215',
N'PSY400', N'PSY215')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SEC305*CIS175',
N'SEC305', N'CIS175')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SEC310*CIS270',
N'SEC310', N'CIS270')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SEC402*CIS270',
N'SEC402', N'CIS270')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SEC405*CIS333',
N'SEC405', N'CIS333')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SEC460*CIS270',
N'SEC460', N'CIS270')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SOC300*SOC100',
N'SOC300', N'SOC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SOC301*SOC100',
N'SOC301', N'SOC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SOC302*SOC100',
N'SOC302', N'SOC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SOC303*SOC100',
N'SOC303', N'SOC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SOC304*SOC100',
N'SOC304', N'SOC100')
INSERT INTO D_BI_Class_prereq_optional VALUES (N'SOC400*SOC100',
N'SOC400', N'SOC100')

rcamarda wrote:

> We’ve been tackling a tricky business problem that will be implemented
> in SQL.
>
> Students enroll in a particular degree program that requires a list of
> classes.
> We built a table the processes all the classes a student has taken and
> all the classes the student needs to take to complete the degree
> program, known as Curriculum Matrix.
> Some classes have prerequisites (prereqs), in that the class might
> require 1 or 2 prereqs. Sometimes there are optional prereqs.
> Example: MATH205 requires MATH100 and (MATH105 OR MATH 110).
> Example: ENGLISH200 requires ENGLISH 100
>
> The challenge the business doesn’t want classes in the Curriculum
> Matrix that the student hasn’t taken the prereqs.
> We have three tables:
> 1. All the classes a student has taken and needs to take – aka
> Curriculum Matrix
> 2. All the classes that have a prereq
> 3. All the classes that have the “optional” prereqs – See first
> example
> We’ve been trying to find a way to inner join these tables so that the
> classes requiring prereqs are not included unless the student has the
> prereqs.
>
>
>
> ** this data is from our data warehouse. I know that these are not
> tables by definition since we haven’t set a primary key nor a
> clustered index **
> Thanks in Advance.
> Rob
>
> “Curriculum Matrix” DDL:
> CREATE TABLE [dbo].[F_BI_STUDENT_CURRIC_MATRIX](
> [STUDENT_ID] [char](10) NULL,
> [SESSION_ID] [char](6) NULL,
> [CLASS_ID] [char](6) NULL,
> [NEED] [int] NULL,
> [HAVE] [int] NULL
> ) ON [PRIMARY]
>
>
> Prereqs:
> CREATE TABLE [dbo].[D_BI_Class_prereq](
> [UNIQUE_KEY] [varchar](24) NULL,
> [CLASS_ID] [char](10) NULL,
> [PREREQ_CLASS_ID] [char](10) NULL
> ) ON [PRIMARY]
>
>
> “Optional Prereqs”:
> CREATE TABLE [dbo].[D_BI_Class_Prereq_Optional](
> [UNIQUE_KEY] [varchar](13) NULL,
> [CLASS_ID] [char](10) NULL,
> [PREREQ_OPTIONAL_CLASS_ID] [char](10) NULL
> ) ON [PRIMARY]

I think this will work:

select STUDENT_ID, SESSION_ID, CLASS_ID, NEED, HAVE
from F_BI_STUDENT_CURRIC_MATRIX m
where not exists (
select *
from D_BI_Class_prereq p
where p.CLASS_ID = m.CLASS_ID
and not exists (
select *
from F_BI_STUDENT_CURRIC_MATRIX mp
where mp.STUDENT_ID = m.STUDENT_ID
and mp.CLASS_ID = p.PREREQ_CLASS_ID
and mp.HAVE = 1
)
)
and not exists (
select *
from D_BI_Class_Prereq_Optional o
where o.CLASS_ID = m.CLASS_ID
and not exists (
select *
from F_BI_STUDENT_CURRIC_MATRIX mo
where mo.STUDENT_ID = m.STUDENT_ID
and mo.CLASS_ID = o.PREREQ_CLASS_ID
and mo.HAVE = 1
)
)