IGNOU MCS-023 Solved Assignment 3rd Semester Introduction to Database Management Systems Free Download

IGNOU MCS-023 Solved Assignment 3rd Semester Introduction to Database Management Systems

 

अगर आप इस पेज पर आये है तो आपको असाइनमेंट की जरुरत है ,यहां से आप सभी बुक्स डाउनलोड कर सकते है,हमारे पास सभी किताबे उपलब्ध है,

IGNOU की बुक्स यहां PDF  मे उपलब्ध, है अगर आपको असाइनमेंट नहीं मिला है तो नीचे दिए गए लिंक पर क्लिक कर के      डाउनलोड कर सकते है .

 

Course Code : MCS-023
Course Title : Introduction to Database Management Systems
Assignment Number : BCA(3)/023/Assignment/2019-20
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th October, 2019 (For July 2019 Session)
15th April, 2020 (For January 2020 Session)

IGNOU MCS-023 Solved Assignment 3rd Semester Introduction to Database Management Systems

 

Q2. (10)
Design the Relational Schema for the E-R diagram that you have drawn for part Question 1. The
relations must be at least in 2 NF. Perform the following on the relations:
a) Enter about 5 sets of meaningful data in each of the relations .
b) Identify the domain of various attributes.
c) Identify the Primary keys of all the relations.
d) Identify the Foreign keys and referential integrity constraints in

Q4. (10)
Given the relational schema:
ENROL (ENo, C_Id, Class) – ENo represents student number
TEACH (Prof, C_Id, Class) – C_Id represents course number
ADVISE (Prof, ENo) – Prof is project guide of ENo (Student’s enrol_no)
PRE_REQ (C_Id, Pre_C_Id) – Pre_C_Id is prerequisite course
GRADES (ENo, C_Id, Grade, Year)
STUDENT (ENo, SName) – SName is student name
Write SQL statements for the following :
(i) List all students whose project guide is Prof.Murthy.
(ii) List the grade for the student with ENo=1234
(iii) List those professors who teach more than one class.
(iv) List all the student names and ENo’s who got Grade A in the year 2018 in C_Id= 100.
(v) List all the students who has taken the pre-requisite course Pre_C_Id= 001

 

Click Here For Free

 

एग्जाम मे अच्छे मार्क्स लाने के लिए Study Material को ध्यानपूर्वक पढ़े .यहां दी गई सभी बुक फ्री मे Download होती है आपको किसी प्रकार का Registration करने की जरुरत नहीं है सिर्फ एक क्लिक मे बुक डाउनलोड हो जाएगी

IGNOU MCS-023 Solved Assignment 3rd Semester Introduction to Database Management Systems

सभी Latest Assignment, Question Paper , Study Material , Important Question यहां उपलब्ध है