3. Show the result of a Cartesian-product operation applied to Branch and Registration relations. (20 points) Branch x Registration 4. Show the result of a natural join of the Branch and Registration relations. (30 points) 5. Obtain the following (i.e., left outer-join). (30 points) Branch Registration of the ome tabase branchNo street city postcode BOOS 22 Deer Rd London SWI LEH BOZ 16 Argyll st Aberdeen AB23SU B003 163 Main St Glasgow GII 90X B004 32 Manse Rd Bristol BS99 INZ B002 56 Clover De London NW10 6EU Staff staffNo Name Name Position sex DOB salary branch No SL21 John White Manager M 1-Oct-45 30000 BOOS SG37 Ann Beech Assistant F 10-Nov-60 12000 B003 SG14 David Ford Supervisor M 24-Mar-5818000 B003 SAS Mary Howe Assistant F 19-Feb-709000 B007 SG5 Susan Brand Manager F 3-Jun-40 24000 B003 SLAI Julie Lee Assistant F 13-Jun-65 9000 BOOS PropertyForRent property No street city postcode type rooms rent ownerNo staffNo branch No PA14 16 Holhead Aberdeen AB SSU House | 6 650C046 SA9 B007 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 PG4 BOOS 6 Lawrence StGlasgow GII 90X Flat 3 350 0040 PG36 B003 2 Manor Rd Glasgow 632 40X Flat 3 375 0093 PG21 SG37 18 Dale Rd Glasgow G12 B003 Houses 600 C087 B003 S Novar Dr Glasgow G12 9AX Flat 4 450 0093 SG14 B003 Client PG16 SG37 clientNo Name Name telo prefTypemaxRent Mall CR76 John Kay 0207-774-5632 Flat 425 John Kaymail.com CR56 Aline Stewart 0141-848-1825 Flat 350 astewarthotmail.com CR74 Mike Ritchie 01475-392178 House 750 mitchel@yahoo.co.uk CR62 Mary Tregear 01224-196720 Flat 600 marthotmail.co.uk Private Owner password owner No Name Name address talNo Mail C046 Joe Keogh 2 Fergus Dr. Aberdeen AB2 75X01224-861212 krogoth.com C087 Carol Farrel 6 Achray St, Glasgow 32 9DX 0141-357.7419 regmail.com C040 Tina Murphy 63 Well St. Glasgow G42 0141-943-1726 hotmail.com C093 Tony Shaw 12 Park Pl. Glasgow GA OOK 0141-225-70.25 tony shaw.com Viewing Registration cliento propertyNo viewDate comment clientNobranch Nostato dato Joined CR56 PA14 24-May-13 too small CR76 BOOS SL41 2. lan- CR76 PG4 20-Apr-13 too remote CR56 HO SC32 11. Ape 12 CR56 PG4 26-May-13 CR74 BOOS SG7 16-Nov. 11 CR62 PA14 14-May-19 no dining room B007 SAS 7. Mar.12 CR56 PG36 CR62 25-Apr-13