Just gotta create SQL codes out of the data inputted in the images, help please! Display all data from propertyrent table Display client comments from viewing about rental properties. Display available job position of staffs

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
icon
Related questions
Question

Just gotta create SQL codes out of the data inputted in the images, help please!

  • Display all data from propertyrent table
  • Display client comments from viewing about rental properties.
  • Display available job position of staffs
  • Display the information (name, position, salary) about a person who earns the highest salary.
  • Display the number of staff grouped by branch.
  • Display each branchID with the number of rental properties grouped by branch.
  • Display each staffID n with the number of rental properties grouped by staff.
  • Display the rental property located Glasgow
  • Display ownerID who owns the rental property 'PA14'.
  • Display the most frequently viewed property.
  • Display available(possible) rental prices
  • Display the name of client who were looks for "House"
  •  
  • *** Multiple tables
  • Display branch information (city) with the number of rental properties grouped by branch.
  • Display staff information (name, position, branchID, Brach City) with the number of rental properties grouped by staff.
  • Display owner information (name, address, etc.) who owns the rental property 'PL94'.
  • Display the number of rental properties group by the type
  • List staff information who works at London.
Viewing
Client
Branch
PropertyNO, ClientNo (k)
PK ClientNo
BranchNo
Works at
PropertyRent
PropertyNo
Staff
BrachNo, StaffNo, OwnerNo (fk)
StaffNo
BranchNo (fk)
privateOwner
PK OwnerNo
Transcribed Image Text:Viewing Client Branch PropertyNO, ClientNo (k) PK ClientNo BranchNo Works at PropertyRent PropertyNo Staff BrachNo, StaffNo, OwnerNo (fk) StaffNo BranchNo (fk) privateOwner PK OwnerNo
Photos - ITEC315LABO5PrivateOwnerTable.png
Photos - ITEC315LABO5Viewing Table.png
Photos - ITEC315LABO5Branch Table.png
Photos - ITEC315LABO5ClientTable.png
+
+
+
女 X。
Table: I VIEWING
CLIENTNO PROPERTYNO VIEWDATE
COMMENTS
Table:
BRANCH
Table:
PRIVATEOWNER
Filter
Filter
Filter
Filter
Table:
CLIENT
1 CR56
PA14
24-May-04 too small
BRANCHNO
STREET
CITY
POSTCODE
OWNERNO FNAME LANME
ADDRESS
TELNO
CLIENTNO FNAME LNAME
TELNO
PREFTYPE MAXRENT
Filter
Filter Filter
Filter
2 CR62
PA14
14-May-04 no dining room
Filter
Filter
Filter
Filter
Filter
Filter Filter
Filter
Filter
Filter
Filter
3 CR56
26-May-04 NULL
1 BO05
22 Deer Rd
London
Sw1 4EH
1 C046
Joe
Keogh 2 Fergus Dr. Aberdeen AB2 7Sx 012-234-5938
PG4
1 CR76
John
Kay
123-345-7891 Flat
425
4 CR56
28-Apr-04 NULL
2 B007
16 Argyll St Aberdeen AB1 3SU
PG36
2 C087
Carol
Farrel
6 Array St. Glasgow G32 9DX
231-456-2222
2 CR56
Aline
Stewart 213-344-7234 Flat
350
5 CR62
20-Apr-04 too remote
3 B003
163 Main St Glasgow G11 9QX
PG4
3 C040
Tina
Murphy 63 Well St. Glasgow G42
231-234-3478
3 CR74
Mike
Ritchie 345-123-7234 House
750
4 B004
32 Manse Rd Bristol
BS99 1NZ
4 C093
Tony
Shaw
12 Park Pl. Glasgow G4 0QR
231-678-8648
4 CR62
Mary
Tregear 01224-196720 Flat
600
5 B002
56 Clover Dr London
NW10 6EU
Photos - ITEC315LABO5StaffTable.png
C315LABO5PropertyRentTable.png
+ Add to
+
hotos
4140
urose, Keith Ross
Ba Filter in any column
ON
Table:
PROPERTYRENT
Table:
STAFF
ba Filter
PROPERTYNO
STREET
CITY
POSTCODE TYPE ROOMS RENT OWNERNO STAFFNO BRANCHNO
STAFFNO FNAME LNAME POSITION SEX
DOB
SALARY BRANCHNO
Filter
Filter
Filter
Filter
Filter Filter
Filter Filter
Filter
Filter
Filter
Filter
Filter Filter
Section: Ch...
Filter
Filter
Filter
Filter
1 PA14
16 Holland
Aberdeen AB1 5SU
House 6
650
CO46
SA9
BO07
|1 SL21
John
White
Manager M
1-Oct-45 30000
BO05
2 PL94
6 Argyll St
London
NW2
Flat
4
400
C087
SL41
B005
2 SG37
Ann
Birch
Assistant
F
10-Nov-60 12000
B003
he difference...
3 PG4
6 Lawrence St Glasgow G11 9QX
Flat
350
C040
NULL
B003
3 SG14
David
Ford
Supervisor M
23-Mar-58 18000
вооз
4 PG36
2 Manor Rd
Glasgow G32 4QX
Flat
3
375
C093
SG37
B003
4 SA9
Mary
Howe
Assistant
19-Feb-70 9000
B007
5 PG21
18 Dale Rd
Glasgow G12
ar books
House 5
600
C087
SG37
B003
5 SG5
Susan Brand Manager
F
3-Jun-40 24000
B003
6 PG16
5 Novar Dr
Glasgow G12 9AX
Flat
450
C093
SG14
BO03
6 SL41
Julie
Lee
Assistant
F
13-Jun-65 9000
BO05
your
!!
of
+
Transcribed Image Text:Photos - ITEC315LABO5PrivateOwnerTable.png Photos - ITEC315LABO5Viewing Table.png Photos - ITEC315LABO5Branch Table.png Photos - ITEC315LABO5ClientTable.png + + + 女 X。 Table: I VIEWING CLIENTNO PROPERTYNO VIEWDATE COMMENTS Table: BRANCH Table: PRIVATEOWNER Filter Filter Filter Filter Table: CLIENT 1 CR56 PA14 24-May-04 too small BRANCHNO STREET CITY POSTCODE OWNERNO FNAME LANME ADDRESS TELNO CLIENTNO FNAME LNAME TELNO PREFTYPE MAXRENT Filter Filter Filter Filter 2 CR62 PA14 14-May-04 no dining room Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter 3 CR56 26-May-04 NULL 1 BO05 22 Deer Rd London Sw1 4EH 1 C046 Joe Keogh 2 Fergus Dr. Aberdeen AB2 7Sx 012-234-5938 PG4 1 CR76 John Kay 123-345-7891 Flat 425 4 CR56 28-Apr-04 NULL 2 B007 16 Argyll St Aberdeen AB1 3SU PG36 2 C087 Carol Farrel 6 Array St. Glasgow G32 9DX 231-456-2222 2 CR56 Aline Stewart 213-344-7234 Flat 350 5 CR62 20-Apr-04 too remote 3 B003 163 Main St Glasgow G11 9QX PG4 3 C040 Tina Murphy 63 Well St. Glasgow G42 231-234-3478 3 CR74 Mike Ritchie 345-123-7234 House 750 4 B004 32 Manse Rd Bristol BS99 1NZ 4 C093 Tony Shaw 12 Park Pl. Glasgow G4 0QR 231-678-8648 4 CR62 Mary Tregear 01224-196720 Flat 600 5 B002 56 Clover Dr London NW10 6EU Photos - ITEC315LABO5StaffTable.png C315LABO5PropertyRentTable.png + Add to + hotos 4140 urose, Keith Ross Ba Filter in any column ON Table: PROPERTYRENT Table: STAFF ba Filter PROPERTYNO STREET CITY POSTCODE TYPE ROOMS RENT OWNERNO STAFFNO BRANCHNO STAFFNO FNAME LNAME POSITION SEX DOB SALARY BRANCHNO Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Section: Ch... Filter Filter Filter Filter 1 PA14 16 Holland Aberdeen AB1 5SU House 6 650 CO46 SA9 BO07 |1 SL21 John White Manager M 1-Oct-45 30000 BO05 2 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 B005 2 SG37 Ann Birch Assistant F 10-Nov-60 12000 B003 he difference... 3 PG4 6 Lawrence St Glasgow G11 9QX Flat 350 C040 NULL B003 3 SG14 David Ford Supervisor M 23-Mar-58 18000 вооз 4 PG36 2 Manor Rd Glasgow G32 4QX Flat 3 375 C093 SG37 B003 4 SA9 Mary Howe Assistant 19-Feb-70 9000 B007 5 PG21 18 Dale Rd Glasgow G12 ar books House 5 600 C087 SG37 B003 5 SG5 Susan Brand Manager F 3-Jun-40 24000 B003 6 PG16 5 Novar Dr Glasgow G12 9AX Flat 450 C093 SG14 BO03 6 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 your !! of +
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

         * Single tables

  • Display the information (name, position, salary) about a person who earns the highest salary.
  • Display the number of staff grouped by branch.
  • Display each branchID with the number of rental properties grouped by branch.
  • Display each staffID n with the number of rental properties grouped by staff.
  • Display the rental property located Glasgow
  • Display ownerID who owns the rental property 'PA14'.
  • Display the most frequently viewed property.
  • Display available(possible) rental prices
  • Display the name of client who were looks for "House"

    * Multiple tables
  • Display branch information (city) with the number of rental properties grouped by branch.
  • Display staff information (name, position, branchID, Brach City) with the number of rental properties grouped by staff.
  • Display owner information (name, address, etc.) who owns the rental property 'PL94'.
  • Display the number of rental properties group by the type
  • List staff information who works at London. 
Viewing
Client
Branch
PropertyNO, ClientNo (k)
PK ClientNo
BranchNo
Works at
PropertyRent
PropertyNo
Staff
BrachNo, StaffNo, OwnerNo (fk)
StaffNo
BranchNo (fk)
privateOwner
PK OwnerNo
Transcribed Image Text:Viewing Client Branch PropertyNO, ClientNo (k) PK ClientNo BranchNo Works at PropertyRent PropertyNo Staff BrachNo, StaffNo, OwnerNo (fk) StaffNo BranchNo (fk) privateOwner PK OwnerNo
Photos - ITEC315LABO5PrivateOwnerTable.png
Photos - ITEC315LABO5Viewing Table.png
Photos - ITEC315LABO5Branch Table.png
Photos - ITEC315LABO5ClientTable.png
+
+
+
女 X。
Table: I VIEWING
CLIENTNO PROPERTYNO VIEWDATE
COMMENTS
Table:
BRANCH
Table:
PRIVATEOWNER
Filter
Filter
Filter
Filter
Table:
CLIENT
1 CR56
PA14
24-May-04 too small
BRANCHNO
STREET
CITY
POSTCODE
OWNERNO FNAME LANME
ADDRESS
TELNO
CLIENTNO FNAME LNAME
TELNO
PREFTYPE MAXRENT
Filter
Filter Filter
Filter
2 CR62
PA14
14-May-04 no dining room
Filter
Filter
Filter
Filter
Filter
Filter Filter
Filter
Filter
Filter
Filter
3 CR56
26-May-04 NULL
1 BO05
22 Deer Rd
London
Sw1 4EH
1 C046
Joe
Keogh 2 Fergus Dr. Aberdeen AB2 7Sx 012-234-5938
PG4
1 CR76
John
Kay
123-345-7891 Flat
425
4 CR56
28-Apr-04 NULL
2 B007
16 Argyll St Aberdeen AB1 3SU
PG36
2 C087
Carol
Farrel
6 Array St. Glasgow G32 9DX
231-456-2222
2 CR56
Aline
Stewart 213-344-7234 Flat
350
5 CR62
20-Apr-04 too remote
3 B003
163 Main St Glasgow G11 9QX
PG4
3 C040
Tina
Murphy 63 Well St. Glasgow G42
231-234-3478
3 CR74
Mike
Ritchie 345-123-7234 House
750
4 B004
32 Manse Rd Bristol
BS99 1NZ
4 C093
Tony
Shaw
12 Park Pl. Glasgow G4 0QR
231-678-8648
4 CR62
Mary
Tregear 01224-196720 Flat
600
5 B002
56 Clover Dr London
NW10 6EU
Photos - ITEC315LABO5StaffTable.png
C315LABO5PropertyRentTable.png
+ Add to
+
hotos
4140
urose, Keith Ross
Ba Filter in any column
ON
Table:
PROPERTYRENT
Table:
STAFF
ba Filter
PROPERTYNO
STREET
CITY
POSTCODE TYPE ROOMS RENT OWNERNO STAFFNO BRANCHNO
STAFFNO FNAME LNAME POSITION SEX
DOB
SALARY BRANCHNO
Filter
Filter
Filter
Filter
Filter Filter
Filter Filter
Filter
Filter
Filter
Filter
Filter Filter
Section: Ch...
Filter
Filter
Filter
Filter
1 PA14
16 Holland
Aberdeen AB1 5SU
House 6
650
CO46
SA9
BO07
|1 SL21
John
White
Manager M
1-Oct-45 30000
BO05
2 PL94
6 Argyll St
London
NW2
Flat
4
400
C087
SL41
B005
2 SG37
Ann
Birch
Assistant
F
10-Nov-60 12000
B003
he difference...
3 PG4
6 Lawrence St Glasgow G11 9QX
Flat
350
C040
NULL
B003
3 SG14
David
Ford
Supervisor M
23-Mar-58 18000
вооз
4 PG36
2 Manor Rd
Glasgow G32 4QX
Flat
3
375
C093
SG37
B003
4 SA9
Mary
Howe
Assistant
19-Feb-70 9000
B007
5 PG21
18 Dale Rd
Glasgow G12
ar books
House 5
600
C087
SG37
B003
5 SG5
Susan Brand Manager
F
3-Jun-40 24000
B003
6 PG16
5 Novar Dr
Glasgow G12 9AX
Flat
450
C093
SG14
BO03
6 SL41
Julie
Lee
Assistant
F
13-Jun-65 9000
BO05
your
!!
of
+
Transcribed Image Text:Photos - ITEC315LABO5PrivateOwnerTable.png Photos - ITEC315LABO5Viewing Table.png Photos - ITEC315LABO5Branch Table.png Photos - ITEC315LABO5ClientTable.png + + + 女 X。 Table: I VIEWING CLIENTNO PROPERTYNO VIEWDATE COMMENTS Table: BRANCH Table: PRIVATEOWNER Filter Filter Filter Filter Table: CLIENT 1 CR56 PA14 24-May-04 too small BRANCHNO STREET CITY POSTCODE OWNERNO FNAME LANME ADDRESS TELNO CLIENTNO FNAME LNAME TELNO PREFTYPE MAXRENT Filter Filter Filter Filter 2 CR62 PA14 14-May-04 no dining room Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter 3 CR56 26-May-04 NULL 1 BO05 22 Deer Rd London Sw1 4EH 1 C046 Joe Keogh 2 Fergus Dr. Aberdeen AB2 7Sx 012-234-5938 PG4 1 CR76 John Kay 123-345-7891 Flat 425 4 CR56 28-Apr-04 NULL 2 B007 16 Argyll St Aberdeen AB1 3SU PG36 2 C087 Carol Farrel 6 Array St. Glasgow G32 9DX 231-456-2222 2 CR56 Aline Stewart 213-344-7234 Flat 350 5 CR62 20-Apr-04 too remote 3 B003 163 Main St Glasgow G11 9QX PG4 3 C040 Tina Murphy 63 Well St. Glasgow G42 231-234-3478 3 CR74 Mike Ritchie 345-123-7234 House 750 4 B004 32 Manse Rd Bristol BS99 1NZ 4 C093 Tony Shaw 12 Park Pl. Glasgow G4 0QR 231-678-8648 4 CR62 Mary Tregear 01224-196720 Flat 600 5 B002 56 Clover Dr London NW10 6EU Photos - ITEC315LABO5StaffTable.png C315LABO5PropertyRentTable.png + Add to + hotos 4140 urose, Keith Ross Ba Filter in any column ON Table: PROPERTYRENT Table: STAFF ba Filter PROPERTYNO STREET CITY POSTCODE TYPE ROOMS RENT OWNERNO STAFFNO BRANCHNO STAFFNO FNAME LNAME POSITION SEX DOB SALARY BRANCHNO Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Filter Section: Ch... Filter Filter Filter Filter 1 PA14 16 Holland Aberdeen AB1 5SU House 6 650 CO46 SA9 BO07 |1 SL21 John White Manager M 1-Oct-45 30000 BO05 2 PL94 6 Argyll St London NW2 Flat 4 400 C087 SL41 B005 2 SG37 Ann Birch Assistant F 10-Nov-60 12000 B003 he difference... 3 PG4 6 Lawrence St Glasgow G11 9QX Flat 350 C040 NULL B003 3 SG14 David Ford Supervisor M 23-Mar-58 18000 вооз 4 PG36 2 Manor Rd Glasgow G32 4QX Flat 3 375 C093 SG37 B003 4 SA9 Mary Howe Assistant 19-Feb-70 9000 B007 5 PG21 18 Dale Rd Glasgow G12 ar books House 5 600 C087 SG37 B003 5 SG5 Susan Brand Manager F 3-Jun-40 24000 B003 6 PG16 5 Novar Dr Glasgow G12 9AX Flat 450 C093 SG14 BO03 6 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 your !! of +
Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
SQL Query
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
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education