Question: Q4) Create the table that results from applying a PROJECT relational operator to the PRODUCT table. The PROJECT operator is as follow: * Price (ITEM)



Q4) Create the table that results from applying a PROJECT relational operator to the PRODUCT table. The PROJECT operator is as follow: * Price (ITEM) (4 points) ITEM Item Price Flash Drive 8 Mouse 1.75 Keyboard 7.5 USB Cable 1.75 Speaker 13 Wireless Mouse 7.5 | (5) Create the table that results from applying a UNION relational operator to the following tables. The UNION operator is as follow: PI U P2 (3.5 points). Pl Item Price Flash Drive 8 Mouse 3 Keyboard 7.5 P2 Item Price Mouse 3 Keyboard 7.5 USB Cable 1.75 Speaker 13 Wireless Mouse 4.75 6) Create the table that results from applying an INTERSECT relational operator to the following tables. The INTERSECT operator is as follow: P1 P2 (3.5 points). P1 Item Price Flash Drive 8 Mouse Keyboard 3 7.5 P2 Item Price Mouse 3 Keyboard 7.5 USB Cable 1.75 Speaker 13 Wireless Mouse 4.75 27) Create the table that results from applying a DIFFERENCE relational operator to the following tables. The DIFFERENCE operator is as follow: P1 P2 (3.5 points) P1 Item Price SSD 46 Mouse 1 3 Keyboard 7.5 Cable 1.75 P2 Item Price Mouse 2 3 Keyboard 7.5 USB Cable 1.75 Speaker 13 Wireless Mouse 4.75 Q8) Create the table that results from applying a PRODUCT relational operator to the following tables. The PRODUCT operator is as follow: T1 x T2 (3.5 points) TI Student ID 1001 1002 1003 Name Allan Mike Sarah Luca Mike Doe T2 Department Computer Science Biology Art English
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
