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.
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.
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
Related questions
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.
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2ec814c7-90f3-4435-9bb8-fcbab3f733ac%2F1bdf5635-ef19-4971-bf6f-a34895c4c808%2F53mr9_processed.png&w=3840&q=75)
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
-+](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2ec814c7-90f3-4435-9bb8-fcbab3f733ac%2F1bdf5635-ef19-4971-bf6f-a34895c4c808%2F5cspamd_processed.png&w=3840&q=75)
Transcribed Image Text:[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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
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.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education