GRADE EVALUATION





Comments

Post a Comment

Popular posts from this blog

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

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