Relationship-in-Ms-Access

Relationship-in-Ms-Access

Transcript

1. RELATIONSHIP IN MS-ACCESS
2. 2 ONE-TO-ONE
3. 3 Tables before making Relationship HERE, Each record in table 1 has exactly one associated record in Table 2. Thus, the relationship will be 1 to 1
4. 4 Making 1 to 1 Relationship
5. 5 Tables after Making Relationship
6. 6 ONE-TO-MANY
7. 7 Tables Before Making Relationship HERE, Each record in table 1 has many(more than one) associated record in Table 2. Thus, the relationship will be 1 to Many
8. 8 Tables Making 1 to Many Relationship
9. 9 Tables after Making Relationship
10. 10 MANY- TO- MANY
11. 11 Tables Before Relationship Suppose a condition where, each Employee can have multiple projects and Each project can have multiple Employee then, The relationship will be Many-to-Many. To address such relationship we need third table. Here we use Table-3 to associate Employee and Projects
12. 12 Tables Making Many-to-Many Relationship 1-TO-MANY AND MANY-TO-1 YIELDS MANY TO MANY
13. 13 Tables After Making Many-to-Many Relationship PERSPECTIVE FROM EMPLOYEE
14. 14 Tables After Making Many-to-Many Relationship PERSPECTIVE FROM PROJECT