Tag Archives: SQL

Answer the following queries in SQL – IGNOU MCA Assignment 2015 – 16

MASTER OF COMPUTER APPLICATIONS Course Code : MCS-023 Course Title : Introduction to Database Management Systems Assignment Number : MCA(II)/023/Assignment/15-16 Maximum Marks : 100 Weightage : 25%   Consider the following EMP table: ENAME DEPT-NAME DESIGNATION SALARY DATE-OF-JOIN KARAN ACCOUNTING DIRECTOR 50000 Nov 17, 2012 FARAH RESEARCH ANALYST 30000 Dec 03, 1991 SCINDIA RESEARCH ANALYST… Read More »

Answer the following queries in SQL – IGNOU MCA Assignment 2014 – 15

MASTER OF COMPUTER APPLICATIONS Course Code : MCS-023 Course Title : Introduction to Database Management Systems Assignment Number : MCA (2)/023/Assign /2014-15 Maximum Marks : 100 Weightage : 25%   We have following relations: Supplier(S#,sname,status,city) Parts(P#,pname,color,weight,city) SP(S#,P#,quantity) QUERY for Creating S table: CREATE TABLE S (S_No CHAR (5) NOT NULL, SNAME CHAR (20) NOT NULL,… Read More »