12.d.    For the above question, unless you added a special command, some courses (notably database) appeared more than once on the list. Correct this situation.

 

Commands

Output

Select unique course_name, dept_name

From courses, department, professors, teach

Where department.dept_id = professors.dept_id

And professors. Prof_id = teach.prof_id

And teach.course_id = courses.course_id

Order by course_name;

COURSE_NAME          DEPT_NAME

Adv. Acct                       Accounting

Basic Acct                      Accounting

COBOL                          Infosys

Database                         Infosys

Intermed. Acct.               Accounting

Networks                        Infosys

Syst. Analysis                 Infosys

 

7 rows selected.