Posts

DBMS Practical Questions

Image
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, '...