Question

Subject: Database

Notes: Please give me detailed answers so I could learn from this. Thank you.

PS: This is a homework that I already submitted but did not know whether my answer is right or wrong.

to explain some questions given below. pasienfidPasien varchar, namalengkap varchar, bukandung varchar, tgl Lahir date, alamat varchar) . dokter(idDr varchar, nama Lengkap varchar, spesialisasi varchar, tarip.per konsul UNSIGNED INT) • ruang(idRuang varchar, namaRuang varchar, biaya-per-hari UNSIGNED INT) ranap(idPasien varchar wktMasuk timestamp, wktKeluar datetime, id Dr varchar, id Ruang varchar). This table is used to store transactions regarding to in-hospital treatment. The column wktkeluar will be given NULL value to represent the case when the patient is still treated or hospitalized. 1. Weight: 15%. What do you know about referential integrity in a relational database? And what are the impact of a database which does not satisfy referential integrity constraint?

Pasien=Patient, namaLengkap=FullName, ibuKandung=biologicalMother, tglLahir=birthDate, alamat=address, dokter=doctor, spesialisasi=specialization, taripkonsul=consultingFee, ranap=inpatient, wktMasuk=enterTime, idRuang=idRoom, ruang=room, namaRuang=roomName, biaya=fee, wktKeluar=outTime,

Answer 1

Referential integrity means that the data is stating that all the references that it is making to another data are valid for example we use primary key and foreign key to refer to the another table in the database which makes it easier for us to establish relations between the tables and easily extract data from them using their relation and using referential integrity. is the referential integrity constraint is not met there will be consequences of data being redundant or biggest consequences will be that the data will be pointing to null value for exampleif the references of the data for a column of a table are not valid then it will be pointing to the data that does not exist and will create confusion within the database and might even cause data loss.