Hi Team,
I am working on Oralce 11g, I am creating a patient insurance table.
Outline is
Patient Can have more than one insurance Id and there can be more than one guarntor for each insurance.
I designed below table and trying to understand if does this deviates from 3NF.
create table ptnt_insr_grntr_details
(
ptnt_insr_grntr_id int primary key,
ptnt_id int,
insr_id int,
grntr_id int,
created_by varchar(100),
update_by varchar(100)
)
Your suggestions are helpful.
Thanks