Jubilant, Recently Asked Online Assessments in 1 Nov, 2025 | Python Inventory System | SQL Session Detection

Question 1: Python: Inventory Management System Problem Statement: Design a system to handle inventory management and track sales transactions, including the following functionalities: 1. Database and Tables: There is an in-memory SQLite database with two tables: products and sales. products: product_id: INTEGER, PRIMARY KEY name: TEXT price: REAL stock: INTEGER sales: sale_id: INTEGER, PRIMARY KEY product_id: INTEGER quantity_sold: INTEGER 2. Function Description: add_product(product_id, name, price, stock): Adds a product to the products table with the specified ID, name, price, and ...