Question 1: Create an E R diagram and relational schema to hold information about Situation in many institutions affiliated to some university, many teachers of different disciplines are teaching to many students enrolled in many courses offered by the university to the students through the institutions. Use concept of keys, aggregation, generalisation, cardinality etc. in proper way. Say the schema of respective entities is

• Teacher( T#, Tname, Tqual, Tsubject, Tcourse, Prog)
• Student(Roll#., Sname, Sage, Saddress, Scourse.Prog, Smarks)
• Teaches(T#, Roll# , Scourse, Prog ,University)
• erforma following queries in SQL using the given schema:
• Find details of Teachers who taught DBMS
• Find details of students who did MCA from IGNOU
• Find courses taught by T# 5078
• Find address of students whose marks are less than 50