Question

microsoft access

i am asked to create a relationship but im not sure how to add the second one

Create a relationship between the EMPLOYEES and EMPPURCHASES. Create a second relationship between the PRODUCTS table and the EMPPURCHASES table.

Answer 1

You can create the three tables as :

EMPLOYEE

ID	NAME
01	Frank
02	Steven
03	Mary

EMPPURCHASES

Purchase id	Employee_ID	Product_ID
01	01	03
02	01	02
03	03	03
04	02	01

PRODUCTS

ID	Name
01	keyboard
02	mouse
03	headphone

This way you can create a relationship between them

employee and emp_purchase have relation as per employee id which is primary key in employee table and foreign key in emp_purchase

products and emp_purchase have relation as per product id which is primary key in product table and foreign key in emp_purchase.

In the purchase table we can see that one employee can order multiple products, also one product can be order by multiple employees

Thanks...