5th Sem CSE VTU DBMS LAB Programs | ALL IN ONE

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)

CHECKOUT

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)

CHECKOUT

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)

CHECKOUT

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)

CHECKOUT

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)

CHECKOUT

Leave a Reply

Your email address will not be published. Required fields are marked *

WhatsApp Icon Join For Job Alerts