any practices ,samples for ERD?

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.

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

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.

I think the Database Programmer blog is worth reading. It's got some nice stuff on normalization, but I'm sure any tutorial that Google brought back would be sufficient.