Metodicheskie ukazaniya ka laboratornyim

Laboratornaya rabota ÿ 1. BASA DANNYX "MEDItsINSKAYa
KARTOCHKA"
Klyuchevoe pole – pole, dannye v kotorom primenyayutsya uchun
svya zi s drugimi tablitsami v baze dannyh. Tablitsy -
struktura dannyh, v
kotoroy kajdyy element opre delyaetsya svoim raspolojenieem
otnositelno dori elementlar. Tab litsa soderjit opredelennoe chislo stolbtsov
va strok, na pereschenii kotoryh nahodyatsya kletky. V kletki zapisyvayutsya
chisla, simvoly, tekst va drugie dannye, opredelyaemye svoystvom polya.
V baze dannyx stolbtsy tablitsy yavlyayutsya polyami, a stroki - zapisyami.
Polya, neobxodimye dlya opisaniya lecheniya bemorga v statsionar:
1. Tsel raboty
Priobretenie prakticheskix navykov v postroenii bazy dannyx bemorov
lechebno-profilakticheskogo uchrejdeniya.
2. Teoreticheskie osnovy va
opredeleniya Baza dannyx (BD) –
sovokupnost svyazannyx dannyx,
organi zovannyx po opredelennym pravilam, predusmatrivayushchim
obshchie tamoyillari opisaniya, xraneniya va manipulirovaniya, qabul
qilinmagan dasturlar. Baza dannyh yavlyaetsya informatsionnoy mo delyu
predmetnoy oblasti. Obrashchenie k bazam dannyx osushchestv lyaetsya
s pomoshchyu tizimi boshqaruv bazami dannyh (SUBD).
- Lichnyy nomer (klyuchevoe);
- Nomer bemor;
Machine Translated by Google

---

Polya, neobxodimye dlya formy «Pervichnyy osmotr»: -
Lichnyy nomer; - FIO; - Anamnez; - Dannye osmotra.
Polya, neobxodimye dlya formy «Stationar»: -
Lichnyy nomer; - FIO; - gospitalizatsii ma'lumotlari;
- Anamnez; - Dannye osmotra; - Lechenie; - Technie
bolezni;
- gospitalizatsii
ma'lumotlari; - Anamnez;
- Dannye osmotra; -
Lechenie; - Technie
bolezni; - ma'lumotlarni
o'chirish; - Epikriz. Polya,
neobxodimye dlya
identifikatsii bemorlar: - Lichnyy nomer (klyuchevoe);
- FIO; - Pol; - Data rojdeniya; - Mesto rojdeniya;
- Domashniy adres.
Polya, neobxodimye dlya
formy «Registratura»:
- Lichnyy nomer;
- FIO; - Data
rojdeniya; - Mesto
rojdeniya; -
Domashniy manzil;
- gospitalizatsii
ma'lumotlari; - Pol.
5
Machine Translated by Google

---

ÿ Sozdat dve tablitsy: "Meditsinskiy osmotr" va "Identifika tsion
pasienta" (ris. 1), ispolzuya spisok neobxodimyx poley dlya za polneniya
dannyx tablits.
ÿ “Identifikasiya” va “Meditsinskiy os” jadvali bo‘yicha “Nomer
patsient” bo‘yicha klyuchevomu polyu bo‘yicha Svyazat tablitsy
- ma'lumotlarni
o'chirish; -
Epikriz. 3. Poryadok
vypolneniya
ÿ
Sozdat
novyy pustoy fayli MS Acsess dasturida
dannyx.
motr».
ÿ Sozdat formasi (2-qism) va stranitsy dostupa k dannym (3-rasm),
soderjashchie polya, registratury uchun neobhodimye, pervichnogo os
motra va statsionara.
6
Ris. 1. Process sozdaniya tablitsy
Machine Translated by Google

---

Ris. 2. Process sozdaniya formy
Ris. 3. Process sozdaniya stranitsy dostupa
ÿ Osushchestvit vvod proizvolnyx dannyx o bemorax v bazu
dannyx i proverit eyo rabotu.
7
Machine Translated by Google

---

vvedyonnymi dannymi.
o Vyvod po rabote. 5.