The degree 1) What is the degree of Booking table of Hotel Reservation db? of guest tables? The degree of 2) What is the degree of privateOwner table of DreamHome db? property For Rent table? The 3) What is the cardinality of PrivateOwner table of Dream Home db? cardinality of Property For Rent table? 4) What is the primary key of PrivateOwner table? 5) What is the primey key of Viewing table? 6) What is the primary of Booking table? 7) Which of the tables have foreign key A) Hotel B) Room C) Guest D) Booking 8) Which of the tables have foreign key? a) Property For Rent b) Registration c) Viewing d) Client e) Private Owner f) Branch 8) Staff 9) Which data can you query about Dream Home db? A) The highest amount a client is willing to pay B) Clients email addresses C) Owner's telephone numbers D) The hiring date size E) Client preferred rental propert types F) Clients credit scores 10) If is possible how do you query about if a client is living in a certain city? You don't need to write SQL statement just explain in your own words? 11) Write the schema of Registration table indicating the primary key. Note: you can use the short form skipping domain specifications, ang Branch igure 4-3 stance of the -earn Home antal database postcode branchNo street B005 BODY city 22 Deer Ra Loodoo SWI4EH 16 Argyll St Aberdeen ABZUSU 163 Main St Glasgow GH 9OX 32 Manse Rd Bristol AS99 INZ 56 Clover De London NW10 GEU 2009 B004 B002 Staff salary branchNo sex DOB staffNo Name Name position SL21 John White Manager M SG37 Ann Beech Assistant SG14 David Ford Supervisor M SAS Mary Assistant F SGS Susan Brand Manager F SL41 Jolie Lee Assistant F 1-Oct-45 30000 BOOS 10-Nov 60 12000 B003 24-Mar-5818000 3003 19-Feb-70 9000 B007 3-Jan-40 24000 B003 13-Jun-65 9000 BOOS Howe city Property For Rent propertyNo street postcode type rooms rent ownerNo staffNo branchNo PA14 16 Holhead Aberdeen AB755U SA9 650 C046 House 16 BOO7 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 B005 PG4 6 Lawrence St Glasgow GII 90X Flat 3 350 C040 B003 PG36 2 Manor Rd Glasgow G32 40X Flat 3 375 C093 SG37 BOOS PG21 18 Dale Rd Glasgow G12 House 5 600 CO87 SG37 B003 PG16 5 Novar De Glasgow G12 9AX Flat 450 C093 SG14 BOO3 Client clientNo Name Name telNo prefTypemaxRent eMail CR76 CR56 CR74 CR62 John Aline Mike Mary Kay 0207-774-5632 Flat Stewart 0141-848-1825 Flat Ritchie 01475-392178 House Tregear 01224-196720 Flat 425 350 750 600 john kay@gmail.com astewart@hotmail.com mritchicol@yahoo.co.uk maryt@hotmail.co.uk Private Owner password ownerNo Name Name address telNo eMail C046 Joe Keogh 2 Fergus Dr. Aberdeen AB275X 01224-861212 Keogh@lhh.com C087 Carol Farrel 6 Achray St. Glasgow G32 9DX 0141-357-7419 carrel@gmail.com C040 Tina Murphy 63 Well St, Glasgow G42 0141-943-1728 tinam@hotmail.com C093 Tony Shaw 12 Park Pl. Glasgow G4OQR 0141-225-7025 tony shaw@ark.com Viewing Registration . clientNo property No viewDate comment clientNo branchNo staffNo date Joined CR56 CR76 CR56 CR62 CR56 PA14 PG4 PG4 PA14 PG36 24-May-13 too small 20-Apr-13 too remote 26-May-13 14-May-13 no dining room 28-Apr-13 CR76 CR56 CR74 CR62 B005 3003 B003 B007 SLAE SG37 SG37 SAS 11-Apr-12 16-Nov-11 7-Mar-12
