Quote:
Is that right to make the patient table contains 60 coulmns or what i should do?
From SQL server point of view, 60 columns is not a problem at all.
Quote:
I'm a beginner in databases, but i got a project for a clinic.
This is what worry me.
Designing a database with medical data is not a matter for beginners otherwise than for learning purpose. Such a database is full of pitfalls.
- Security: check if access is authorized
- Security: prevent massive access to data.
- Security: backups
- Design: Most data must have history
- Design: keep track of who made changes
and so on