Question
Perform the following tasks using relational algebraic operations for the relations created at part
- List all the courses of MCA programme.
- Find the student name, programme code and the programme duration of the programme in which s/he is registered.
- Find the list of students in BCA programme.
Answer :
Word Count : 73
___ _____ _____ ___ _________ ___ ______ _____ ________ _____ ____.
______ ______ ______ _______ ___ _____.
____ __________ _______ _______ _________.
___ _______ ______ ______ ________ ___ _______ _____.
_____ __________ _______ _________ ______ __________ _________.
______ _____ ___ ________ _______ _________ ______ _________ _______.
____ ________ _____ ______ __________.
______ _____ ____ _________ ______ _________.
Skip in 10
PROGRAM (course_id, course_code, course_name, course_title)
STUDENT (student_id, name, address, deptt)
LECTURES (lectures_id, student_id)
(PK) = Course_id
______ ______ ______ _______ ___ _____.
____ __________ _______ _______ _________.
___ _______ ______ ______ ________ ___ _______ _____.
_____ __________ _______ _________ ______ __________ _________.
______ _____ ___ ________ _______ _________ ______ _________ _______.
____ ________ _____ ______ __________.
______ _____ ____ _________ ______ _________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.