Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Q: For each author who has written a book,  list the author name, title name, and the royalty_rate.…
A: 3. SELECT A.au_fname, A.au_lname, T.title_name, R.royalty_rate FROM Titles T, Authors A, Royalties…
Q: Find the title name of the latest published book, the name of its author, and the publisher's name.…
A: 5. SELECT T.title_name, A.au_fname, A.au_lname, P.pub_name  FROM Titles T, Authors A, Publishers P,…
Q: I need help with the SQL query for the following question: 1. Get top 5 list of products liked in…
A: QUERY: Creating table: CREATE TABLE Reviews(     ProductModelName text,     ProductCategory text,…
Q: please use sql to answer the following question and erd had been attach 5.Determine the average…
A: Here have to determine sql query for given problem.
Q: ts: You will need to add data to both tables. Remember that the movie table has th duction co., not…
A: Description:   1- If a user wants to insert records one by one then needs to use the following…
Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez
A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…
Q: Oracle 12c: SQL Chapter Two Textbook Assignment Q1 Create a report showing ALL data from the…
A: SQL is the structured Query Languages is used as the standard programming languages that are used to…
Q: Use SQL to complete the following exercises. Provide SQL screenshots of the results of both…
A: SQL commands are instructions used to communicate with a database to perform tasks, functions, and…
Q: valuate the following view definition: CREATE OR REPLACE VIEW PRODUCT_VIEW AS    SELECT p_code,…
A: Evaluate the following view definition:CREATE OR REPLACE VIEW PRODUCT_VIEWAS    SELECT p_code,…
Q: Report the names of the male students who are older than all female students. 2.Report the…
A: The solution to both parts are given in the below steps with OUTPUT screenshot   Happy to help you ?
Q: . Which manufacturers are located in the city of New York? Show the manufacturer's name, state,…
A: First, three parts will be answered. SQL query: 1) In this query, the SELECT statement along with…
Q: Please write the SQL to return the sale revenue (top line & bottom line) by Marketing channel for…
A: Here have to determine about sql query for given problem statements.
Q: Using Group By with Rollup, write & run the SQL command using MySQL workbench to list the total…
A: The question states :Using Group By with Rollup, write & run the SQL command using MySQL…
Q: The number of times the table structure has been altered by SQL queries. Which major changes need to…
A: Yes, by tracking modifications in the history table and using SQL commands, you can keep a record of…
Q: 4. Finding all students with GPA over 3.4: SELECT * FROM Students WHERE gpa > 3.4; 5- Finding the…
A: Database Schema:1CREATE TABLE Students ( 2 sid INT PRIMARY KEY, 3 name VARCHAR(50), 4 age…
Q: in sql You need to create a new view on the EMPLOYEE table to update salary information. You need…
A: Given data In sql You need to create a new view on the EMPLOYEE table to update salary information.…
Q: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…
A: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…
Q: Use a SELECT statement to view the system variables that enable and disable the binary log and the…
A:
Q: Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle,…
A: SELECT Statement:The query begins with the SELECT keyword, indicating that we want to retrieve…
Q: Write the SQL code to generate the total hours worked and the total charges made by all employees.…
A: See the explanation section for a complete answer.Explanation:To calculate the total hours worked…
Q: Write Create Table SQL statements based on the above ERD. All tables must have primary keys. All…
A: Big Data SQL: Big data SQL or structured query language can be regarded as a base or medium of…
Q: Display the customer number, customer name, order number, and order date for each order. Sort the…
A: solution is given below
Q: sql queries
A: Given :- A relational database schema is given as, Team (tname, year, coach, salary) Player (pname,…
Q: Write a SQL command please   Display the last name, job, salary, and commission percent for all…
A: SQL stands for Structured Query Language. It is a domain specific language and is taken into use for…
Q: Use SQL to complete the following exercises. Provide SQL screenshots of the resutls of both…
A: 1)CREATE TABLE REP (   REP_ID char(2) PRIMARY KEY,   FIRST_NAME char(20),   LAST_NAME varchar(20),…
Q: 6. Create a list of all book titles and costs. Precede each book’s cost with asterisks so that the…
A: A function is a self-contained block of statements. A function can take one or more parameters and…
Q: Get a list of 5 reviews for shoppers in Chicago Here is the information on the field names: The…
A: The details about the table are given with table name and different entities. Here the table name is…
Q: Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle,…
A: In the realm of database management, understanding the characteristics and distribution of data is…
Q: Create a procedure to display manager ID and number of employees managed by each manager. Use…
A: SQL procedure to display manager details from Employee table is given below.
Q: Create the following table in your database with the following schema: Table: Sales | Column Name |…
A: create table query- create table sales(sale_id int primary key ,product_name varchar(200),sale_date…
bartleby

Concept explainers

SQL Query
Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed …
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
expand button
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 +
expand button
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
Check Mark
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
bartleby
This is a popular solution
See solutionCheck out a sample Q&A here
Step 1
VIEW
Display all data from propertyrent table
VIEW
Display client comments from viewing about rental properties.
VIEW
Display available job position of staffs
VIEW
bartleby

Trending nowThis is a popular solution!

bartleby

Step by stepSolved in 4 steps

See solution
Check out a sample Q&A here
Blurred answer
Still need help?
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
expand button
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 +
expand button
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
by Bartleby Expert
SEE SOLUTION
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
expand button
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 +
expand button
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
by Bartleby Expert
SEE SOLUTION
Knowledge Booster
Background pattern image
Computer Science
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
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
SEE MORE TEXTBOOKS