4. Consider the following relational schema: Student (roll, name, mob, cgpa, city, age) Faculty ( fid, fname, doj. salary, specialization) Teach (fid, roll, sem) Domain (specialization, subject) Primary keys are underlined. Solve the following queries using the relational calculus. [ [1x] a. Find the students whose cgpa >8.0 and staying at 'BBS'. b. Find the faculty manes who are teacing in 4th semester. c. Find the faculty names who are teaching to the 'BBS' students. d. Display the students' names and rolls who are taugt by all faculty members. e. Find the faculty names who are teaching to the 'BBS' students and teaching 'DBMS' subject. 5 . a. There are different organizations available for which we are interested to store the unique orgid along with orgname and domain. Each organization is conducting one annual fest (unique festid, festname, budget and theme) in each session. Many people are coming to the annual fest. Each person has unique prid along with prname, age and contact(s). The people can be categorized as either Employee (with salary) or Student (with cgpa) or Staff (with working_hours). Employees are managing Students. Similarly, Staffs are managing Students. Each annual fest contains many events (identified by unique evid along with evname and category). The students are participating in one or more events. Similarly, many students are participating in an event. There are different students treated as event managers for different events. Each event contains different rewards. Each reward has a rewardname and prize. Each reward can be identified by rewardname once the event is known. Draw the entity-relationship diagram for the above system. Make necessary assumption. [3 Marks] b. Convert the above ER diagram into relational schemas and specify primary and foreign keys. [2 Marks]