Database nad simple question ( relations )

dexter90 · #1 (**permalink**) 11-30-12, 06:15

Hello!

I have some tables:

- CLIENTS,
- EMPLOYEES,
- INVOICES,
- BILLS,

My idea on relation is:

One CLIENT may have one or more INVOICEES or BILLS and one EMPLOYEE may issue one or more INVOICCES or BILLS, then:

CLIENTS --------------------< INVOICEES >-------- EMPLOYEES
|
|
|
|
^
BILLS > --- ( line to table EMPLOYEES )

I greet.

papadi · #2 (**permalink**) 12-01-12, 23:25

What columns and keys have you defined for these tables?

Internet Services

Web Development

Digital Marketing

Consumer Tech