question archive Consider the following relationships in a sales department database: - Product (Product code, Product label, Stock Quantity) - Customer (Customer No, CustomerName, Address) - Order (NoOrder, DateOrder, # NoClient) - OrderLine (# OrderNo, # ProductCode, Quantity) Express, in relational algebra, the queries allowing to obtain: 1
Consider the following relationships in a sales department database: - Product (Product code, Product label, Stock Quantity) - Customer (Customer No, CustomerName, Address) - Order (NoOrder, DateOrder, # NoClient) - OrderLine (# OrderNo, # ProductCode, Quantity) Express, in relational algebra, the queries allowing to obtain: 1
Subject:MathPrice: Bought3
Consider the following relationships in a sales department database:
- Product (Product code, Product label, Stock Quantity)
- Customer (Customer No, CustomerName, Address)
- Order (NoOrder, DateOrder, # NoClient)
- OrderLine (# OrderNo, # ProductCode, Quantity)
Express, in relational algebra, the queries allowing to obtain:
1. the Customer numbers of customers who ordered only the product with product code "P17"
(excluding any other product).
2.NoClient of customers who ordered exactly the same products as the customer of
NoClient "25".
