Answered step by step
Verified Expert Solution
Link Copied!

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]

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions