Menu

(Solved) : Figure Q311 Ch03vendingco Database Tables Database Name Ch03vendingco Table Name Booth Tab Q34383102 . . .

Figure Q3.11 The Ch03_VendingCo database tables Database name: Ch03_VendingCo Table name: BOOTH Table name: MACHINE MACHNE PRCOUCT MACHNE PRICE Choclate Ba Enegy Drink PRICE 1.25 Eneny Drinik 6. (P3.11) Create the table that results from applying a UNION relational operator to the tables shown in Fig Q3.11. Specifically BOOTH U MACHINE NOTE when taking UNION of two tables with different column names always use column names of first table (this case BOOTH) in resulting table. (3 points) 7. (P3.12) Create the table that results from applying an INTERSECT relational operator to the tables shown in Fig Q3.11. Specifically BOOTH n MACHINE. NOTE when taking INTERSECT of two tables with different column names always use column names of first table (this case BOOTH) in resulting table (3 points)

Table name: STUDENT Database name: Cho3 CollegeQue 1 2272 Table name: PROFESSOR FIGURE Q3.8The Ch03_CollegeQue Database Tables 8. Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to llustrate a natural join between STUDENT and PROFESSOR. The resulting table will only include STU_CODE, PROF CODE, and DEPT_CODE (3 points) 9. Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to illustrate a Left Outer Join of STUDENT to PROFESSOR·The resulting table will only include STU_CODE, STUDENT.PROF_CODE, PROFESOR.PROF CODE, and DEPT CODE (3 points) 10. (P3.14) Suppose that you have the ERM shown in Figure Q3.14

Figure Q3.11 The Ch03_VendingCo database tables Database name: Ch03_VendingCo Table name: BOOTH Table name: MACHINE MACHNE PRCOUCT MACHNE PRICE Choclate Ba Enegy Drink PRICE 1.25 Eneny Drinik 6. (P3.11) Create the table that results from applying a UNION relational operator to the tables shown in Fig Q3.11. Specifically BOOTH U MACHINE NOTE when taking UNION of two tables with different column names always use column names of first table (this case BOOTH) in resulting table. (3 points) 7. (P3.12) Create the table that results from applying an INTERSECT relational operator to the tables shown in Fig Q3.11. Specifically BOOTH n MACHINE. NOTE when taking INTERSECT of two tables with different column names always use column names of first table (this case BOOTH) in resulting table (3 points) Table name: STUDENT Database name: Cho3 CollegeQue 1 2272 Table name: PROFESSOR FIGURE Q3.8The Ch03_CollegeQue Database Tables 8. Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to llustrate a natural join between STUDENT and PROFESSOR. The resulting table will only include STU_CODE, PROF CODE, and DEPT_CODE (3 points) 9. Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to illustrate a Left Outer Join of STUDENT to PROFESSOR·The resulting table will only include STU_CODE, STUDENT.PROF_CODE, PROFESOR.PROF CODE, and DEPT CODE (3 points) 10. (P3.14) Suppose that you have the ERM shown in Figure Q3.14 Show transcribed image text

Expert Answer

Answer to Figure Q311 Ch03vendingco Database Tables Database Name Ch03vendingco Table Name Booth Tab Q34383102 . . .

OR


See what happens after you place this order.

Order a custom paper written from scratch according to your requirements

 

Place your order now