Design Database (Collection of tables) for below scenario
Design a DB for an organization to store information about their employees. The organization has office across world and has various departments like accounts, HR, Business Consulting, Software department… etc. Every emp works for a department. It also requires to capture the details of projects (like project name, project start date, project end date, client ,.. etc.). After design completes, relate the tables. (Tables creation script or DB diagrammatic approach is also appreciated).