...
- entities are represented by streams
- stream names should reflect the entity it represents
- attributes are represented by stream attributes
- a stream must have a unique identifier - its primary key
- a relationship:
- is usually between a primary key in one stream, and the same data being used in another stream, where it is a foreign key
- can be either one-to-one or one-to-many.
In PhixFlow, you can create a relationship diagram
- either by dragging in existing streams and then adding relationships
- or, as you add streams to the diagram, you can create the streams and their attributes.
Example
For example, a simple relationship diagram can represent a company and its employees. A company has attributes, such as a name, address, turnover. In a PhixFlow stream, a company must also have an attribute that identifies the company uniquely. A company also has employees. In a relationship diagram this looks like:
...