Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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.51D

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Seven Databases In Seven Weeks A Guide To Modern Databases And The NoSQL Movement

Authors: Luc Perkins, Eric Redmond, Jim Wilson

2nd Edition

1680502530, 978-1680502534

More Books

Students also viewed these Databases questions

Question

(Appendix) What are sales returns? Why do sales returns occur? LO86

Answered: 1 week ago