Question: 10- Given below is a small DB schema covering student enrollments in university courses, with primary keys underlined. What is the corresponding Domain Relational Calculus

10- Given below is a small DB schema covering student enrollments in university courses, with primary keys underlined. What is the corresponding Domain Relational Calculus query in conversational English? Q:{i[(ag) (Dept (ghi) AND (ade) ( Course (def) AND gd AND d="MATH' AND e=243)} Q:{i|(38) (Dept (ghi) AND (3de) ( Course (def) AND g=d AND d="MATH' AND e=243 )] e b C Student ID Name Major Major is a FK to Dept in Course d Course Dept Num Title Dept is a FK to Abbrey in Dept. h 1 Dept Abbrev Name Office 2 SID is a FK to ID in Student: Enroll SID Dept Num Date Dept-Nuun is a FK to Dept-Num in Course b) a) Retrieve all the course information (Dept, Num, Title) of MATH 243 Which department opens the MATH 243 course? Which office should we go to ask about MATH 243 ? d) Retrieve all the department information (Abbrev, Name, Office) of MATH 243 Leave blank c)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
