Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE solve problem 1,2,3 ONLY. Prolems are given on last page Cross product every row Cross-product is used to join two relations. For of relation
PLEASE solve problem 1,2,3 ONLY. Prolems are given on last page
Cross product every row Cross-product is used to join two relations. For of relation 1, each row of relation 2 is concatenated. If relation I has m tuples, and relation 2 has a tuples, then the cross-product of relation 1 and 2 will man tuples. Syntax! man Relation 1 x Relation 2 Relation 1 Relation 2 Sup ID Sup. Name Suptoc su contration DEF Rampura 30000 have or Ins. Ans.ID (ins. Name Price Man Name . Startech! ABC Gulshan 30000 2 Keyboard 500 Projector 3500 4 CPU 40000 3 Mouse 1000 Epson Ryans 2 3 4 AMD GHI Uttara 25000 JKL Banani 27000 the cross- Please find out the result of yourself s-product by as it is time consuming CSEULS Lab Class Lecture 10 Page 1 FIRM that Union Union is symbolized by U" symbol. It includes all tuples " in relation A or in relation B. It also eliminates duplicate tuples. So, set A Union Set B can be expressed are as AUB For a Union operation to be valid, the following conditions must hold: 2 D R1 and R2 must have the same no. o. of attributes Attribute domains need to be compatible Duplicate tuples should be automatically removed. 3 Relation 1 Relation 2 Ind ID 1001 WatchID Watch Name 500 EI Rollex 50062 Fast Track U Ind. Name Ayon 1 Ananna 1002 CSEIL! Las Lecture 10 Page 1 51 s2 SID SID SName Dustin sname Rating Age Yuppy 9 22 28 7 16.0 350 3 Lubber 8 1555 31 Lubber 8 55.5 10 U 58 Rusty 35.0 44 Guppy 5 | 350 58 Rusty 10 350 "SIUSZ SID 22 Dustin Is Name Rating Age 45 Lubber 55 5 58 Rusty 10 31 35.0 28 Yuppy 44 Guppy 5 135.0 350 CSEILS Laus Lecture 10 Page 1 4.2001 M Intersection sz SID 51 sName Rating Age SID SName Dustin 22 28 350 3) Lubber 7460 555 8 31 8 Yuppy 19 Lubber Guppy 5 55.5 0 LO 58 Rusty 350 35.0 44 58 Rusty 10 350 Sins2 SID SName Rating Age 31 Lubber 8 55-5 58 Rusty 10 350 CSEULS Lab Clear 10 P4 Dec 2420 IM Set Difference S2 SID shame Rating Age 51 SID SName Dustin 28 22 7 16.0 350 31 Lubber 8 3 1555 8 55.5 Tuppy 9 Lubber 44 Guppy 5/350 58 Rusty 10 58 Rusty Sin 10 1350 Tride subtraction/ difference 1 11 51 - 52 1 estimation / approximation We'll discard all from 52 and also the related things from S1 SI-52 SID s Name Rating Age Dusting 7 450 22 CSEILLS LA Clas Late 10 Pa 41 52 SID 51 SID SName sName Rating Age 128 Tuppy ? 22 Dustin 7 16.0 350 3T Lubber 8 8 1555 55.5 3D Lubber 44 Guppy 5 10 58 Rusty 350 35.0 38 Rusty 10 1350 R1 SID BLD 22 101 DAY 10/10/96 W/12/96 58 103 SIXRI SID YsName might There have Both Sl and R1 have field 22 a Rating Age SIDO BID DAY 22 Dusting 7 45.0 22 109 10/10/96 Dustin 450 58 103 1/12/961 31 Lubber 8 55.5 22 10) 10/1/96 31 Lubber 8 S5.5 58 103 W/12/96 58 Rusty LO 25 0 22 101 10/10/96 58 | Rusty 10 35.0 58 103/12/96 ) some called SID conflict due to attributes having the same name Rename (S) Col. No. The name with which Tol we want to rename No -> SID1,5 -> SL s( Calue olumn sto) sine SOLICY Friday December 24, 2021 4:28 PM Join Conditional Join R1 S1 51.51DStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started