Answered: Use the dreamhome.Staff table and…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Use the dreamhome.Staff table and dreamhome.PropertyForRent table.

Write an SQL statement to construct a list of staffNo common between the Staff and PropertyForRent tables.

Transcribed Image Text:MariaDB [dreamhome]> Select * from Staff; -+- | staffNo | fName | 1Name | position | SA9 ISG14 | Mary | Howe | David | Ford | Ann | SG37 SG5 | SL21 | Assistant | F | Supervisor | M | Beech | Assistant | F Manager | John | White | Manager ISL41 | Julie | Lee | Assistant | Susan | Brand | F +- -+‒‒‒‒‒‒‒+· sex 6 rows in set (0.001 sec) | M | F --+ | branchNo | 1 | DOB | salary | 1970-02-19 | 9500.00 B007 | 1958-03-24 | 18000.00 | B003 | 1960-11-10 | 12000.00 | B003 | 1940-06-03 | 24000.00 | B003 | 1945-10-01 | 30000.00 | B005 | 1965-06-13 | 9000.00 B005

[MariaDB [dreamhome]> select * from dreamhome. Property ForRent;
+————
-—+———
| property No | street
+
| PA14
| PG16
| PG21
| PG36
| PG4
| PL94
16 Holhead
| 5 Novar Drive
| 18 Dale Road
| 2 Manor Road
| 6 Lawrence Street
| 6 Argyll Street
| city
+
+--
| postcode | type
-+-
| Aberdeen
| Glasgow
AB7 5SU
G12 9AX
| G12
|
Glasgow
| Glasgow
| G32 4QX
| Glasgow | G11 9QX
| London | NW2
-+-
+-
———
| House
| Flat
| House
| Flat
| Flat
| Flat
|
----
rooms rent
----
ownerNo staffNo | branchNo |
-+————
+
6 650.00 | C046
4 | 450.00 | C093
5 | 600.00 | C087
3 | 375.00 | C093
3 | 350.00 | C040
4 | 400.00 | C087
+
--+-
SA9
| SG14
| SG37
SG37
NULL
| SL41
B007
| B003
|B003
| B003
B003
| B005
-+

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions