Answered: Suppose you have the following…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Suppose you have the following relational database scheme for a real estate agency:

Real Estate Office (officeID, street, city, postalCode)
Employee (employee ID, name, surname, position, gender, salary, officeID)
For rentMulk (estateD, street, city, postalCode, type, number of rooms, rent, estateOwnerID, employeeID, officeID)
Customer (customerID, name, surname, tel, maxrent)
estateOwner (estateHeaderID, name, surname, address, tel)
estateshow (customerID, estateID, showTime, comment)
Record (customerID, officeID, employeeID, recordDate)

Firstly, determine the appropriate primary key for each relationship. Then create the appropriate queries using relational algebra and SQL.

List the ID, street, city and rent information of the properties managed by the employees in the office located on "Fifth Street" street.
List all the cities with offices but no rental properties.
List the names and comments of all customers who have viewed a rental property.
List the first and last names of all customers viewing three-room properties.
List customers who are registered customers who have never had a property display.

Expert Solution