any practices ,samples for ERD?

Question

Q:

I want any web sites or books just for training on ERD and normalization. I want a lot of sample, practices, and case studies with recommended answers, to strengthen my skill in database design and avoid the poor database designs I've made.

Note: I don't need books to explain the concepts, what I need is practices, examples, and case studies with recommended answers.

Thanks in advance.

Answer 1

I would consider Object Role Modelling over ERM using NORMA or some such.

There is small group on linkedin about ORM, as well a short discussion over on dbaspot.

For normalization, I'd start with Wikipedia and then search

Answer 2

Database Design Using Entity-Relationship Diagram by Sikha Bagui and Richard Earp should be a good starting point.

The Database Management System lecture series, published by the Indian Institute of Technology (IIT), is another good resource.