Dear, sir
I read you description and already studied.
If you want , I'll send you a good result soon.
this is my example.
1NF - bill( pname, pno, address, csz, datead, datedisc, itemcode, description, charge)
– ( was selected a the Primary Key)
|
| - Remove Partial Dependencies ( Partial dependencies can occur when you have
A concatenated primary key) where part of the PK determines non-key attribute values.
| (no partial dependencies)
2NF - patient (pno, pname, address, csz, dateAd, dateDisc)
item ( itemcode, description)
bill (pno, itemcode, charge )
|
| - Remove Transitive Dependencies (Transitive dependencies happens when
A non-key attribute determines the value of another non-key attribute.
|
3NF - patient (pno pname, address, csz, dateAd, dateDisc)
item ( itemcode, description)
bill ( pno, itemcode, charge )