Hierarchical Query

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