Exercise 1 Medical Clinic System A local medical practice have asked you to help design a simple database to track the costs of treating patients. Their manual system takes a long time to work out how...

Extracted text: Exercise 1 Medical Clinic System A local medical practice have asked you to help design a simple database to track the costs of treating patients. Their manual system takes a long time to work out how much they are spending. What do we need to be able to do? Record exact costs of treatments against each person Record name, description, and cost of a range of treatment types Track costs by treatment type Track costs by age Track costs by sex (A) Identify appropriate entities from the given exercise. (B) Draw the Entity Relation Diagram. (C) using Microsoft Access, produce the Tables, Report and Queries for tracking the treatment type, age and sex