Category DBMS Lab

VTU DBMS LAB Program 5 EMPLOYEE(SSN,NAME,ADDRESS,SEX,SALARY,SUPERSSN,DNO) DEPARTMENT(DNO,DNAME,MGRSSN,MGRSTARTDATE) DLOCATION(DNO,DLOC) PROJECT(PNO,PNAME,PLOCATION,DNO) WORKS_ON(SSN,PNO,HOURS) VTU DBMS LAB – Create Table SQL Commands for COMPANY Create the tables for all of the above attributes VTU DBMS LAB – Create Table for EMPLOYEE Table created Create…

VTU DBMS LAB Program 4 STUDENT (USN,SNAME,ADDRESS,PHONE,GENDER) SEMSEC (SSID,SEM,SEC) CLASS (USN,SSID) SUBJECT (SUBCODE,TITLE,SEM,CREDITS) IAMARKS (USN,SUBCODE,SSID,TEST1,TEST2,TEST3,FINALIA) VTU DBMS LAB Create Table SQL Commands for COLLEGE Create the tables for all of the above attributes VTU DBMS LAB -Create Table for STUDENT…

VTU DBMS LAB Program 3 ACTOR(ACT_ID,ACT_NAME,ACT_GENDER) DIRECTOR(DIR_ID,DIR_NAME,DIR_PHONE) MOVIES(MOV_ID,MOV_TITLE,MOV_YEAR,MOV_LANG,DIR_ID) MOVIE_CAST(ACT_ID,MOV_ID,ROLE) RATING(MOV_ID,REV_STARS) VTU DBMS LAB – Create Table SQL Commands for MOVIE Create the tables for all of the above attributes VTU DBMS LAB -Create Table for ACTOR Table created Create Tabel…

VTU DBMS LAB Program 2 SALESMAN(SALESMAN_ID,NAME,CITY,COMISSION) CUSTOMER(CUSTOMER_ID,CUST_NAME,CITY,GRADE,SALESMAN_ID) ORDERS(ORD_NO,PURCHASE_AMT,ORD_DATE,CUSTOMER_ID,SALESMAN_ID) VTU DBMS LAB -Create Table SQL Commands Create the tables for all of the above attributes Create Table for SALESMAN Table created. Create Table for CUSTOMER Table created Create Tabel for ORDERS…

VTU DBMS LAB PROGRAM 1 BOOK (BOOK_ID, TITLE, PUBLISHER_NAME, PUB_YEAR) BOOKAUTHORS(BOOK_ID,AUTHOR_NAME) PUBLISHER(NAME,ADDRESS,PHONE) BOOK_COPIES(BOOK_ID,BRANCH_ID,NO_OF_COPIES) BOOK_LENDING(BOOK_ID,BRANCH_ID,CARD_NO,DATE_OUT,DUE_DATE) LIBRARY_BRANCH(BRANCH_ID,BRANCH_NAME,ADDRESS) VTU DBMS LAB -Create Table SQL Commands Create the tables for all of the above attributes VTU DBMS LAB – Create Table for BOOK Create…