$($b$)$ Consider the following conceptual data model diagram which depicts the

'Doctor Treats Patient' relationship.

$($i$)$ The above diagram is part of a larger conceptual data model for a

database system for a General Practice $($GP$)$ surgery. The surgery

employs several doctors who provide general medical treatment for

patients registered with the practice.

Copy the diagram and add the multiplicity constraints, including both

the participation and cardinality constraints. State any two

assumptions you have made in determining the constraints.

$[4$ marks$]$

$($ii$)$ Map your diagram from $($i$)$ to a logical data model for a relational

database showing all primary keys and foreign keys.

$[6$ marks$]$