I have one more question about ERD. The ERD I am working on is the one using the symbols SQUARE = Entity, DIAMOND = Relationship and Oval = Attributes...etc.

I wish to know do you have to design this diagram with normalization in mind or can you simply draw the schema using broad or generally named entities without thinking about data redundancy ? Or how else should it be approached ? Thank you.