Satyam Tiwari

Search This Blog

Satyam Tiwari

January 16, 2021

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

SQL LAB 2 (2.1 - 3.9)

SQL QUREIES Make the combination of DNO and PRJ_NO as primary key in the table PROJ. ALTER TABLE PROJ ADD PRIMARY KEY(DNO,PRJ_NO); Add a column to EMP table named PRJ_ID . Add a foreign key constraint to EMP table on (DeptNo, Proj_Id) referencing PROJ . ( Indicates an employee from which department is working on which project/s .) ALTER TABLE EMP ADD PRJ_ID varchar2(5); ALTER TABLE EMP ADD FOREIGN KEY(DEPTNO,PRJ_ID) REFERENCES PROJ; Add constraints(VALID_EMPNO_Cons) to the EMP table to check the EMPNO >...

Satyam Tiwari

OS_LAB WEEK 4

shell scripting week 4 1) File-related commands: Test the function of each of the following. a) File permissions: – r, – w, – x #!\bin\bash echo "enter the file name" read file if [ -r $file -a -w $file -a -x $file ] then echo "file is readable ,writable and excutable" elif [ -w $file -a -r $file ] then echo "file is writeable and readable" elif [ -x $file -a -w $file ] then echo "file is excutable and writable" elif [ -r $file -a -x $file ] then echo "file is readable and excutable" elif [ -r $file ] then echo "file is readable" elif [ -w $file ] then echo "file is writeable" elif [ -x $file ] then echo "file is excutable" else echo "entered file does not exist" fi b) File existence: – f, – d, – e, – s #!\bin\bash echo "enter the n...

Powered by Blogger