title: Is the normalization correct?
body: <p>I have a list of attribute and I am trying to find out 1NF,2NF,3NF,BCNF, 4NF 
   The list of attributes are:</p>
  
  <pre><code> - Pat_Name    
   - Pat_Address
   - Pat_Num
   - Pat_Dob
   - Pat_Gender
   - Pat_MotherName  
   - Pat_FatherName
   - Doc_Name  
   - Doc_Address
   - Doc_HomeTel
   - Doc_MobTel
   - Doc_Qualification
   - Doc_Dob
   - App_Date
   - App_Time
   - App_Doc
   - Visit_Date
   - Visit_Time
   - Visit_Reason   
   - Diagnosis
   - Prescription
   - DateOfBill
   - TotalBillCharge
  </code></pre>
  
  <p>In First Normal Form I got:</p>
  
  <pre><code> Patient (Table)     -&gt; Pat_ID,Pat_Name,Pat_Address,Pat_Num,Pat_Dob,Pat_Gender,Pat_MotherName,Pat_FatherName
   Doctor  (Table)     -&gt; Doc_ID,Doc_Name,Doc_Address,Doc_HomeTel, Doc_MobTel,Doc_Qualification, Doc_Dob
   Appointment(Table)  -&gt; App_ID,Pat_ID,Doc_ID,App_Date,APP_Time,Visit_Reason,Diagnosis,Prescription,DateOfBill,TotalBillCharge
  </code></pre>
  
  <p>In 1NF :</p>
  
  <p>I have been confused with Visit_Time and Visit_Date (Is it similar with Appointment_Time &amp; Appointment_Date).Looks to me similar so I removed Both of that.Is it I am doing correct or should i make new table for visit (Really need help on this)?
  I have been created new attribute for identify primary key.</p>
  
  <p>2NF:</p>
  
  <p>Table Patient Do not have any partial Dependency (Am I correct ?)
     Table Doctor  Do not Have any partial dependency (Am I correct ?)
     Table I got Partial Dependency, So, I separate another table called visit</p>
  
  <pre><code>   Appointment -&gt; App_ID,Pat_ID,Doc_ID,App_Date,APP_Time
     Visit       -&gt; App_ID,Visit_Reason,Diagnosis,Prescription,DateOfBill,TotalBillCharge
  </code></pre>
  
  <p>In 3NF:
     Table Patient and Doctor I did not found any transitive dependency 
     In Table Visit Have transitive dependency so I separate it to  new table bills </p>
  
  <pre><code>Visit -&gt; **App_ID**,Visit_Reason,Diagnosis,Prescription_ID     //(I created new Attributes here, is this correct ?)
  Bills -&gt; Prescription_ID, DateOfBill, TotalBillCharge
  </code></pre>
  
  <p>Any help is appreciated. :) </p>