Posts

DBMS lab record Degree

  SQL EXPERIMENTS:- 1. Aim: The marketing company wishes to computerize its operations by using the following tables. producers:- 1.1. Create Table: `CLIENT_MASTER` and Insert Values CREATE TABLE CLIENT_MASTER (     CLIENT_NO VARCHAR2(6) PRIMARY KEY,     NAME VARCHAR2(20) NOT NULL,     ADDRESS1 VARCHAR2(30),     ADDRESSS VARCHAR2(30),     CITY VARCHAR2(15),     PINCODE VARCHAR2(8),     STATE VARCHAR2(15),     BAL_DUE NUMBER(10,2) ); INSERT INTO CLIENT_MASTER VALUES ('C001', 'Rajesh', 'Street 1', 'Apartment 10', 'Mumbai', '400001', 'Maharashtra', 1500.50); INSERT INTO CLIENT_MASTER VALUES ('C002', 'Amit', 'Sector 9', 'Block A', 'Bangalore', '560001', 'Karnataka', 500.00); INSERT INTO CLIENT_MASTER VALUES ('C003', 'Priya', 'Main Road', 'House 22', 'Chennai', '600001', 'Tamil Nadu', 1200.75...
Recent posts