Help Relationship

[nozbilenler]

I salute everyone

I'm sorry for missing English.

Tables

1.Customers

Customer id

Customer Name

Factory id

Factory Name

2. Suppliers

Supplier id

Supplier Name

Car Sticker

3. Routes

Route id

Route Name

Route price

4. Line Items

Scenario as follows:

1. Employees or workers moving to the workplace.

2. Suppliers carries.

3. Moving with the bus or minibus.

4. Moving predetermined routes.

5. The customer can be more than one factory.

6. Price particular route

7. Monthly report is given to the customer.

8. How the relationship should be here?

9. Factories how customers should be separated?

10. The route is going relationship with the customer's factories.

[nozbilenler]

I salute everyone

I'm sorry for missing English.

Tables

1.Customers

Customer id

Customer Name

Factory id

Factory Name

2. Suppliers

Supplier id

Supplier Name

Car Sticker

3. Routes

Route id

Route Name

Route price

4. Line Items

Scenario as follows:

1. Employees or workers moving to the workplace.

2. Suppliers carries.

3. Moving with the bus or minibus.

4. Moving predetermined routes.

5. The customer can be more than one factory.

6. Price particular route

7. Monthly report is given to the customer.

8. How the relationship should be here?

9. Factories how customers should be separated?

10. The route is going relationship with the customer's factories.