The Student Room Group
from i remember on databse normalisation, you look for the things that are actually relevant, then split it accordingly.,

you tried google? before i even look at helping you/?
Principles of normalisation:
- Redundant data should be avoided
- Data should be consistent throughout database
- Structure should be flexible to suit people's needs
- Structure should allow complex queries to be made
- Many to many relationships should be avoided.

Bearing that in mind, I think the Appointments should have a different table, make sure they're linked sensibly with one-to-many relationships (one patient can have many appointments), and make sure you don't need to constantly re-enter all the details of patients.

Hope that sorta helps.
Reply 3
yeah i hav looked on google, but nothing seems to help.