Create SQL Table and relationship
Posted on 2012-04-03
I have 2 tables:
(1)Customer Table: Cust_Name, Cust_Address, Cust_age…….
Order Table: Cust_Name, Ord_Qty, Ord_Price……..
When I filled Cust_name in Customer Table, how to auto fill the Cust_Name in Order table as well?
(2)If I create Employee table with Employee_ID, Employee_Name_Address, and Skill. An employee may
have more than one skill. Each employee may work in one or more work centers. A
work center must have at least one employee working in that center; but may have
any number of employees.
How to link many skill to the Employee table, create another table or just put skill1, skill2 as attribute?
I already have work center table consist of workcenterID, workcenter_location……..how to link many employees to 1 work center?