Database Exercise 2

Consider the following relational schema of the company's database. Use Tuple Relational Calculus (TRC) & Domain Relational Calculus (DRC) expression to answer each of the following three questions (Step by step brief description is appreciated if possible)

Question 1: Find the number of orders for products that are being ordered in quantities smaller than 100 items by customers living in Madrid. Provide solutions expressed both in relational algebra as well as in relational calculus.

Question 2: Find the names and addresses of customers that order products for which there is no stock. Provide solutions expressed both in relational algebra as well as in relational calculus.

Question 3: Find the cities where customers who do not order any product supplied by AB live. Provide solutions expressed both in relational algebra as well as in relational calculus.

Academic Honesty!
It is not our intention to break the school's academic policy. Posted solutions are meant to be used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly complete the form. Please provide a valid email address and we will get back to you within 24 hours. Payment is through PayPal, Buy me a Coffee or Cryptocurrency. We are a nonprofit organization however we need funds to keep this organization operating and to be able to complete our research and development projects.