ITC 341 Spring 2019 2/112019 Dr. Ugur Homework #3 (20 points) Due: Feb. 18, 2019 Monday Purpose: This homework is to get familiar with the Relational Model and Relational Algebra Put your full name on the top, type your answers in a Word document called-3decx (or scan your hand-written answers in a pdf file: hw-3.pdf), and submit the file on Blackbeard. Consider three tables T1, T2 and T3 below. Show the results of the following operations: 10 10b6 30 3 25 15 b 8 25 a 6 15 b 5 10 b 6 10 b (Use the space on the right-hand side if possible) a) P-10 (TI) TR (TI) d) . (T2) c) TI XT3 (The Cartesian product) ITC 341 Spring 2019 2/11/2019 Dr.Ugu f) Tl equi-join (TLC- [oqu-join is done on tepecifiedsribute! i.e., get all combination of tuples that have equal values on join condition attributes, TI.C and T3.C attribute list is the same as the Cartesian Product) g) TI natural-join T3 (natural join is done on the common antribute i.e..get all combination of tuples that have equal valucs on the common attribute, attribute list is one less than the Cartesian Product; the comon attobute is listed only h) TI equi-join (TIP-T3.A) T3 (equi-join is done on the specified attributes) i.e.. get all combination of tuples that have equal values on join condition attributes, TI.P and T3.A attribute list is the same as the Cartesian Product) k) T2-T3