A university application have following design

Code:
Curriculum:
Curriculum_ID(PK), Curriculum_Year, ...

Major:
Major_ID(PK), Major_Code, Major_Desc, ...

Category:
Category_ID(PK), Category_Short_DESC, Category_Short_DESC, ...

Course:
Course_ID(PK), Course_Code, Course_Desc, ...

Curriculum_Plan:
Plan_ID(PK), Curriculum_ID(FK to Curriculum), Major_ID(FK to MAjor), 
	Category_ID(FK to Category), Total_Credit_Hours, ....

Course_Curriculum_plan:
Course_Plan_ID(PK), Curriculum_Plan_ID(FK to Curriculum_Plan),
	Credit_Hours, ....


Course_Dependents:
Course_ID(Fk to Course), Course_Dependent_ID(Fk to Course),
	Course_Plan_ID(Fk to Course_Curriculum_Plan)....

A Course can have more then One Dependent
------>


I have the data inserted into Course_Dependents, I'm facing problem in displaying the course in Hierarchical format. Please someone help me in this.

I'm looking for a query which displays output as, with COURSE_DESC:

Code:
	Java
		C++
			C
				Computer Basic
				IT Basics
				Mathematics I
	Mathematics II
		Mathematics I
Its not a homework