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…
5. COMPANY DATABASE VTU DBMS LAB | Direct SQL Code
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 -…
4. COLLEGE DATABASE VTU DBMS LAB | Direct SQL Code
VTU DBMS LAB Program 4 STUDENT (USN,SNAME,ADDRESS,PHONE,GENDER) SEMSEC (SSID,SEM,SEC) CLASS (USN,SSID) SUBJECT (SUBCODE,TITLE,SEM,CREDITS) IAMARKS…
3. MOVIE DATABASE VTU DBMS LAB | Direct SQL Code
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 -…
2. ORDER DATABASE VTU DBMS LAB | Direct SQL Code
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…
1. LIBRARY DATABASE VTU DBMS LAB | DIRECT SQL CODE
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)…