An IT company has a small library of books on computing that its employees are able to borrow. When a particular book is on loan then employees are able to reserve it. Figure 1 gives the E-R model for the library. Entity-relationship diagram Borrows 0..1 0..* Employee Book Reserves 0..* 0..* Entity types Employee (StaffNo, Name) Book (BookNo, Title, Author) Additional constraints c.1 Each employee is identified by a number that takes a value in the range 001 to 999. c.2 Each book is identified by a code that takes a value in the range B001 to B999. c.3 An employee may not reserve a book that he or she is currently borrowing. Limitations 1.1 Only current loans and reservations are recorded. Figure 1 The E-R model for the library (b) When an employee leaves the IT company their details are removed from the database. (i) Explain why using an SQL DELETE statement to remove the row in the employee table that corresponds to the departed employee may not always succeed