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 (ii) Describe how you could revise your solution to part (a) to enable an SQL DELETE statement to always remove an employee's details. 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 (ii) Describe how you could revise your solution to part (a) to enable an SQL DELETE statement to always remove an employee's details