Tag Archives: Assign /2014-15


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 »

Entity Relationship ER diagram for a Banking System – 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%   Construct an ER diagram for a Banking System. Clearly indicate the entities, relationships, cardinality and the key constraints. Also, derive the un-normalized relational database tablesā€¦ Read More »