Hi guys, I'm not so sure if my question is supposed to be placed in this section of the forums, so please move it as needed. Anyway, my question is about whether this database that I'm working on is already normalized. It's about a library borrowing system...

*PK - Primary Key; FK - Foreign Key... just a heads-up note

[Book Table]
CallNum (PK)
BookTitle
ISBN
Description
Subject
CopyQty
ClassNum(FK)
AuthorID(FK)

[Author Table]
AuthorID(PK)
AuthorLname
AuthorFname

[Publisher Table]
PublisherID
PublisherName -- the company name
ContactAddress
ContactNumber
ContactEmail

[Class Table] -- classification, eg: psychology, mathematics, etc.
ClassNum (PK)
ClassName
ClassDescription

[Subclass Table]
SubclassNum (PK)
SubclassName
SubclassDescription
ClassNum (FK)

[Patron Table] -- the table for users of the library...(?)
PatronID (PK)
LName
FName

[Borrowed_Books Table]
PatronID (PK)
CallNum (PK)
WithdrawDate
ReturnDate

Some more info, the database is for a high school company, so it's a bit compact, and it only processes books, not other articles, like magazines, newspapers and other stuff. Also, I'm going to use SQL Server 2000 for this. I'll be posting the ERD for the database as well in my later posts.

It would be very kind of you to help me point out errors in this database, and help me normalize it as well. Thanks much~!

Rie