database rumah sakit

1. TABLE DOKTER

CREATE table dokter(NIP text(10)PRIMARY KEY,NAMA TEXT(30),ALAMAT TEXT(40),NOTLP TEXT(13),SPESIALIS TEXT(12));

ISERT DATA

VALUES("0814594","HENDRA","JL.KELAPA GADING JAKARTA UTARA ","081901778283","KANDUNGAN")

VALUES("123456","JAKA","JL .WALI SONGO JAKARTA SELATAN","456789123456","THT")

VALUES ("123589456","UNA","JL.MARINA RAYA SEMARANG”

,"087123456854 ","PARU-PARU")

VALUES ("12478","BAGAS","JL.RADEN PATAH JAKARTA TIMUR”,"124578912 ","JANTUNG")

VALUES ("548796","DELA","JL .SULTAN AGUNG SEMARANG","123456789456","GIGI")

2. TABLE PASIEN

CREATE Table pasien(nopasien text(12)primary key,namapasien text(10),alamat text(12),notlp text(30),penyakit text(14));

INSERT INTO Pasien

VALUES("001","ANY","JEPARA","123456789456","HEPATITIS")

INSERT INTO Pasien

VALUES("002","BUDI","PATI","123456786987","JANTUNG")

INSERT INTO Pasien

VALUES("003","AYU","PATI","456789123456","DIABETIS")

INSERT INTO Pasien

VALUES("005","YAYA","PATI","123456856987","LAPAR")

CREATE Table transaksi(NOFAKTUR TEXT(9)Primary key,kddokter text(21),nmpasien text(13),penyakit text(6),lamainap text(15));

3TABLE TRANSAKSI

INSERT INTO TRANSAKSI

VALUES ("001","4594","ANY","HIPATITIS","2MINGU")

INSERT INTO TRANSAKSI

VALUES ("002","123456","BUDI","JANTUNG","5MINGU")

INSERT INTO TRANSAKSI

VALUES ("003","123589456","AYU","DIABETIS","7MINGU")

VALUES ("004","124578","LINDA","MERIANG","8MINGU")

VALUES ("005","548796","YAYA","LAPAR","7MINGU")