DAO CONNECTIVITY (VB)













Comments

Post a Comment

Popular posts from this blog

DBMS Lab Cycle 4 (sailor,boat,reserve)

Image
Create the following tables and execute the queries given below sailor boat reserve CREATE TABLE sailors( sid NUMBER(3), sname varchar2(100), rating NUMBER(2), age NUMBER(3), PRIMARY KEY(sid) ); INSERT INTO sailors VALUES(22,'Dustin',7,45); INSERT INTO sailors VALUES(29,'Brutas',1,33); INSERT INTO sailors VALUES(31,'Luber',8,55); INSERT INTO sailors VALUES(32,'Andy',8,25); INSERT INTO sailors VALUES(58,'Rusty',10,35); INSERT INTO sailors VALUES(64,'Horatio',9,35); INSERT INTO sailors VALUES(71,'Zorba',10,16); INSERT INTO sailors VALUES(74,'Horatio',9,35); INSERT INTO sailors VALUES(85,'Art',3,25.5); INSERT INTO sailors VALUES(95,'Bob',3,63.5); CREATE TABLE boats( bid NUMBER(3), bname VARCHAR2(50), color VARCHAR2(25), PRIMARY KEY(bid) ); INSERT INTO boats VALUES(101,'Interlake','Blue'); INSERT INTO boats VALUES(102,'Inter...
Read more

DBMS Lab Cycle 6 (client_master, product_master, salesman_master, sales_order, sales_order_details)

Image
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...
Read more

DBMS Lab Cycle 5 (employee,department,project,works_in)

Image
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...
Read more