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 »