Need Help - Normalization

[santu_29]

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}

[Garbage]

At first quick look, these tables seems to be in 3NF.
Only I've checked for Primary Key, Foreign key. I've also checked (some) tables for dependencies.

SORRY, but I have to check in details.
But as of my experience, it may be in 3NF.

[santu_29]

Originally Posted by shirish_nagar

At first quick look, these tables seems to be in 3NF.
Only I've checked for Primary Key, Foreign key. I've also checked (some) tables for dependencies.

SORRY, but I have to check in details.
But as of my experience, it may be in 3NF.

please please please check it in detail.. itll help me get some grasp on normalization cos thats where i always get messed up. thanks
p.s.- fields with suffix 'id' are the primary keys and foreign keys.

can get the tables here > http://pastebin.com/m5088a88c