Transforming an E-R Model

• Case 6: 1:M, Many side OPTIONAL, one side MANDATORY

MACHINE (MACH_ID, MACH_NAME, MACH_DEPT, ...)

PART (PART_ID, PART_NAME, PART_CATEGORY, …, MACH_ID)

MACHINE

PARTS

contains

1

M

Previous slide

Next slide

Back to first slide

View graphic version