Hello

Can anyone explain me with details that what's the difference between ER-Diagram & Database Diagram.
In ER-Diagram we mention Entity,Attributes with Relationship that's fine.what we do in Database Design Diagram??

A database design diagram would show Tables, Columns and Foreign Keys. It represents the tables actually (to be) used, whereas the ERD shows the data requirements (from analysis).

@ Andrewst

Thanks for your Reply.One more thing in DB Design Diagram we also shown relationships or not.? If yes just same as we show in ER-Diagram

The foreign key links represent relationships between tables.