Results 1 to 2 of 2

Thread: 2nd and 3rd Normal Form??

  1. #1
    Join Date
    May 2012
    Posts
    3

    2nd and 3rd Normal Form??

    Hi, My table MortgageBank does not satisfy 2nd and third Normal form. How about if I create a composite key between MortgageBankID and SocialSecurity tables? There is a many-to-many relationship between MortgageBank and the following three tables Address, LoanInformation, Employer tables. In addition there is a one-to-one relationship between MortgageBank and CreditHistory tables.


    I hope someone can help me!!

    Thanks
    Attached Images Attached Images

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •