wEbmAstEr powered by AJK Pvt Ltd

CREATE THE FOLLOWING TABLES AND INSERT THE VALUES client_master product_master salesman_master sales_order sales_order_details CREATE TABLE client_master( client_no VARCHAR2(10), name VARCHAR2(50), city VARCHAR2(40), pincode NUMBER(6), state VARCHAR2(40), bal_due NUMBER(9,2), PRIMARY KEY(client_no) ); INSERT INTO client_master VALUES ('C00001','Anup Dalal','Mumbai',400054,'Maharashtra',15000); INSERT INTO client_master  VALUES ('C00002','Vandana Srivastava','Chennai',600018,'Tamil Nadu',0); INSERT INTO client_master  VALUES ('C00003','Kaustubh Khare','Mumbai',400056,'Maharashtra',5000); INSERT INTO client_master  VALUES ('C00004','Ashok Agarwal','Mumbai',400057,'Maharashtra',0); INSERT INTO client_master  VALUES ('C00005','Vivek Misra','Delhi...

Create the following tables employee department project works_in CREATE TABLE employee( ssn NUMBER, ename VARCHAR2(40) NOT NULL, desig VARCHAR2(20), dno NUMBER, doj DATE, salary NUMBER, PRIMARY KEY (ssn) ); CREATE TABLE department( dnumber NUMBER, dname VARCHAR2(20), loc VARCHAR2(40), mgrssn NUMBER REFERENCES employee(ssn), PRIMARY KEY(dnumber) ); ALTER TABLE employee ADD FOREIGN KEY (dno) REFERENCES department(dnumber); CREATE TABLE projetc( pnumber NUMBER, pname VARCHAR2(20), dnum NUMBER REFERENCES department(dnumber), PRIMARY KEY(pnumber) ); CREATE TABLE works_in( essn NUMBER REFERENCES employee (ssn), pno NUMBER REFERENCES project(pnumber), hrs NUMBER, PRIMARY KEY(essn,pno) ); INSERT INTO department (dnumber,dname,loc)  VALUES (1,'Admin','Banglore'); INSERT INTO department (dnumber,dname,loc)  VALUES (2,'RMG','Kochi'); INSERT INTO department (dnumber,dname,loc)  VAL...

Click to download the apk

SET-I   Create the table student with fields  SID Sname, DOB, Physic, Chems, Maths. CREATE TABLE student( sid NUMBER(3), sname VARCHAR2(60), dob DATE, physics NUMBER(5,2), chems NUMBER(5,2), maths NUMBER(5,2), PRIMARY KEY (sid) ); Add few rows into the table INSERT INTO student VALUES(301,'Abraham Mathew','23-June-1996',75,87,37); INSERT INTO student VALUES(302,'Adharsh Sunny','29-April-1995',78,82,90); INSERT INTO student VALUES(303,'Anson Mathew','27-February-1997',65,31,88); INSERT INTO student VALUES(304,'Arun Joji','17-March-1994',38,55,60); INSERT INTO student VALUES(305,'Christin Chacko','03-May-1994',82,88,97); INSERT INTO student VALUES(306,'Dimal Mathew','21-December-1994',91,96,99); INSERT INTO student VALUES(307,'Jeethu Mathew','19-April-1993',77,83,40); INSERT INTO student VALUES(308,...