Database Design for Medical Clinic Management Website

Asem AS 50 Reputation points
2023-08-01T13:03:52.0033333+00:00

Hello,
I am working on the back-end of a medical clinic management website using C# and SQL Server database. This website allows any doctor to create an account, which includes all the necessary procedures for their clinic, such as patient files, visits, and accounts.

"If there are 100 doctors creating an account for their clinic on the website, should a separate database be created for each doctor during the account creation process, or should a single database be created for all doctors.
What is the correct way to create a database that does not affect the website's speed if there are more than 100 connections to the database?"
I would appreciate your advice on this matter."

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,437 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,283 questions
{count} votes

Accepted answer
  1. Amira Bedhiafi 28,381 Reputation points
    2023-08-01T19:46:19.3233333+00:00

    In a medical clinic management website using C# and SQL Server, it is recommended to create a single database for all doctors instead of separate databases for each doctor. This approach simplifies maintenance, improves scalability, ensures data integrity, and optimizes resource utilization. To maintain the website's speed with over 100 connections to the database, implement strategies such as indexing, connection pooling, caching, query optimization, load balancing, hardware provisioning, and regular database maintenance to optimize performance and efficiently handle the increased workload.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.