Okk now
for 2nd Employee it would be
Workplace code-2
WRegNum-098-098 (Company reg Number) (It will be same )
WorkplaceName- Oracle Inc
NumOfEmplouees-1000
EmpName - 'Bill' (I get emp name from Employee table using EmpNumber which is FK to workplace table and using this only to get emp name)
[address -x-102,abc, Newyork
email -x@yz.com
Ph: 01-87483284] (I get address details from Address table and address_id is FK to Workplace table using this only to get address details of company)
So Workplace code is changing with each and every employee also address and everything
is what you are saying?