A database diagram is the very foundation of a database design and development effort. It represents the basic structure of a database; how information is stored, categorized and managed within it. A typical database diagram consists of entities, attributes, and relationships.