VTU 5th semester Computer Science/Information Science and Engineering VTU DBMS LAB PROGRAMS Step by Step SQL executable code.
VTU DBMS LAB lab programs with all the queries solved.
Learn all the SQL operations using the below programs.
DBMS MYSQL Software – Download Now
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)
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)
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)
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)
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)
