Description
Question 1 carries 20 marks with each query given equal weightage (1 mark). Question 2 carries 5 marks with each query given equal weightage (1 mark). No partial marks for any questions.
- Implement the backend connectors (some references: [1 ], [2 ]) for the E-Commerce database created in Assignmen t 1. Ensure that inpu t sanitization (reference: [3 ]) checks are performed before the query is executed on the database. Submit a method definition for Questions 1-20 of the SQL queries implemented in Assignment 1.
- Write the tuple relational calculus and the domain relational calculus queries for the following:
- List all electronics products in the price range 10k-20k.
- Find email addresses of all the users who reside in the city ‘Mumbai’ and have made a total purchase greater than or equal to Rs. 5000 in the past.
- List all books published after 2001.
- List all products that were added to the database after 27/07/2019.
- List all retailer ids whose products, userid = 55 has purchased.
