database help

[janu123]

i ve told to create a database as follows
1. Create three Tables:

First table should contain customer information
Second table should be a junction table to create a many-to-many relationship between two tables. You can add more fields in this table as required.
Third table can contain supplier, product, and service information.


I pretty much did this part and made the required validations...the problamatic part is the following



1. Create a query to display the name of the products, services, suppliers (or as according to the third table you have created) that relates to more than one customers, along with the name of the customers in a systematic way.
2. Create a query to display the name of the customers who have more than one transaction (entity relation) in the third table, along with the list of the entities (products, services, suppliers)

H Please someone tell me how to do the query .........this is a extra credit question and i have to do it by research .....just explain me how to do it i really appreciate it........i attached the databased i did.....and a screen shot on my relationships and the tables







1.

[pdebaets]

It sounds like this is for a class that you are taking. My advice would be to actually do the research yourself, otherwise what is the point of taking the class?

FYI: From your relationship diagram, it appears that an order can contain at most one product.