a. The table given beside has three attributes A,B and C where A is the primary key and C is a foreign key referencing A with on-delete cascade. Which tuples must be additionally deleted to preserve referential integrity when the tuple (3,4) is deleted? b. Give an example of binary recursive relationship where a single entity participates with two roles. c. Discuss drawbacks of conventional file processing systems. d. An organization has following rules: (i) Each employee works for a particular department or more than one departments, (ii) Many employees can work in a single department, (iii) There can be departments where no employees work. Show the structural constraints between entities EMPLOYEE and DEPARTMENT through ER diagram using Min-Max representation and Crow's foot notation. e. When the output of natural join produces maximum cardinality? What is the arity of output of natural join? a. The table given beside has three attributes A,B and C where A is the primary key and C is a foreign key referencing A with on-delete cascade. Which tuples must be additionally deleted to preserve referential integrity when the tuple (3,4) is deleted? b. Give an example of binary recursive relationship where a single entity participates with two roles. c. Discuss drawbacks of conventional file processing systems. d. An organization has following rules: (i) Each employee works for a particular department or more than one departments, (ii) Many employees can work in a single department, (iii) There can be departments where no employees work. Show the structural constraints between entities EMPLoYEE and DEPARTMENT through ER diagram using Min-Max representation and Crow's foot notation. e. When the output of natural join produces maximum cardinality? What is the arity of output of natural join