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. |