The business intelligent tool in Excel
In a sports club with 50 members, 35 play badminton and 27 play tennis and 5 do not play either. How many members play both badminton and tennis?
Identify the number of members play both badminton and tennis as x. 35+27-x=50-5 62-x=45 x=17
How to created ERD diagram?
1.Recognize the Entity 2.Clarify relationships and business rules among entities. 3.Draw a single ERD 4.Finalize ERD