Here are the slides on Database Design Methodology which are very heavily based on the Chapters from the Database book by Connolly & Begg.
This is really only a summary – you need to read the chapters on Conceptual, Logical and Physical design in the book.
Database Design slides