(b)A 1:many relationship where the ‘many’ entity has non-obligatory participation.
(c)A 1:1 relationship where both entities have non-obligatory participation.
(ii)A relationship identifier is usually formed by combining the associated entity
identifiers, but may occasionally require additional attributes.
(iii)A relationship identifier may differ from the associated row identifier.
Questions
1.Company employees may optionally be members of the company’s sports club. An
employee is identified by an employeeNo and a sports club member is separately
identified by a membershipNo. Draw up a skeleton E-R model showing the
relationship between entity types ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.