Prescription

ID

Pharmacist

1

Worsely

2

Phillips

 

Prescription

ID

Item code

Description

1

G452

Aspirin 75 mg

1

H223

Warfarin 10 mg

1

D231

Diamorphine 10 mg

1

P1128

Pemoline 20 mg

2

A7584

Oxytetracycline 250 mg

Composite key = Prescription id + item code