Element - Database Diagram

Elements from the IDEF1X notation are used for displaying database schema.1notation used. Database diagrams illustrate the foreign keys in the database schema. The foreign key columns' properties initially calculate how the foreign keys are displayed.

Icon

The icon is of a diagram with a key table in it.

Use

You can use the database diagram to model a submodel of the database schema.

Elements in a Database Diagram

The following model elements can be shown as nodes and edges in database diagrams:

Icon	Element	Description






	1:C
	1:MC
	1:M
	C:MC
	C:C

	M:M
	M:MC
	MC:MC
	Generalization	Generalization links two entities making one super and one sub. You can also talk about subordinate and superordinate entities.
	Key, ...

Example for a Database Diagram

Further Information

http://www.uml.org/