RASHTRASANT TUKADOJI MAHARAJ NAGPUR UNIVERSITY, NAGPUR BOARD OF COMPUTER APLICATION BACHELOR OF COMMERCE (COMPUTER APPLICATION) (BCCA) PRACTICAL LIST PRACTICAL – I (COMPONENT – II) Course: BCCA – II (Semester – III) Subject: Database Management System List for Oracle Practical (SQL) 1. Create the following tables. Table Name : - CUST FIELDS CUST_ID L_NAME F_NAME AREA PHONE_NO DATA TYPE VARCHAR2(3) VARCHAR2(15) VARCHAR2(15) VARCHAR2(2) NUMBER(8) CONSTRAINT NOT NULL DATA TYPES NUMBER(2) VARCHAR2(25) VARCHAR2(10) VARCHAR(25) NUMBER(8,2) CONSTRAINT NOT NULL DATA TYPES VARCHAR2(3) NUMBER(2) VARCHAR2(3) DATE DATE CONSTRAINT NOT NULL Table Name : - MOVIE FIELDS MV_NO TITLE TYPE STAR PRICE Table Name: - INVOICE FIELDS INV_NO MV_NO CUST_ID ISSUE_DATE RETURN_DATE 2. Insert the following data into the created tables. Table Name : - CUST CUST_ID A01 A02 A03 A04 A05 A06 L_NAME BHIMA SAWAI JAISWAL NEWARE SREEDHARAN F_NAME ISHWAR VIJAY PRAMOD BASU RAVI RAJESH AREA SA MU DA BA VA GH PHONE_NO 6125467 5560379 4563891 6125401 5125274 RASHTRASANT TUKADOJI MAHARAJ NAGPUR UNIVERSITY, NAGPUR BOARD OF COMPUTER APLICATION BACHELOR OF COMMERCE (COMPUTER APPLICATION) (BCCA) PRACTICAL LIST PRACTICAL – I (COMPONENT – II) Course: BCCA – II (Semester – III) Subject: Database Management System Table Name : MOVIE MV_N O 1 2 3 4 5 6 7 8 9 10 TITLE TYPE STAR PRICE BLOODY VENGENCE THE FIRM PRETTY WOMEN HOME ALONE THE FUGITIVE COMA DRACULA QUICK CHANCE GONE WITH THE WI ...
Purchase document to see full attachment