TestBook-Practice Test Database

Question

Consider the following schema for employees of a university database:

create table rep_manager

(emp_name char(20),

rep_manager_name char(20),

primary key emp_name,

foreign key (rep_manager_name) references rep_manager on delete cascade )

Here, table rep_manager consist of n records. Every employee in the university reports to some other employee for administrative purposes except the chancellor. For example, the dean reports to the chancellor, University professor reports to Dean and so on. How many records will remain in a table rep_manager after deleting the instance of Dean?

Comments

Shaik Masthan

it is not given that some people directly report to the chancellor here in the question, So the answer should be 1.

But it may be the case then answer will be greater than 1.

---

@kumar.dilip what if suppose a person reports to the registrar and registrar does not report to dean.. So it would also be not deleted na.... like when we dont know what all is there so how can we predict the ans ??

---

@Shaik Masthan  @anjali007 

"For example, the dean reports to the chancellor, University professor reports to Dean and so on"

From this line I inferred that they have given the order of reporting hierarchy wise so I assumed that all professors will be reporting to dean, staff under professor will be reporting to professor and so on.