Consider The Two Relations Instructor And Departmentbr #329

Consider the two relations instructor and department<br /> Instructor:</p> <table> <tr> <td>ID</td> <td>Name</td> <td>Dept_name</td> <td>Salary</td> </tr> <tr> <td>1001</td> <td>Ted</td> <td>Finance</td> <td>10000</td> </tr> <tr> <td>1002</td> <td>Bob</td> <td>Music</td> <td>20000</td> </tr> <tr> <td>1003</td> <td>Ron</td> <td>Physics</td> <td>50000</td> </tr> </table> <p>Department:</p> <table> <tr> <td>Dept_name</td> <td>Building</td> <td>Budget</td> </tr> <tr> <td>Biology</td> <td>Watson</td> <td>40000</td> </tr> <tr> <td>Chemistry</td> <td>Painter</td> <td>30000</td> </tr> <tr> <td>Music</td> <td>Taylor</td> <td>50000</td> </tr> </table> <p>Which of the following is used to create view for these relations together?

This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 SQL: Queries, Constraints and Triggers - Views - Quiz No.1.

 Create view instructor_info as select ID, name, building from instructor, department where instructor.dept name= department.dept name;

 Create view instructor_info select ID, name, building from instructor, department;

 Create view instructor_info as select ID, name, building from instructor;

 Create view instructor_info as select ID, name, building from department;