Tag VTU CSE 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 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…

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) 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…

WhatsApp Icon Join For Job Alerts