Question: Use tables TI and T2 in this exercise too. Create another table called T3Gobdesc, minpay).Let minpay be type NUMBER(6,2). Populate the table with at least

 Use tables TI and T2 in this exercise too. Create another

Use tables TI and T2 in this exercise too. Create another table called T3Gobdesc, minpay).Let minpay be type NUMBER(6,2). Populate the table with at least one occurrence of each jobdesc from table T2 plus one more jobdesc that is not in T2. Write and display the result of a triple equi-join of T1, T2, and T3. Use an appropriate comment on each of the lines of the WHERE clause where there are equi-join conditions. Note that you will need two equi-join conditions. 3-3. How many rows did you get in the equi-join? b. Use the COUNT() function and display the number of rows (rows) in the equi-join. c. How many rows would you get in this triple Cartesian product? (use COUNTC*)). d. In an equi-join of N tables, you always have a. equi-join conditions in the WHERE clause

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!