Transforming an E-R Diagram
Converting an E-R Model into a Database Structure
- A painter might paint many paintings. The cardinality is (1,N) in the relationship between PAINTER and PAINTING.
- Each painting is painted by one (and only one) painter.
- A painting might (or might not) be exhibited in a gallery; i.e., the GALLERY is optional to PAINTING.