santu_29
Journeyman
Can anyone check if the following tables of a database satisfy 1st, 2nd and 3rd normal forms, Thanks..
Tables :-
Patient = {pat_id, pat_name, pat_age, pat_sex, pat_weight, pat_height, date_id, opd_no, pat_father, pat_dob, pat_religion, appt_id, pat_addr}
Employee = {emp_id, emp_id, emp_name, emp_age, emp_sex, dept_id, emp_post, emp_desig,emp_pass}
Department = {dept_id, dept_name, dept_now, dept_hod, dept_non, dept_nod, emp_id}
Bed {bed_no, dept_id, bed_status}
OT {ot_id, dept_id, ot_non, emp_id}
Appointment = {appt_id, emp_id, dept_id, ot_id}
Date = {dof, dos, doa, dod}
Casesheet = {pat_id, cr_no, er_id, ir_id, mc_id, tr_id}
Inventory = {inv_id, inv_type, inv_quant, inv_name}
Order = {order_id, order_status, emp_id}
Record = {cr_no, er_mod, er_started, er_stopped, bl_id, ps_id, mc_id, er_rec}
Blood/Serum Chart = {bl_id, hb, tlc, dlc, platelets, hematocrit, esr, rbc_indices, na_k_cl, t_ca/ion_ca, phosphate, urea, sgot, total_protein, blood_sugar}
Peripheral Smear = {ps_id, microscopy, sugar, ph/ketones, stool, cells, uva_cysts, occult_blood, fat, csf, tcc, protein, latex, hiv, dengue, urine, stool, stool_ph, x-ray, usg, ct}
Monitoring Chart = {mc_id, mc_time,mc_date, temp,hr, crt, bp, lc, grunting, cyanosis}
Tables :-
Patient = {pat_id, pat_name, pat_age, pat_sex, pat_weight, pat_height, date_id, opd_no, pat_father, pat_dob, pat_religion, appt_id, pat_addr}
Employee = {emp_id, emp_id, emp_name, emp_age, emp_sex, dept_id, emp_post, emp_desig,emp_pass}
Department = {dept_id, dept_name, dept_now, dept_hod, dept_non, dept_nod, emp_id}
Bed {bed_no, dept_id, bed_status}
OT {ot_id, dept_id, ot_non, emp_id}
Appointment = {appt_id, emp_id, dept_id, ot_id}
Date = {dof, dos, doa, dod}
Casesheet = {pat_id, cr_no, er_id, ir_id, mc_id, tr_id}
Inventory = {inv_id, inv_type, inv_quant, inv_name}
Order = {order_id, order_status, emp_id}
Record = {cr_no, er_mod, er_started, er_stopped, bl_id, ps_id, mc_id, er_rec}
Blood/Serum Chart = {bl_id, hb, tlc, dlc, platelets, hematocrit, esr, rbc_indices, na_k_cl, t_ca/ion_ca, phosphate, urea, sgot, total_protein, blood_sugar}
Peripheral Smear = {ps_id, microscopy, sugar, ph/ketones, stool, cells, uva_cysts, occult_blood, fat, csf, tcc, protein, latex, hiv, dengue, urine, stool, stool_ph, x-ray, usg, ct}
Monitoring Chart = {mc_id, mc_time,mc_date, temp,hr, crt, bp, lc, grunting, cyanosis}
