Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following schemas: Student(Enrno, name, courseld, emailld, cellno, department) Course(courseld, course_nm, duration, TID) Teacher (TID, TName) Write the following queries in relational algebra: [6]
Consider the following schemas: Student(Enrno, name, courseld, emailld, cellno, department) Course(courseld, course_nm, duration, TID) Teacher (TID, TName) Write the following queries in relational algebra: [6] i) Find out list of students who have enrolled in "computer" course. ii) List the details of all students who are doing their C++ course under "Prof. Shaktiram". iii) List email Id and cell no of all mechanical engineering students. Why multiple view of data is needed in DBMS? [4] [Assume data value iff it is missingeeded]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started