A little help with my database structure?

[riechan]

First off, sorry about the image size.

Hi guys. I was wondering if you could give me a hand in making my database structure normalized.

As you can see, I made three database designs here for a Library Management System. Ver 0.5 being the most simplest among the three, and 0.7B being the most (I think) complex.

My questions are, aside from asking for help to get my database structure normalized:

1. What can you suggest in the structure of the Patron entity. I want the Patron entity to exist in such a way that I can "combine" the Student and Faculty into a single entity just like in v0.5. The problem is, regarding the year and section of the student, and the department of the faculty member. I thought that, maybe we could simply just place those information into the Remarks field - then again, what if the user was supposed to look for a student from section XX, or a faculty member from department YY? So, I made v0.7B, separating the Student and Faculty entities and connecting them into a joint table, Patron. I think that this made it a little more complex than I had initially imagined, so I asked my professor to help me on the database design. She told me to create a table that will determine what kind of Patron that patron is (meaning, create a PatronType table and connect it to Patron table, as seen in v0.7). So, which one do you think is the best? 0.5, 0.7 or 0.7B? Or do you have a better idea in mind?

2. Is there anything wrong with the FKs in accordance with the relationships? I have to admit that it's been awhile since I last worked with Entity Relationships, so I'm not so confident.

If you guys have any questions regarding my topic, please feel free to ask. And thanks in advance to everyone who'll try to help.