As per Phoebe's request to post the answers in my livejournal:
1) a) there are no keys
b) how could it be lossless if all the letters are still there?
c) 3NF decomposition - IC ECR EAMIS YUM MY
d) yes

2) Our friend the db designer is nuts. He was completely wrong on
homework 1, he was completely wrong on the midterm, so why should
he suddenly know what he's doing?

3) java.lang.NullPointerException: No textbook found.