Categories
Uncategorized

DBMS Query

CIA 1 and 2 Tables to be used: student (student_id, sname,deptno,dob,email) colldept(deptno, dname,hod) faculty(facultyid,fname, deptno,designation, salary) employee(empid, name,job hiredate,salary,deptno,mgrid,age) department(deptno,dname,loc)