The same database in IDEF1X
In IDEF1X (notation idef1x) instead of crow's foot: the same tables and lines, a dot at the child end with P or Z, a hollow diamond at an optional parent, and dependent tables with rounded corners.
A bookshop's database: customers, their orders and order lines, the books and their authors, and payments, as seven tables related by their foreign keys, in crow's foot notation. The page below opens on it, A bookshop's database, live: pan, zoom, select and go into the cards that stack.
In the order you find them in the picture:
present rows)present collapsed columns)The same example, where a setting cannot share the picture above:
In IDEF1X (notation idef1x) instead of crow's foot: the same tables and lines, a dot at the child end with P or Z, a hollow diamond at an optional parent, and dependent tables with rounded corners.