a textual and graphical representation of the main data elements, relationships, and constraints.
determine where relationships and dependency is within the data
the first stage in the database design process.  the goal at this stage is to design a database that is independent of database software and physical details.