W
W
warchant2015-08-01 00:01:23
Database design
warchant, 2015-08-01 00:01:23

What to do with four programmers on the weekend?

There are four student programmers available, what can you do on a lonely weekend? ;)

Answer the question

In order to leave comments, you need to log in

3 answer(s)
K
Konstantin Tsvetkov, 2019-01-02
@tsklab

create table EmployeesInfo(
  ID int not null,
  MaritalStatus varchar(10) not null,
  BirthDate date not null,
  [Address] nvarchar(50) not null,
  Phone char(12) not null
)

A
asd111, 2015-08-01
@asd111

Make an electronic medical record - i.e. corny database for storing medical data about a person - all medical examinations, all diseases, all tests, education, place of residence, height, gender, etc. More data so that more statistics can be collected, and an interface to this database so that you can add new patients, add medical examinations, tests, detected diseases, prescribed treatment for each patient, etc., and so that the patient can always view his medical information via the Internet card, and so that any doctor can see and change it when a person is at his appointment, and so that tests are added there as soon as they are ready. It may sound strange, but there is nothing similar at the federal level in Russia.
And we also need a system for electronic diagnosis of diseases - at least just by a set of symptoms, i.e. for example, it hurts on the left side of the abdomen, after eating, etc. - and the computer answers - most likely your illness is such and such. Official, i.e. Again, there is no such system. You can see something similar here simptomus.ru , but while their system is not officially recognized, the state. system and in any case, if you do it, then you need to do it yourself. you need to interact directly with doctors and with their textbooks.
Also make an automated office of a diagnostician, where there is no doctor, but there is only a computer and he carries out diagnostics without the participation of a doctor. Those. a person enters a doctor's office (for example, an ophthalmologist) and the computer says to him:
"Good afternoon. What are you complaining about?"
And the person answered:
“My eyes turn red when I sit at the computer, my vision has deteriorated a little, sometimes it feels like something has got into my eye.”
Then the computer says:
“Let's check the vision according to the table
” the person answers
the computer records the data on vision and says:
"Sit down in front of such and such an apparatus"
and there is an apparatus for determining accommodation spasm, strabismus, etc.
the computer determines the jambs with the help of the apparatus and records the results
. Then the computer tells the person based on the results of the apparatus and the table:
"You have such and such a disease (for example, computer syndrome)" and prints out a page with complaints, the results of hardware examinations, and most importantly, how it is treated - drops of vidisik, systain, oftagel, etc.
And most importantly, all this data: complaints, hardware and other diagnostics, a certain disease, prescribed treatment, is recorded in the database, which I wrote about above, i.e. in the patient's electronic medical record.
If you do it and promote it on the Russian market, it will be very cool.

D
Don Kaban, 2015-08-01
@donkaban

Believe me, four programmers, if they have work on weekdays (well, this is when you do something for money from 8 hours a day) - you need to rest on weekends. How exactly to relax - choose for yourself, temperament, resistance to alcohol and love for sports, for example, are important here. If four programmers come up with something interesting to program on the weekend, they need to change jobs. For an interesting one.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question