1. Show the result of a selection operation that lists the staff members (from Staff relation) whose salary is greater than 15000. (10 points) That is, the result of the operation: Osalary>15000(Staff) 2. Show the result of a project operation that lists the clientNo, telNo, and maxRent attributes of the Client relation. (10 points) That is, the result of the operation: (Client) clientNo.tel NomaxRent 4:42 + DreamHome rental databse tables.... Chapter The Relational Model Law wana Mama Dowwy Som MOM SHAM NOM M port RM 1 Com prema Marie ON ON COM.AR an - New R.GR to presentare 10 JON ce CHAS la ICH JON Os Scanned by CamScanner Chapter 4 The Relational Moder 4-3 Branch of the branch No street city postcode ome tabase ELOOS BOOZ B003 B004 B002 22 Deer Rd London SWI 4EH 16 Argyll St Aberdeen AB2 JSU 163 Main St Glasgow GII 90X 32 Manse Rd Bristol BS99 INZ 56 Clover Dr London NW10 6EU Staff staf No Name Name position sex DOB salary branchNo BOOS SL21 SC37 SG14 SAY SG5 SL41 John White Manager M Ann Beech Assistant F David Ford Supervisor M Howe Assistant F Susan Brand Manager F Jube Lee Assistant F 1-Oct-45 30000 10-Nov-60 12000 B003 24-Mar-5818000 B003 19-Feb-209000 BOX 3-Jun-40 24000 B003 13-Jun 65 9000 HOOS Mary Property For Rent propertyno street city postcode type rooms rent ownerNo staffNo branchNo SAS SL41 PA14 PL.94 PG4 PC 36 P621 PG16 16 Holhead Aberdeen AH7550 6 Argyll se London NW2 6 Lawrences Glasgow GILSOX 2 Manor Hd Glasgow G3240X 18 Dale Rd Cow GIR IND Glasgow G129AX House Flat 4 Fat Hai House 15 Flat 650C016 400 COS 350 CO4 225 C09 COZ 0 og 800 B005 BO Bao Ho BE SO SG SC14 Client Asian E 13-Jan-65 9000 BOOS cy Property Forent postcode type rooms were branch No PA14 16 Holbend Aberdeen ABYSSU House 6 650C046 SAY PL 6 August London BOOT NW2 Fiat 4 400 C087 SLAI BOS NGA & Lace St Glasgow GILOX Het 3 350 0010 PGS6 2 Manor R4 Glasgow G3240X Hat BOOS 3 375 0093 SG37 PG21 18 Dake Rd Glow G12 3003 Hoss 600 C087 SG37 PG16 5 None De B003 Glasgow GI2 SAX Flat 450 C093 SGIA B003 Client NON Name No prefTypemaxRant.Moll CR76 John Kay 0207-774-5632 Hat 425 Wheemail.com CRSS Aline Stewart 0141-848-1825 Flat 350 hotmail.com CR74 Mike Ritchie 01475-392178 House 750 micheley.co.uk CR62 Mary Tregear 01224-196720 Flat 600 mart@hotmail.co.uk Private Owner owner No Name Name Address talNo Mail word C046 CON CO40 C093 Joe Carol Tina Tony Keogh 2 Fergus Dr. Aberdeen A2 SX 0122161212 Ph.com Farrel 6 Achray St. Glasgow G3Z9DX 0141-357.741 forrelmail.com Murphy 63 Well St. Glasgow G42 011-143-1720 thotmail.com Shaw 12 Purk Pl. Glasgow GLOQR 0141225-7805 ha.com Reglutation allantno branchNo stato date. Joined Viewing cliento properly No viewDate comment CR56 PANG 24-May-13 too small CR76 PGA 20-Apr-15 to remote CRO PG4 26-May 13 CR62 PA14 14-May 13 no dining room CR56 PG36 28-Apr-18 SL41 SEN CR76 CRS6 CR24 CRO HOROS HOROS BOD B002 11. Apr. 12 Nov 11 Var.2 NAU Scanned by CamScanner 2
