0

I am totally new to the MySQL. There are 5 different types of relationships in MySQL:

1:1 Non-identifying 
1:n Non-identifying 
1:1 Identifying 
1:n Identifying
n:m Identifying

how to know which one to select, and what is the difference between identifying and non-identifying.

Thanks you...

user2864740
  • 60,010
  • 15
  • 145
  • 220
Rami
  • 1
  • 1
  • It depends on the problem/domain being modeled. Might want to start with a SQL/RDBMS/RA book.. and some paper to 'scratch model ideas on'. As far as the second question, see http://stackoverflow.com/questions/2814469/still-confused-about-identifying-vs-non-identifying-relationships – user2864740 Mar 05 '15 at 18:06
  • ... also Wikipedia has an article about identifying vs non-identifying. – Mike Lischke Mar 06 '15 at 08:05
  • "Identifying" is a term invented by a professor with nothing better to do. I've been working with databases for 25 years, and have not encountered that term until now. – Rick James Mar 07 '15 at 19:46
  • You can go a long way by understanding only two patterns: 1:n is implemented a link in one table to the other table. n:m is implemented by an extra table with ids linking to the existing 2 tables. – Rick James Mar 07 '15 at 19:49

0 Answers0