Best approach for a clinic database

Posted by user18013 on Programmers See other posts from Programmers or by user18013
Published on 2014-06-09T00:42:05Z Indexed on 2014/06/09 3:41 UTC
Read the original article Hit count: 417

As a practical assignment for the database course I'm taking I've been instructed to create a database for a local clinic, I've meet with the doctors a couple of times and discussed the information that needs to be stored in the database from personal to medical.

Now I'm facing a tough decision because I've been given two choices: either to implement the database as a "local website" which only operates inside the clinic via WiFi, or to implement the front-end as a regular desktop application connecting to a shared database.

Note: I've a 40 days deadline to deliver the first prototype and meet with my client.

My questions are:

1- which approach should I go with given that I've more experience with desktop applications programming than web?

2- if I go with desktop front-ends what would be the best way to synchronize the database between all clients?? I've no experience and having searched for an answer a lot but came up with nothing detailed on this matter.

3- if I go with the web solution which choice would be best PHP & MySQL or ASP.NET & SQL Server or a different combination?? (given that my knowledge in both PHP & ASP.NET are nearly the same).

© Programmers or respective owner

Related posts about web-development

Related posts about database