I have attached picture of the dreamhome database. Following questions are relat

Question

I have attached picture of the dreamhome database.

Following questions are related to the DreamHome database schema. 1. A query is from the data given on pp. 112 Select clientNo, viewingDate From Viewing Where viewingDate 20-May-13' How many columns? How many rows based on the data instance? Exactly what the outcome is? (Including the column headings) 2. A query is from the data given on pp. 112 Select branchNo, max (rooms) From PropertyForRent Group by branchNoj How many columns? How many rows based on the data instance? Exactly what the outcome is? (Including the column headings)

Explanation / Answer

Ans 1.

a) Two columns

b) Two rows

c) Outcome:

CLIENTNO VIEWINGDATE
---------- ----------
CR56 24-May-13
CR56 26-May-13

Ans 2.

a) Two columns

b) Three rows

c) Outcome

BRANCHNO MAX(ROOMS)
---------- ----------

B007 6

B005 4

B003 5

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.