Answered: Just gotta create SQL codes out of the…

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

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: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

This is a popular solution!

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

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.

Solution

by Bartleby Expert

SEE SOLUTION

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.

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