Consider the following queries to be addressed to the Northwind database. Write in relational algebra queries (a)–(g) and in SQL all the queries. (a) Name, address, city, and region of employees. (b)...

Consider the following queries to be addressed to the Northwind database. Write in relational algebra queries (a)–(g) and in SQL all the queries. (a) Name, address, city, and region of employees. (b) Name of employees and name of customers located in Brussels related through orders that are sent by Speedy Express. (c) Title and name of employees who have sold at least one of the products “Gravad Lax” or “Mishi Kobe Niku.” (d) Name and title of employees as well as the name and title of the employee to whom they report. (e) Name of products that were sold by employees or purchased by customers located in London. (f) Name of employees and name of the city where they live for employees who have sold to customers located in the same city.

Dec 09, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here