What is a good Entity-Relationship diagram building tool for occasional usage?
Freeware is a plus.
Why should it be good enough for occasional usage?
You can use StarUML with the ER extension. It is totally free, stable and easy to learn.
Update: 09.10.2017: StarUML is not free anymore!