The relational schema is given at top of page. Keys are underlined in schema. Please show how to write a and b major: SmngTakes (cidisting, Cid: Sting, grade : mng)Courses (cidistring, HtHe:...

The relational schema is given at top of page. Keys are underlined in schema. Please show how to write a and b
Studentr (sid: inteyer, mame : String> major: Smng<br>Takes (cidisting, Cid: Sting, grade : mng)<br>Courses (cidistring, HtHe: Shing)<br>*keyr underlined *<br>a) Wite the fullaning query in rclational<br>algubra.<br>Find the names of the students who<br>ace enrolled in csC41 but not in<br>CSC414<br>are the values of the attrbute tit|e<br>in the courses relation.<br>where Cse4i' and'Ĉ sC419)<br>G.<br>Wite query in relutional alyebra :<br>Find the names of the stucdents who are<br>envolled in both 'CsC4' and 'CSC414, uhere<br>CSC411 and CSC 414 are the valles<br>of the attialte hne inthe Courses rdation.<br>TÜL<br>

Extracted text: Studentr (sid: inteyer, mame : String> major: Smng Takes (cidisting, Cid: Sting, grade : mng) Courses (cidistring, HtHe: Shing) *keyr underlined * a) Wite the fullaning query in rclational algubra. Find the names of the students who ace enrolled in csC41 but not in CSC414 are the values of the attrbute tit|e in the courses relation. where Cse4i' and'Ĉ sC419) G. Wite query in relutional alyebra : Find the names of the stucdents who are envolled in both 'CsC4' and 'CSC414, uhere CSC411 and CSC 414 are the valles of the attialte hne inthe Courses rdation. TÜL

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here