DBMS Practical Questions
Problem 1 -- client_master table CREATE TABLE client_master ( client_no VARCHAR(6), name VARCHAR(20), address VARCHAR(30), city VARCHAR(15), pincode NUMERIC(8), state VARCHAR(15), bal_due NUMERIC(10,2) ); -- Product_master table CREATE TABLE Product_master ( product_no VARCHAR(6), description VARCHAR(15), Profit_percent NUMERIC(4,2), Unit_measure VARCHAR(10), Qty_on_hand NUMERIC(8), Reorder_level NUMERIC(8), Sell_price NUMERIC(8,2), Cost_price NUMERIC(8,2) ); -- . Insert 5-6 records in each table. -- Inserting records into the client_master table INSERT INTO client_master VALUES ('C001', 'John Doe', '123 Main St', 'Mumbai', 123456, '...