• 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?