Databases and Security

1. Design a database for a library where the entities are patron and book and the relationship is borrow. Create at least 4 attributes for patron, at least 3 attributes for book, and 1 attribute for borrow. Draw your design as an ER diagram.
2. Describe three threats to Internet privacy. For each state a possible (at least partial) solution. The solution might involve legislation, computer software, etc.
3. Describe an encryption scheme and use it to encrypt the following message:
   The semester is almost over
4. Explain the New Yorker cartoon passed out in class (you can find it on Google searching for New Yorker Internet Dog cartoon). Is the sentiment expressed true? Why or why not?