Job tracking system

[Yogesh Nath]

I want to create a simple job tracking system. I have created 4 tables called "Job (job_id as PK)", "Customer (customer_id as PK)" "Employee (Employee_id as PK)" and "LineItem (LineItem_id as PK, Job_id(FK), Employee_id(FK), Customer_id(FK))".

Is this the way to go?

Are all the tables simply joined to the LineItem table via Foreign Key?

Please help. Thank you kindly.

Edited April 30, 2007 by Guest