Transforming an E-R Model

• Case 7: 1:M, One side OPTIONAL, many side MANDATORY

BAND (BAND_ID, BAND_NAME, MUSIC_TYPE...)

MUSICIAN (MUSICIAN_ID, MUSICIAN_INSTRUMENT, … BAND_ID)

BAND

MUSICIAN

accepts

1

M

Previous slide

Next slide

Back to first slide

View graphic version