(Solved): Given below is a small DB schema covering student enrollments in university programs, with primary ...

Given below is a small DB schema covering student enrollments in university programs, with primary keys underlined and foreign keys listed to the right. Below that are four questions for each type of calculus (two of the questions are shared). Try to answer all of the questions for each language before consulting any of the answers on the second page. Schema: Major is a FK to Dept in Program Dept is a FK to Abbrev in Dept TID is a FK to ID in Trainee; Dept-Num is a FK to Dept-Num in Program Tuple Relational Calculus - Express the following English queries in TRC: 1. What are the department abbreviations and titles of all programs numbered 301 ? 2. What are the IDs of the MATH Trainee taking "Principles of programming?" - For each of these TRC queries, what is the corresponding query in conversational English? 3. $$\{$$ T.Name, T.ID | Trainee $$(T)?$$ s.Major $$={}^{?}{\mathrm{CSC}}^{?}\}$$ 4. $$\{$$ e.Date $$?$$ Enroll $$(e)?(?p)($$ Program $$(p)?e$$. Dept $$=p$$.Dept $$?$$ e. Num $$=$$ p.Num $$?$$ p. Title $$=$$ 'Database Design')\}