Normalize to first normal form 1st NF then to second normal form 2nd NF then to third normal form 3rd NF

 

Transcribed Image Text:

ERD Modified ER Diagram for Dr. Online. N Position Ponto Pos Name Pos Description N 1 Dector Dec BIOData PosID Spec ID UserName Pa 0 Doc ID Rating Rat 10 Rat Date Rat Rating Rat Comment N N 1 1 Specialty Bone D Spec_name Spec Desc User UserName Password Date Created FName LName N Date Created [UserType (D (FC) Patent PILO Pat Condition UserName O N 1 N N MTID Date Created Approved Te Spec 10 Type D UserName Topic Hep 0 Reply Reply Date TID UserName Reply N End Date Pat 10 Med ID Patient Medicine Start Date N Topic Type 1170 T.Name Description User Type User Type 10 UserType Name UserType Description 1 Medicine MID Med Name Med Description Med Price ERD Modified ER Diagram for Dr. Online. N Position Ponto Pos Name Pos Description N 1 Dector Dec BIOData PosID Spec ID UserName Pa 0 Doc ID Rating Rat 10 Rat Date Rat Rating Rat Comment N N 1 1 Specialty Bone D Spec_name Spec Desc User UserName Password Date Created FName LName N Date Created [UserType (D (FC) Patent PILO Pat Condition UserName O N 1 N N MTID Date Created Approved Te Spec 10 Type D UserName Topic Hep 0 Reply Reply Date TID UserName Reply N End Date Pat 10 Med ID Patient Medicine Start Date N Topic Type 1170 T.Name Description User Type User Type 10 UserType Name UserType Description 1 Medicine MID Med Name Med Description Med Price