Tools I've used for DB Design include: pen & paper, pencil & paper, Marker & Whiteboard, Visio and Excel. And yes, it generally includes PKeys, FKeys & Indexes. Sometimes sample items won't include keys and indexes because they are usually isolated sample items, and the code is the important part, not the database.

-tg