The Area being Modelled is :-
Subject: Database Design for a podiatry clinic

Question: I am designing the base tables (Oracle) for a Podiatry clinic and I am in
need of some assistance around the design of the assessments.

The way podiatry assessments work are that there are 5 different types of assessments;
4 are only done once per client and 1 can take place mulitple times (i.e follow-up assessment).

I have designed a one-to-many relationship between clients and assessments, however given there
are 5 different types of assessments, this table is becoming very large.

Ideally I would like to have each different type of assessments in one table as there are various
data columns which are only associated with a particular assessment.

Is there a way which this can be done by way of storing various templates or by altering the design?

Any help would be much appreciated.