Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 [Concepts] Natural join in ERD

Author  Topic 

Ce.Student
Starting Member

1 Post

Posted - 2013-01-10 : 11:33:23
Hi, With respect
According to this diagram:



And the following information:
- 200 records in the Employee entity
- 5 records in Project entity

In your opinion,
What is the minimum and maximum number of records to Natural join these two entities? Minimum = 200 and Maximum = 1000 ? or Minimum = 0 and Maximum = 1000 ? and Why?

Thank you very much
   

- Advertisement -