
Questions
1. Decide on plausible participation conditions for the entity types in each of the
following: (2 min)
Entity types Relationship
(a) House, Person Ownership
(b) House, Tenant Occupation
(c) Order, OrderLine Contains (An order may contain
several order-lines, each referring to
a different item on the order.)
(d) SalesArea, Customer HasAssigned
(e) BankClient, ClientAccount Possesses
(f) Employee, Skill Has
2. Draw an entity-relationship type diagram and a sample entity-relationship
occurrence diagram for each part of question 1. Represent each entity occurrence by a
dot. There is no need to show entity identifiers. (5 min)
3. What practical difficulty ...