hi there i am doing an assignment about denormalisation and am unable to find much about it and was wondering if any1 knew something about it. i also need to find the drawbacks and benefits of denormalisation

When you normalize a database down to third normal form it may be necessary for performance reasons or to accomodate the database management system being used to denormalize certain relationships.

Denormalization is also a technique used in creating dimensional data warehouses.

I recommend reading Kimball's books on the topic of data warehouse design and development to learn more about denormalization.

sorry will try and find out for you...

You could obtain this paper, at a modest cost:

http://www.dbdebunk.com/page/page/1103793.htm